Fill/Series Greyed out

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Fill/Series Greyed out

  1. #1
    New Member
    Join Date
    Aug 2008
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Fill/Series Greyed out

     
    Hello, all

    I have one excel sheet that is giving me this problem. When I highlight a column of numbers and click Fill..., Series is greyed out. When i drag the fill handle, the values copy. , i.e. 1 2 3 becomes 1 1 1.

    My question is this: Under what conditions does this happen? This seems pretty vague but I've been enlisted to help someone, but I'm not allowed (!!) to actually view the data except with direct supervision and i certainly may not have a copy. This is utterly ridiculous, that is completely true.

    Anyway, if someone could tell me under what conditions Fill>Series becomes unavailable and filling operates as if the CTRL key is down, that would be helpful to me. Hopefully this problem is not too annoying to reply to. It's nearly too annoying to support but i do value my job!

  2. #2
    Board Regular Diablo II's Avatar
    Join Date
    Sep 2008
    Location
    Tampa Fl
    Posts
    538
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Fill/Series Greyed out

      
    check your options setting , enable autocomplete for cell values may be,
    and did you click all 1 2 3 then pull, or just 3 and pulled.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com