I have a large spreadsheet which opens as (name of spreadsheet).xls [Group]. Am now unable to filter or sort data (although I have done so in the past) as drop-down menus are grey. Any help please? Jane
I have a large spreadsheet which opens as (name of spreadsheet).xls [Group]. Am now unable to filter or sort data (although I have done so in the past) as drop-down menus are grey. Any help please? Jane
Hi,
The [Group] in the filename shows that you have more than one sheet selected, which will prevent filters working.
Right click on any of the sheet tabs, and select "Ungroup Sheets"
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks