How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Viet -MS Office Tech Your Own Question
Viet -MS Office Tech
Viet -MS Office Tech, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 36462
Experience:  Ten years of computer hardware and software support; Windows 10 8 7 Vista XP & Mac; Microsoft Office, etc.
30037186
Type Your Microsoft Office Question Here...
Viet -MS Office Tech is online now
A new question is answered every 9 seconds

I want to copy a cell or a column say cell A1 to cell A2 to

This answer was rated:

I want to copy a cell or a column say cell A1 to cell A2 to A51478. It takes ages to do this with copy paste. Before you where abel to copy by simply writing A2:A51478.

Hi, I will assist,

I'm sorry about the issue. Have you tried the following:

 

  1. Select the cell you want to copy from, for example, cell A1
  2. Press at the same time the two keys Ctrl and C keys to Copy
  3. Press at the same time the two keys Ctrl and G and it will show the "Go To" box
  4. In the Reference box, type in the range of cells you want, such as,
    A2:A51478
  5. Click OK.
  6. Press at the same time the two keys Ctrl and P to paste. That should work.

 

 

Another way:

 

 

  1. Select the cell you want to copy from, for example, cell A1
  2. Press at the same time the two keys Ctrl and C keys to Copy
  3. Select/highlight the range of cells you want to copy to, i.e., cell A2 to cell A51478. (Or to select/highlight the whole column, click on the column letter on the top, for example, A)
  4. Press at the same time the two keys Ctrl and P to paste.

 

If it does not work, or if you'd like to, we can set up a screen sharing session, so I can show you how to do this directly. Please let me know.


Edit: It looks like you've gone away; please reply back when you are available to continue. Thank you,

Viet -MS Office Tech and other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions