Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to copy text from a column in different workshhets | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Way To Copy Formula In Column Without Changing All Cell Numbers | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |