RE: Copying forumlas down

Hello James,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding copying a formula down without using a mouse. First of all, why would you not want to use the mouse, since it takes only 1 second to copy down no matter how far down you need to copy. All you have to do is double click the small square at the bottom right corner of the cell (mouse must be a thin cross) and this will copy the formula down the length of the data.

To do the same thing without a mouse takes many steps which is counter productive. But if you want to do it this way here goes.

1) First you need to know the full range that your formula is going to be copied into. e.g. G12:G144 The formula would be created into cell G11 and copied into the range. Before going onto the next step make sure that you have selected the cell where the formula has been created... i.e. G11

2) Open the Clipboard... Press Alt > H > FO > Esc > Ctrl + C to copy the formula in cell G11 and place into the Clipboard

3) Use GoTo to select the range as follows: Ctrl + G > type range i.e. G12:G144 into the Reference Area > Click OK

4) Ctrl + V > Esc > Up Arrow will take you back to G11

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer