#1   Report Post  
Posted to microsoft.public.excel.misc
Pauline
 
Posts: n/a
Default Edit / Fill / Series

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Edit / Fill / Series

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

Pauline wrote:

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
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pauline
 
Posts: n/a
Default Edit / Fill / Series

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

"Dave Peterson" wrote:

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

Pauline wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Edit / Fill / Series

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 wrote:

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

"Dave Peterson" wrote:

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

Pauline wrote:

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


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pauline
 
Posts: n/a
Default Edit / Fill / Series

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" wrote:

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 wrote:

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

"Dave Peterson" wrote:

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

Pauline wrote:

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


--

Dave Peterson



  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Edit / Fill / Series

Whew!

Thanks for posting back.

Pauline wrote:

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" wrote:

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 wrote:

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

"Dave Peterson" wrote:

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

Pauline wrote:

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


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FILL SERIES Tee Excel Discussion (Misc queries) 2 November 22nd 05 12:36 PM
Excel should not automatically extend series or fill values whisperlm Excel Discussion (Misc queries) 0 July 13th 05 07:06 PM
Fill Series option grayed out kodismom Excel Discussion (Misc queries) 1 June 1st 05 01:06 AM
fill series J. Kopp Excel Discussion (Misc queries) 1 February 1st 05 11:23 PM
fill series grayed out (not available, disactivated) Michel Dion (from IMS Health in Canada) Excel Discussion (Misc queries) 1 December 17th 04 02:35 AM


All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"