Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fill Custom (2007)

    I am studying for an exam and have a practice question I can't figure out. It states, create a custom series using the names entered in cells B2:B7. Fill the series in each row to create a rotating duty roster for the two weeks.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Fill Custom (2007)

    Select the range with names (B2:B7)
    Click the Office button and select Excel Options.
    Select the Popular category.
    Click Edit Custom Lists.
    Click Import.
    Click OK twice to save the custom series and to return to Excel.

    Click in B2 and fill right to F2.
    Repeat for B3 etc.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Fill Custom (2007)

    Though not necessary for your question, it is interesting to note that once a custom list is created, you can also use it for sorting purposes. IOW, you can sort using a custom sort order, based on the order of items in your custom list. Though not used much it is weird to think that Excel can sort beyond the alphabetical, numerical and chronological. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rudi

Posting Permissions

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