Help with sorting

J

jlynch

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
 
T

Trevor Shuttleworth

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
 
J

jlynch

Thank you so much. You've just made my life a lot easier. Hope you have a
nice day too.

Jody
 
T

Trevor Shuttleworth

You're welcome. Thanks for the feedback


jlynch said:
Thank you so much. You've just made my life a lot easier. Hope you have
a
nice day too.

Jody
 
Top