Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I activate sort in Excel?
I have worksheets set up in Excel. I am wanting to sort 1 column of these
worksheets, but my sort button seems to be grayed out & I cannot select it. How do I activate the sort function again. Any ideas? |
#2
|
|||
|
|||
Hi marygries
Unprotect your sheet -- Regards Ron de Bruin http://www.rondebruin.nl "marygries" wrote in message ... I have worksheets set up in Excel. I am wanting to sort 1 column of these worksheets, but my sort button seems to be grayed out & I cannot select it. How do I activate the sort function again. Any ideas? |
#3
|
|||
|
|||
"marygries" wrote: I have worksheets set up in Excel. I am wanting to sort 1 column of these worksheets, but my sort button seems to be grayed out & I cannot select it. How do I activate the sort function again. Any ideas? When I go to tools, protection, unprotect is not there as an option??? |
#4
|
|||
|
|||
Do you have more than one sheet selected? You cannot sort grouped sheets.
Do you see [Group] in the title bar? If so, select a sheet to ungroup them. If they were grouped, make note that what was done to one sheet was done to all in the group. Gord Dibben Excel MVP On Tue, 15 Mar 2005 14:09:05 -0800, " wrote: "marygries" wrote: I have worksheets set up in Excel. I am wanting to sort 1 column of these worksheets, but my sort button seems to be grayed out & I cannot select it. How do I activate the sort function again. Any ideas? When I go to tools, protection, unprotect is not there as an option??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel should let me sort on cell background color | Setting up and Configuration of Excel | |||
In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |