Fill Series option grayed out

K

kodismom

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

Formula fill series? 1
Help Fill Series 1
Fill Series Grayed out and does not Work? 3
Fill series not working as expected 1
fill series option not available 4
VBA - exporting serial letters to single documents 0
IN ONE PARTICULAR EXCEL97 FILE CANT SEE FILL-SERIES-OPTION 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top