Fill Series option grayed out

G

Guest

I have a spreadsheet that in certain columns will not allow the fill series
option to work. Only "copy cells" is an available option. Have tried
clearing contents, deleting column and inserting a new column all with the
same results. I can go to a column far to the right of my data and fill
series works. I can add a new sheet to the file and the fill options work
fine on the new sheet.

any suggestions why this option isn't working in this particular section of
the worksheet?
 
D

Dave Peterson

Is your list filtered?
I have a spreadsheet that in certain columns will not allow the fill series
option to work. Only "copy cells" is an available option. Have tried
clearing contents, deleting column and inserting a new column all with the
same results. I can go to a column far to the right of my data and fill
series works. I can add a new sheet to the file and the fill options work
fine on the new sheet.

any suggestions why this option isn't working in this particular section of
the worksheet?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
Fill Series Grayed out and does not Work? 3
Fill series not working as expected 1
fill series option not available 5
How do I make the "series" option available under the Fill Menu? 1
Edit/Fill/Series on Protected Sheet 1
auto fill options (copy cell, not create series) 4
Auto-update Fill Series in column that has randomly spaced blank c 3

Top