Fill Series option grayed out

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
Fill Series is disabled in Excel 2003 worksheet 2
Fill Series for Lookup 2
How do I make the "series" option available under the Fill Menu? 1
Auto-update Fill Series in column that has randomly spaced blank c 3

Back
Top