Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2002
    Location
    melbourne, Victoria, Australia
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatically filling a column (XP)

    Does anyone know how I can fill a formula from say D5 say to D500+ without having to select the cells first, or without using the Autofill manually? I have tried various things but it just won

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Automatically filling a column (XP)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> lisbry

    I would suggest:

    1) Goto ,F5, D5500
    2) Type your formula in D5
    5) Hold CTRL and Enter

    OK fast enough for you?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Star Lounger
    Join Date
    Jul 2002
    Location
    melbourne, Victoria, Australia
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically filling a column (XP)

    Not quite what I want to be able to do. I don't want to specify a range as this will change every time I use this spreadsheet. I know what I did was, I went to a cell and entered a formula, pressed a shortcut key (i wish I can remember) and it filled down the colum without me entering any range of without using the Autofill. It knew what column based on the label to the left. Does anyone know the shortcut key. I hope you can understand what I am trying to achieve.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically filling a column (XP)

    If you have data in say A1:A500 and a formula in B1, then double clicking on the fill handle for B1 (black cross when you put the cursor over the bottom right corner of B1) will fill down to B500, is this what you are thinking of? It also works if your data is to the right of your cell containing the formula.

  5. #5
    Star Lounger
    Join Date
    Jul 2002
    Location
    melbourne, Victoria, Australia
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically filling a column (XP)

    Thanks for that, that exactly what I am trying to achieve. Thanks for all your help.

Posting Permissions

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