Pete & Bob
Thanks for that. I knew that way back but haven't used it in a long time.
Otto
"Otto Moehrbach" wrote in message
...
Excel 2002, WinXP
I'm getting old and I forget.
Say I have Column A occupied from A1 to A5000.
In B1 I enter =A1 or some other formula.
I want to copy that formula down as far as Column A goes.
There is a way to do that without dragging through 5000 cells.
How? Thanks for your help. Otto