View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default I can't get sort to work

Hi,

Verify whether your file name displays as follows:

Microsoft Excel - filename.xls [Group].

If the file name displays this way then, right-click on one of the grouped
worksheet tab and select Ungrouped Sheets. Now all the sheet will be
ungrouped, then when you click the Data menu, the Sort command shows enabled.

Challa Prabhu


"I can't get sort to work" wrote:

The worksheet is not protected. "Sort" is faded. I created the worksheet
and never protected it at all. All cells are unlocked. Can anyone help