Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Houston, Texas, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fill Series (97/SP2)

    I cannot get Fill Series to work and don't know what I am doing wrong. I verified that the number in my starting cell is indeed a number, not text. I select that cell, extend the selection down, and click Edit - Fill - Series - OK (with Step Value = 1). Nothing happens. I've tried to do this using CTRL while selecting; I've tried right-clicking after I select (but get a popup menu that does not have Fill Series on it).

    Any ideas, please?
    Caroline

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

    Re: Fill Series (97/SP2)

    Have you made sure that Columns has been selected in the Series dialog? If Rows is selected in the dialog while the selected range is a column, nothing will happen.

    What happens if you drag the fill handle (the little black square in the lower right corner of the selected cell) down with the right mouse button?

  3. #3
    Star Lounger
    Join Date
    Feb 2004
    Location
    Houston, Texas, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fill Series (97/SP2)

    Columns had been selected. Dragging the fill handle worked. I tested other areas in the same spreadsheet and the approach that I first described worked perfectly, just not in this column. Weird.

    Thanks,
    Caroline

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

    Re: Fill Series (97/SP2)

    So apparently it is not a general problem with your Excel installation, so you probably don't have to worry. But if you wish, you can post the problem workbook (or a stripped down copy of it), so that Loungers can investigate it.

Posting Permissions

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