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

's Computer Specifications

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?

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
My Excel Options button is greyed out (Excel 2007) How to turn it	Gold	Microsoft Excel Programming	1	7th Sep 2009 09:52 AM
Excel 2007 Sort-How to Retain Sort Order	devistated	Microsoft Excel Discussion	3	22nd Oct 2008 03:11 PM
How do I turn proofing back on in Word (2007)?	Miriame49	Microsoft Word Document Management	1	6th Aug 2008 10:40 AM
How can I turn back on my sort options in excel 2007?	=?Utf-8?B?Sm9zZSBMaXJpYW5v?=	Microsoft Excel Worksheet Functions	2	23rd Aug 2007 05:12 PM
How do you turn off sort warning in Excel 2003?	=?Utf-8?B?QlIx?=	Microsoft Excel Misc	1	6th Dec 2005 04:12 PM