| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off compatibility Checker in Excel 2007? | Excel Discussion (Misc queries) | |||
| How can I call IE browser (Back button) through Excel macro? | Excel Discussion (Misc queries) | |||
| How can I call IE browser (Back button) through Excel macro? | Excel Discussion (Misc queries) | |||
| How can you close a window with the back button in excel | Excel Discussion (Misc queries) | |||
| I can't turn off excel programs with the exit button. What is up. | Excel Discussion (Misc queries) | |||
Hybrid Mode
