Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with sorting
Help. I am new to this. I have a worksheet that somehow I hit create a list
( I think) and it hightlights that column with a blank cell and a blue astrick. When I try to sort my data now the sort button is not highlighted and I can not sort. Thanks Jody |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with sorting
Right click on the header or the asterisk and select List | Convert to Range
If the header was added by Excel, you can clear that yourself. Regards Trevor "jlynch" wrote in message ... Help. I am new to this. I have a worksheet that somehow I hit create a list ( I think) and it hightlights that column with a blank cell and a blue astrick. When I try to sort my data now the sort button is not highlighted and I can not sort. Thanks Jody |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with sorting
Thank you so much. You've just made my life a lot easier. Hope you have a
nice day too. Jody "Trevor Shuttleworth" wrote: Right click on the header or the asterisk and select List | Convert to Range If the header was added by Excel, you can clear that yourself. Regards Trevor "jlynch" wrote in message ... Help. I am new to this. I have a worksheet that somehow I hit create a list ( I think) and it hightlights that column with a blank cell and a blue astrick. When I try to sort my data now the sort button is not highlighted and I can not sort. Thanks Jody |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with sorting
You're welcome. Thanks for the feedback
"jlynch" wrote in message ... Thank you so much. You've just made my life a lot easier. Hope you have a nice day too. Jody "Trevor Shuttleworth" wrote: Right click on the header or the asterisk and select List | Convert to Range If the header was added by Excel, you can clear that yourself. Regards Trevor "jlynch" wrote in message ... Help. I am new to this. I have a worksheet that somehow I hit create a list ( I think) and it hightlights that column with a blank cell and a blue astrick. When I try to sort my data now the sort button is not highlighted and I can not sort. Thanks Jody |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
Sorting | New Users to Excel | |||
Sorting Data in ascending order | Excel Discussion (Misc queries) | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel |