Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data, sort option is grayed. how to sort on a column?
right click to select column. data menu. sort option is grayed. why?
( I thought it was because I had already sorted this spreadsheet. but I created a new sheet, copied in a few columns of my problem sheet. and I can sort on any column I choose to. ) I dont know enough to write protect, etc. thanks, -Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data, sort option is grayed. how to sort on a column?
Steve
Two or more sheets could be "grouped". Do you see [Group] next to the filename on Title Bar? If so, right-click on a sheet tab and "ungroup sheets". OR............ You may have inadvertantly protected the sheet. ToolsProtectionUnprotect Sheet. Gord Dibben MS Excel MVP On Tue, 25 Sep 2007 12:44:42 -0000, Steve Richter wrote: right click to select column. data menu. sort option is grayed. why? ( I thought it was because I had already sorted this spreadsheet. but I created a new sheet, copied in a few columns of my problem sheet. and I can sort on any column I choose to. ) I dont know enough to write protect, etc. thanks, -Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort function grayed out, how do I ungray it? | Excel Discussion (Misc queries) | |||
How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. | Excel Worksheet Functions |