I am looking for a tip here:

All the time working in Excel, I am copying formula's down through hundreds of rows. In order to action this I

1. Starting from the cell I am going to copy, I then
2. Go to the next continuous, unbroken, column of data
3. Select end & down
4. Go back across to the column I am filling
5. Input a period / full stop, " . "
6. End up (takes me back to the original cell to be copied.
7. Select Copy (Ctrl-C),
8. End & Down
9. Enter.

Is there a quicker way of doing this ?

I seem to remember from Lotus 1-2-3, from 20 odd years ago, this was alot easier.


(Whilst, we are there, as a quick one: in 1-2-3, I could have a cell on a page whose content was visible, but would not print because (from memory) I have put a "|" at the start of the cell. Can I do this at all in Excel ).


Thanks