fill series grayed out (not available, disactivated)

G

Guest

I have been wondering for some time why the fill series functionality is
sometime not available. When you right-click on the fill handle and drag it
to fill adjacent cells, the series option is grayed out in the menu and there
is no way to get Excel to do anything other than copying cell values.

I searched the Web and couldn't find an answer, so I decided to share my
findings.

I know for shure adding auto-filters to a spreadsheet deactivates the fill
series functionality. If you are aware of any other reasons why it may be
deactivated, please share it here.
 
G

Guest

BTW, here is my workaround to the problem, I simply create a new workbook,
create the series I want, and then copy and paste it in the original
worksheet.

Hope it helps.
 

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 option not available 5
Fill Series Grayed out and does not Work? 3
Fill handle increments year instead of day 1
fill handle 3
How do I make the "series" option available under the Fill Menu? 1
Fill series not working as expected 1
Fill Series option grayed out 1

Top