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

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

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

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