Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting A-Z with 1st row as column header
Normally, if I have a spreadsheet where the first row contains the column
headers, I can click on the A-Z sort button and the first row is automagically excluded. Occasionally, however, Excel does NOT see the first row as a header row and sorts it as well. Why? I can't find any rhyme or reason. All the column headers are entered appropriate (no leading spaces, no leading funky characters). If I click on Data - Sort and tell it the first row contains the headers, it all sorts fine. I just don't want to have to do that for a simple sort. But more than that, it just really bugs me that I can't figure out WHY it works differently sometimes. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting A-Z with 1st row as column header
If there is data in the row above what you think is the header row, XL will
not be able to discern the header row. In other words, assume your header row is on row B. Assume also that you have something in row A. XL won't be able to tell that the header row is in row B. Dave -- Brevity is the soul of wit. "Shirlo" wrote: Normally, if I have a spreadsheet where the first row contains the column headers, I can click on the A-Z sort button and the first row is automagically excluded. Occasionally, however, Excel does NOT see the first row as a header row and sorts it as well. Why? I can't find any rhyme or reason. All the column headers are entered appropriate (no leading spaces, no leading funky characters). If I click on Data - Sort and tell it the first row contains the headers, it all sorts fine. I just don't want to have to do that for a simple sort. But more than that, it just really bugs me that I can't figure out WHY it works differently sometimes. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting A-Z with 1st row as column header
XL can sometimes pick-up *differences* between headers and data values.
It's a good idea to always differentiate your headers from the data by either size, or format (bold), or all upper case ... anything different. That being said, I *never* use the sort keys on the toolbar, and *always* select the range to be sorted. XL is right most of the time, but *not* all of the time. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Shirlo" wrote in message ... Normally, if I have a spreadsheet where the first row contains the column headers, I can click on the A-Z sort button and the first row is automagically excluded. Occasionally, however, Excel does NOT see the first row as a header row and sorts it as well. Why? I can't find any rhyme or reason. All the column headers are entered appropriate (no leading spaces, no leading funky characters). If I click on Data - Sort and tell it the first row contains the headers, it all sorts fine. I just don't want to have to do that for a simple sort. But more than that, it just really bugs me that I can't figure out WHY it works differently sometimes. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting A-Z with 1st row as column header
I believe also that Excel checks for bold font and/or caps in the top row
to determine if it is a header row. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Shirlo" wrote in message ... Normally, if I have a spreadsheet where the first row contains the column headers, I can click on the A-Z sort button and the first row is automagically excluded. Occasionally, however, Excel does NOT see the first row as a header row and sorts it as well. Why? I can't find any rhyme or reason. All the column headers are entered appropriate (no leading spaces, no leading funky characters). If I click on Data - Sort and tell it the first row contains the headers, it all sorts fine. I just don't want to have to do that for a simple sort. But more than that, it just really bugs me that I can't figure out WHY it works differently sometimes. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting A-Z with 1st row as column header
Nope...it's the only row. That one I checked on first.
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting A-Z with 1st row as column header
Well, I'll be.... I changed it to bold and it worked. I never knew that was
one of the requirements. Thanks! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting A-Z with 1st row as column header
Well, I'll be.... I changed it to bold and it worked. I never knew that was
one of the requirements. Thanks! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting A-Z with 1st row as column header
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Shirlo" wrote in message ... Well, I'll be.... I changed it to bold and it worked. I never knew that was one of the requirements. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column matching - sorting. Fairly hard problem, I think. | Excel Discussion (Misc queries) | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions |