Data sorting problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gracewood - 30 May 2008 17:56 GMT

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?

Reply to this Message

sb1920alk - 31 May 2008 00:25 GMT

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).

> 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?

Reply to this Message

Gord Dibben - 31 May 2008 01:42 GMT

One more..............

Did you accidentally select more than one worksheet?

This would also gray-out the Data>Sort

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 6 lines]
>> 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?

Reply to this Message