Don't want to sort the header

[Guest]

Question:
I am trying to sort a worksheet. However, after I click sort button, the headers of the spreadsheet are also get sorted.
Is there a way to set the header rows, so they don't get sorted?
Thanks in advance

 

[Dave Hawley]

Hi

Use the Data>Sort path rather than the icon.

 

[Mark W.]

On 2002-03-12 07:58, Anonymous wrote:
Question:
I am trying to sort a worksheet. However, after I click sort button, the headers of the spreadsheet are also get sorted.
Is there a way to set the header rows, so they don't get sorted?
Thanks in advance

Apply a distinguishing font format (e.g., Bold, color) to the header. Excel will then recognize the header as such and you can continue to use the Sort toolbar buttons.

 

[Guest]

I formated my headers to Bold and Underline. However, the sort button still sorts the header

 

[Dave Hawley]

So why not use Data>Sort ?

 

[Guest]

Because, I tried it and it messed up my entire worksheet.

 

[Mark W.]

What version of Excel are you using?

 

[Guest]

I am using 2000

 

[Mark W.]

I can't reproduce your problem. What's the nature of the list that you're sorting?

 

[Dave Hawley]

A step-by-step example would help a lot.


_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

This message was edited by Dave Hawley on 2002-03-12 10:04