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 Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31329
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

How do you copy a column formula which already had 6000

Customer Question

how do you copy a column formula which already had 6000 rows, to add further down another, say 6000 rows, without dragging (please and thank you)
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Richard replied 1 year ago.
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
You can highlight then press CTRL + C
Then click on the first cell to start the paste
And press CTRL + V to paste
This is the same method.
Customer: replied 1 year ago.
Well you're correct for basic copy/paste method, but your $5 answer STILL left me having to drag, which i wanted to avoid.I figured out another method; still extra work but a lot less time
Expert:  Richard replied 1 year ago.
There is no reason to drag... that was not part of my answer.
Why are you dragging?