Results 1 to 7 of 7
  • Thread Tools
  1. Star Lounger
    Join Date
    Aug 2004
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AutoFill without Dragging (Excel 97)

    Someone asked me a question today and I have no idea what to answer. I showed them how to use the fill handle to auto fill the word Yes down a column. As the column was quite large and they are not that good at dragging with the mouse, they wanted to know if there was a way to fill cells E4:E40 with the word Yes without dragging the fill handle. Hope that makes sense. Any ideas would be appreciated.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

    Re: AutoFill without Dragging (Excel 97)

    There are a couple of ways.

    1- If a column next to E has something in rows 4:40, then you can type "Yes" in E4 and double click the fill handle. Yes will be filled down as far as the data goes in D or F.

    2- You can type "Yes" in cell E4. Then select cell E4. Then scroll down to cell E40 and hold down Shift and click on cell E40. That should select cells E4:E40. Now, in the Edit menu click on Fill and then in the pop up menu click on Down. That should fill Yes from E4 to E40.
    Legare Coleman

  4. 3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutoFill without Dragging (Excel 97)

    If there is data in the column to the immediate left, double-clicking the fill handle will fille down as far as there is continuous data in the left column.

  5. Star Lounger
    Join Date
    Aug 2004
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutoFill without Dragging (Excel 97)

    Perfect, thanks! Didn't know about the double-click on the fill handle. That will work great.

  6. 3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutoFill without Dragging (Excel 97)

    sometimes, too, it's helpful to start highlighting from the bottom of the range and highlight up. I'm not sure what you meant by "they're not that good at dragging with the mouse", but maybe that would help them in other situations.

    Also, if they highlight the range they want to fill and then type in their data and confirm with <Ctl><Enter>, it will fill all the cells with the data they typed in, just as one other alternative...

  7. Star Lounger
    Join Date
    Aug 2004
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutoFill without Dragging (Excel 97)

    Oh I like that Ctrl Enter too. That is another great tip. Thanks!

  8. Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutoFill without Dragging (Excel 97)

    Finally, highlighting the cells and pressing Ctrl+D will fill E4 down as far as you want to go. (BTW Highlighting E4 out to say AC4 and pressing Ctrl+R will autofill horizontally.) [AFAIK there are still no Keyboard Shortcuts for filling Up or for filling from Right to left.] HTH
    Gre

Posting Permissions

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