Copy & paste

U

Unknown User

Please help. What is the short cut to auto filled up the rest of the cell?
Example, cell A1 data will auto filled up from A2 to A20, A21 data will auto
filled up from A22 to A30, B1 data will auto filled up from B2 to B10, and
etc....
 
B

Bob Phillips

Go to the bottom right corner of the cell and when the cursor changes to a
black cross, drag the value down.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy formulas in Column 1
Finding Latest Variable 1
Entering a cell with Criterias 5
sort question 1
Formulas won't drag down the column 2
Copy data from unlocked cells 3
Need macro to move to first blank cell in column 6
How do I nest hyperlinks? 2

Top