Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,089
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,089
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Sorting Sorting Skydiver Excel Discussion (Misc queries) 4 June 3rd 06 02:42 PM
Sorting SnobbishJade New Users to Excel 6 April 2nd 06 02:08 AM
Sorting Data in ascending order sharon2006 Excel Discussion (Misc queries) 1 March 14th 06 01:07 AM
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . agc1234 Excel Discussion (Misc queries) 6 May 26th 05 08:02 PM
Adding a KeyID column for sorting Rebecca New Users to Excel 3 February 20th 05 07:09 PM


All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"