Filtering

R

RichR

I have a spreadsheet with filters. For some reason, I cannot click on the
filter or go to data to eteher turn on or offr the filter. I don't know why,
but I did notice that the title at the top of the psge ends with [Group].
Any ideas.
 
R

Rowan Drummond

Right click the sheet tab and select Ungroup Sheets.

Hope this helps
Rowan
 
G

Gord Dibben

Rich

The [group] means you have more than one worksheet selected.

You cannot filter on grouped sheets.

The sheets that are grouped will have white tabs.

Click on one that is not in the group to ungroup all.

If all sheets are grouped, Right-click on a sheet tab and "ungroup sheets"

NOTE: while the sheets were grouped, what you did to one was done to all.

If you don't know how long they have been grouped, check each carefully for
inadvertant changes.


Gord Dibben Excel MVP
 
Top