Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Win 95/Of95 (SR1)

    Re: Fill a range of cells with related data such as days of the week and months of the year.

    First type January into a cell. Now select the cell and position your pointer over the bottom right hand corner of the cell so it changes to a small plus symbol, grab it with your mouse and start dragging. I should get the months of the year, but I just get January repeated.

    What am i doing wrong?
    >

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Win 95/Of95 (SR1)

    Go to Tools, Options and select the Custom Lists tab and check to see if there is an entry for the lists you want to autofill. If not you can add your own lists.

    Hope that helps you out.

    Andrew C

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

    Re: Win 95/Of95 (SR1)

    In addition to what Andrew said, make sure you are spelling January correctly. Also try right clicking on the fill handle and dragging it down. When you release the right button, click on Series in the pop-up menu.
    Legare Coleman

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Win 95/Of95 (SR1)

    It's quite simple actually - you're simply telling XL to repeat the contents of the cell without giving it any reason to change as you go along. Type February in the next cell, then select *both* cells, grab the + and drag - now it knows you want to increment by months and it does so. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    HTH
    Beryl M


  5. #5
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Win 95/Of95 (SR1)

    Great! Thanks to all for the help.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Win 95/Of95 (SR1)

    If you drag the fill handle with your right mouse button, you'll get some options to choose from as soon as you let go of the button.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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