Don't want to sort the header

Mar 12th, 2002, 08:58 AM

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 · Mar 12th, 2002, 08:59 AM

Hi

Use the Data>Sort path rather than the icon.

Mark W. · Mar 12th, 2002, 10:16 AM

Quote:

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.

Mar 12th, 2002, 10:20 AM

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

Dave Hawley · Mar 12th, 2002, 10:22 AM

So why not use Data>Sort ?

Mar 12th, 2002, 10:27 AM

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

Mark W. · Mar 12th, 2002, 10:29 AM

What version of Excel are you using?

Mar 12th, 2002, 10:33 AM

I am using 2000

Mark W. · Mar 12th, 2002, 10:59 AM

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

Dave Hawley · Mar 12th, 2002, 11:03 AM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 08:58 AM	#1
Guest Posts: n/a	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

Mar 12th, 2002, 08:59 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Use the Data>Sort path rather than the icon.

Mar 12th, 2002, 10:20 AM	#4
Guest Posts: n/a	I formated my headers to Bold and Underline. However, the sort button still sorts the header

Mar 12th, 2002, 10:22 AM	#5
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	So why not use Data>Sort ?

Mar 12th, 2002, 10:27 AM	#6
Guest Posts: n/a	Because, I tried it and it messed up my entire worksheet.

Mar 12th, 2002, 10:29 AM	#7
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	What version of Excel are you using?

Mar 12th, 2002, 10:59 AM	#9
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	I can't reproduce your problem. What's the nature of the list that you're sorting?

Mar 12th, 2002, 11:03 AM	#10
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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 ]