View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth Trevor Shuttleworth is offline
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