excell 2002 sort function

  • Thread starter Thread starter ellen
  • Start date Start date
E

ellen

I received a spreadsheet that I need to sort a different
way. However, the sort function is grayed out. The only
buttons available are: filter, group and outline, and
external data. BUT, none of the suboptions is available
(all grayed out). I have saved the spreadsheet locally,
I have renamed it to a workbook, I have tried to make
sure all fields are formatted to numbers. Help!
 
Hi
check if the worksheet / workbook is protected. Goto 'Tools -
Protection' and disable the protection
 
Another thing to try, is copy the cell contents to another workbook, and
paste them as special > values. Maybe something in the workbook is keeping
you from rearranging the data. Put the data (just the data) in a new
workbook and it shouldn't be a problem.
 
Back
Top