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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to apply a formula to all cells in a column
Hi!
Enter the range in the name box: A2:A65000 then hit enter. That range is now selected. Type your formula in the formula bar. Hit CTRL, ENTER. Biff "Gillian White" wrote in message news:goBWf.197841$sa3.61277@pd7tw1no... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to apply a formula to all cells in a column
With the formula in A1, enter in the Name Box (the one just below the font,
it will show A1 if you're in A1) A1:A65000 or where ever you want to copy to and hit 'Enter', Select 'Edit' from the toolbar, 'Fill' 'Down' and hit 'Enter' again, Regards, Alan. "Gillian White" wrote in message news:goBWf.197841$sa3.61277@pd7tw1no... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to apply a formula to all cells in a column
If you want to reduce typing even more, click <copy on the cell, move
down one row, hold the <SHIFT key down and press <End once followed by <Down then release <SHIFT and press <Enter. Hope this helps. Pete |
Reply |
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 |