View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach
 
Posts: n/a
Default Copy a formula down a column

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