Re: How to apply a formula to all cells in a column

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <Gillian_White@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:goBWf.197841$sa3.61277@xxxxxxxxxxx
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



.

Relevant Pages

  • Re: Adding an "X" or Check to a cell by clicking on the mouse
    ... And format that range of cells as Wingdings ... Hit the delete key on the keyboard to clear the cell. ... "X" or a check mark appears. ... to see when I get to the bottom so that I know which type and size boxes to ...
    (microsoft.public.excel.misc)
  • Re: Removing List from Cells
    ... then use Data|Validation and hit the "clear all" button on the bottom of ... "undrline via OfficeKB.com" wrote: ... drop-down list you've created for a group of cells, ...
    (microsoft.public.excel.misc)
  • Re: How do I make the smallest number in a column red ( No VBA Please )
    ... number I enter in each of those cells to be red. ... Select 'Format only top or bottom ranked values' ... In the bottom section ... Click the 'Font' tab ...
    (microsoft.public.excel.newusers)
  • Font color in gnome panel
    ... how can one change the color of the font that ... is used in the gnome panels (top and bottom)? ... Hit me with music now. ...
    (Debian-User)
  • Re: Change Empty Cells Font for the Entire Workbook
    ... Tom's advice to change the style to Tahoma has to ... if a user subsequently clears formats the font will ... > One thing though, if the "Normal" font is still set to> Arial, if a user subsequently clears formats the font will> revert to Arial. ... Comic Cells will remain Comic, Tahoma cells will> remain Tahoma, all unformatted cells will adopt the new> Normal/Tahoma. ...
    (microsoft.public.excel.programming)