How can I turn back on the sort button in excel 2007?
 

Somehow I turned off my sort button in excel 2007. Actually, all my options
in Data tab are disabled now and I want 'em back on. Any idea of how can I
make it?

How can I turn back on the sort button in excel 2007?
 

Is the worksheet protected? Go to the "Review" tab, and select "Unprotect
Sheet". If you want the sheet to be protected, but still allow sorting, then
select "Protect Sheet" again, and check the "Sort" option.

HTH,
Elkar

"Jose Liriano" wrote:

Somehow I turned off my sort button in excel 2007. Actually, all my options
in Data tab are disabled now and I want 'em back on. Any idea of how can I
make it?

How can I turn back on the sort button in excel 2007?
 

It was no protected. I didn't do anything to solve the problem and all of a
sudden it turned back on.
But I didn't know about that protection-unprotection issue, so thx anyway...

"Elkar" wrote:

Is the worksheet protected? Go to the "Review" tab, and select "Unprotect
Sheet". If you want the sheet to be protected, but still allow sorting, then
select "Protect Sheet" again, and check the "Sort" option.

HTH,
Elkar

"Jose Liriano" wrote:

Somehow I turned off my sort button in excel 2007. Actually, all my options
in Data tab are disabled now and I want 'em back on. Any idea of how can I
make it?