data, sort option is grayed. how to sort on a column?

  • Thread starter Thread starter Steve Richter
  • Start date Start date
S

Steve Richter

right click to select column. data menu. sort option is grayed. why?

( I thought it was because I had already sorted this spreadsheet. but
I created a new sheet, copied in a few columns of my problem sheet.
and I can sort on any column I choose to. )

I dont know enough to write protect, etc.

thanks,

-Steve
 
Steve

Two or more sheets could be "grouped".

Do you see [Group] next to the filename on Title Bar?

If so, right-click on a sheet tab and "ungroup sheets".

OR............

You may have inadvertantly protected the sheet.

Tools>Protection>Unprotect Sheet.


Gord Dibben MS Excel MVP
 
Back
Top