Weired Sorting

AllenL · Mar 15th, 2002, 08:47 AM

I have several spreadsheets which contain similar data/format. However, when I was sorting the spreadsheet by clicking the sort button. Some of the spreadsheets don't sort the headers, but some include the headers when sort.
How can I make them sort the same way?
Is there some kind of hidden format that does this kind of trick?
Please help

Al Chara · Mar 15th, 2002, 08:54 AM

What format is your data in, numbers, text? What format are the headers in?

Von Pookie · Mar 15th, 2002, 08:54 AM

Select what you want to sort.
Go to the menu bar and select Data/Sort.
You can select whether or not to have a header row.

Hope this helps!

Dave Hawley · Mar 15th, 2002, 09:11 AM

Hi Allen

It is no dout because some of your headings are Bolded and/or some are different formats to the data. Excel will detect bolded first row as headings by default.

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

[ This Message was edited by: Dave Hawley on 2002-03-15 08:12 ]

AllenL · Mar 15th, 2002, 10:18 AM

The format of my data have both number/text
eg.
Name Weight
Bob 40
Lisa 30
I have changed the headers ,Name/Weight, to bold
However, they still become part of the data when sort
The only way I could get the header not included in the sorting is to insert an empty row between data and header. However, it makes the sheet very ugly
Are there any other solution to this problem?
Please help
Thanks in advance

AllenL · Mar 15th, 2002, 10:18 AM

The format of my data have both number/text
eg.
Name Weight
Bob 40
Lisa 30
I have changed the headers ,Name/Weight, to bold
However, they still become part of the data when sort
The only way I could get the header not included in the sorting is to insert an empty row between data and header. However, it makes the sheet very ugly
Are there any other solution to this problem?
Please help
Thanks in advance

Al Chara · Mar 15th, 2002, 10:47 AM

I can't duplicate your problem. Did you try Von Pookie's solution? If not, try copying the data and pasting only the values into a new workbook.

Hope this helps.
Kind regards, Al.

AllenL · Mar 15th, 2002, 11:13 AM

I have noticed that the spreadsheet which can separate the headers when sort has assigned the column name
eg. In Data->Sort, the drop down box shows the headers that I typed in
However, for the spreadsheets that can't separate the headers when sort the drop down box display Column1, Column2, Column3.... and not the header names
So, is there a way to let the header names show on the drop down box?
Thanks in advance

Von Pookie · Mar 15th, 2002, 11:22 AM

Stupid question, but I'll ask it anyway.

Do you have both the text and numbers in the same cell? For example, in A1, you have "Bob 40"?

Al Chara · Mar 15th, 2002, 11:22 AM

For the spreadsheets that are having problems, under Data|Sort|"My list has" is "Header Row" clicked?

Mar 15th, 2002, 08:54 AM	#3
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Select what you want to sort. Go to the menu bar and select Data/Sort. You can select whether or not to have a header row. Hope this helps! __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Mar 15th, 2002, 11:22 AM	#9
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Stupid question, but I'll ask it anyway. Do you have both the text and numbers in the same cell? For example, in A1, you have "Bob 40"? __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

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

Mar 15th, 2002, 08:47 AM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	I have several spreadsheets which contain similar data/format. However, when I was sorting the spreadsheet by clicking the sort button. Some of the spreadsheets don't sort the headers, but some include the headers when sort. How can I make them sort the same way? Is there some kind of hidden format that does this kind of trick? Please help

Mar 15th, 2002, 08:54 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	What format is your data in, numbers, text? What format are the headers in?

Mar 15th, 2002, 09:11 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Allen It is no dout because some of your headings are Bolded and/or some are different formats to the data. Excel will detect bolded first row as headings by default. _________________ Kind Regards Dave Hawley OzGrid Business Applications Microsoft Excel/VBA Training [ This Message was edited by: Dave Hawley on 2002-03-15 08:12 ]

Mar 15th, 2002, 10:18 AM	#5
AllenL Board Regular Join Date: Mar 2002 Posts: 67	The format of my data have both number/text eg. Name Weight Bob 40 Lisa 30 I have changed the headers ,Name/Weight, to bold However, they still become part of the data when sort The only way I could get the header not included in the sorting is to insert an empty row between data and header. However, it makes the sheet very ugly Are there any other solution to this problem? Please help Thanks in advance

Mar 15th, 2002, 10:47 AM	#7
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	I can't duplicate your problem. Did you try Von Pookie's solution? If not, try copying the data and pasting only the values into a new workbook. Hope this helps. Kind regards, Al.

Mar 15th, 2002, 11:13 AM	#8
AllenL Board Regular Join Date: Mar 2002 Posts: 67	I have noticed that the spreadsheet which can separate the headers when sort has assigned the column name eg. In Data->Sort, the drop down box shows the headers that I typed in However, for the spreadsheets that can't separate the headers when sort the drop down box display Column1, Column2, Column3.... and not the header names So, is there a way to let the header names show on the drop down box? Thanks in advance