Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Denver, Colorado, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    placing formula in whole column

    I was wondering if it is possible to place a formula in a full range of cells. Currently, I place the formula in the first cell and then drag it down through all the cells I want.

    Say you have a cloumn A of Sales figures and column B is Tax. In column C, I want Total so I place =a1+b1 in cell c1 and then drag it down for all the cells I need.

    Can I place it in those same cells in one step instead of the dragging?

    Thanks

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: placing formula in whole column

    Select all of the cells where you want the formula to appear. Type the formula in the top left cell. Hold down the Ctrl key and press Enter. The formula will be entered in all of the selected cells.
    Legare Coleman

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: placing formula in whole column

    Hi,
    You can also, depending on your version of Excel, double-click on the cross that you use to drag the formula down and it will fill the formula down (at least until it finds a gap in the column next to it).
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: placing formula in whole column

    Hey Legare, that's a pretty cool trick. I'm a trainer and supposed to be an expert in things Excel but I didn't know that one. Well done!!

  5. #5
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: placing formula in whole column

    Thanks for this trick
    (it is always good to look throu all the postings, you can learn a lot)
    Greetings,

    Patrick Schouten
    (The Netherlands)

  6. #6
    BAM
    Guest

    Re: placing formula in whole column

    A couple more along the same lines as the one Rory shared that utilizes double-clicking the edges of the cell pointer:

    Bottom: Bottom of a contiguous column.
    Top: Top of a contiguous column.
    Left: End of a contiguous row
    Right: Beginning of a contiguous row
    ~~~~~~~~~~~~~~
    Cheers!

    btw sorry if this is a duplicate post, I had difficulty with the first attempt.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •