Edit / Fill / Series

[Pauline]

Does anyone know why my Series option on Edit / Fill is greyed out? Then I
try to fill the series of cells by dragging the corner handle down but it
just copies even though I don't have the CTRL button down. Help?

 

[Dave Peterson]

Is your data filtered?
data|filter|show all
to see all of it.

 

[Pauline]

No, it isn't filtered but it is grouped across columns and rows.

 

[Dave Peterson]

It shows up ok for me when I have data grouped by rows.

I don't have another guess.

Maybe you could explain what you're doing in greater detail.

 

[Pauline]

Sorry Dave, I did find that someone did filter the data. Sorry for the
headache and Thank YOU so much for providing me with the right information.
Have a Great Day!

 

[Dave Peterson]

Whew!

Thanks for posting back.

Sorry Dave, I did find that someone did filter the data. Sorry for the
headache and Thank YOU so much for providing me with the right information.
Have a Great Day!