A
agility
The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected.
never had the problem before. It's not protected.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
Do you see [Group] in the Title Bar?
This means you have more than one sheet selected.
Autofilter will not work in this case.
Grouped sheets will have a white tab.
NOTE: if these are grouped and have been for a while, take a good look at all
the sheets.
While in group mode, what you do to one sheet will be done to all.
Select a non-white sheet to ungroup.
Gord Dibben MS Excel MVP
This means you have more than one sheet selected.
Autofilter will not work in this case.
Grouped sheets will have a white tab.
NOTE: if these are grouped and have been for a while, take a good look at all
the sheets.
While in group mode, what you do to one sheet will be done to all.
Select a non-white sheet to ungroup.
Gord Dibben MS Excel MVP
A
agility
Excellent - fixed. Never knew about "grouped" tabs. Thanks so much!
Gord Dibben said:Do you see [Group] in the Title Bar?
This means you have more than one sheet selected.
Autofilter will not work in this case.
Grouped sheets will have a white tab.
NOTE: if these are grouped and have been for a while, take a good look at all
the sheets.
While in group mode, what you do to one sheet will be done to all.
Select a non-white sheet to ungroup.
Gord Dibben MS Excel MVP
The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected.
G
Gord Dibben
Thanks for the update.
Hope you didn't do too much mucking about while the sheets were grouped.
Gord
Hope you didn't do too much mucking about while the sheets were grouped.
Gord
Excellent - fixed. Never knew about "grouped" tabs. Thanks so much!
Gord Dibben said:Do you see [Group] in the Title Bar?
This means you have more than one sheet selected.
Autofilter will not work in this case.
Grouped sheets will have a white tab.
NOTE: if these are grouped and have been for a while, take a good look at all
the sheets.
While in group mode, what you do to one sheet will be done to all.
Select a non-white sheet to ungroup.
Gord Dibben MS Excel MVP
The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected.
M
Max
The autofilter command is grey'ed out. I receive this spreadsheet daily and
never had the problem before. It's not protected, not grouped, and no frozen
pane...
never had the problem before. It's not protected, not grouped, and no frozen
pane...
G
Gord Dibben
When you state "not grouped" do you mean you don't have multiple sheets
selected?
Gord Dibben MS Excel MVP
selected?
Gord Dibben MS Excel MVP