Series button

P

PL

Hi

The Series button is greyed out, that's what I meant. I don't understand
why this happens to some sheets that are not protected. How do I solve it?

Thank yo
------------------------------------------------------------------------------------------------

If the Series button is available as in not "grayed out" how does Excel not
allow you to click on it?

Do you get a message saying "you can't do this" or your mouse freezes up
or??


Gord

Hi

The sheet isn't protected. The Series command is available but Excel doesn't
allow me to click on it. Why is that so?

Thanks


-----------------------------------------------------------------------------

Invalid or "unavailable"?

Is the sheet protected?


Gord Dibben MS Excel MVP

..
 
O

OssieMac

Fill series is disabled while AutoFilter is on. It may also be disabled with
other functions that I am not aware of. If not AutoFilter, what else are you
using on the worksheet.
 

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

Top