Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to apply a formula to all cells in a column
Until now, I have copied a formula to all the relevant cells in a column by
clicking on the bottom right corner and dragging down through the rows. What I need now is to apply the formula to ALL cells in a column. I don't want to have to hold and drag down through 65000 rows. Is there any menu option I can use to write the formula I need in cell A1, then have it automatically apply to cells A2 through A65000 (or whatever the end row value is). Thanks for any help. Gillian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Subtraction formula for consecutive cells in a column, skipping blanks | Excel Worksheet Functions | |||
Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |