Copy & paste
 

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....

Copy & paste
 

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

--
__________________________________
HTH

Bob

"Unknown User" <Unknown wrote in message
...
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....