Data sorting problem

  • Thread starter Thread starter Gracewood
  • Start date Start date
G

Gracewood

Using Excel 2007, I must have accidentally pressed some combination of keys
that I did not intend to, because I can no longer do a data sort. When I
highlight the range of data to be sorted and then click on the Data tab, all
of the commands are greyed out. How can I remove this blockage and sort data
as I was doing quite happily up to this point in time?
 
Did you protect the worksheet? That would caused the Sort option to be greyed
out. To unprotect it, click Tools->Protection->Unprotect Sheet. (I don't have
Excel 2007, so it's possible that Unprotect is in a different location for
you).
 
One more..............

Did you accidentally select more than one worksheet?

This would also gray-out the Data>Sort


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

writing a sort macro 2
Sort Contiguous Columns - Danger 3
Data Sorting Problem 2
Select all columns with data for sorting. 2
Data Sort Option greyed. 1
Sorting Text Data 4
A Sorting Problem 2
Sort data with pictures in cells 1

Back
Top