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?

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

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

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

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

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