Weired Sorting

AllenL

Board Regular
Joined
Mar 14, 2002
Messages
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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
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! :biggrin:
 
Upvote 0
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
OzGrid.BusApp.170x45.gif

This message was edited by Dave Hawley on 2002-03-15 08:12
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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"?
 
Upvote 0
For the spreadsheets that are having problems, under Data|Sort|"My list has" is "Header Row" clicked?
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top