Sorting

[Francis Hookham]

Sorting

Capitalising the header row of a database lets Sort... recognise the header
row so that the toolbar Sort button excludes the heading while sorting

That is working in XL98 but it seems not to be working with XL 2001 - I
thought it was working that way when I last used 2001 on another Mac -
perhaps there is some default on the 2001 installation which has been
changed

Any thoughts

Francis Hookham

 

[Bernard Rey]

Francis Hookham wrote :

Capitalising the header row of a database lets Sort... recognise the header
row so that the toolbar Sort button excludes the heading while sorting

That is working in XL98 but it seems not to be working with XL 2001 - I
thought it was working that way when I last used 2001 on another Mac -
perhaps there is some default on the 2001 installation which has been
changed

Still seems to work. I've tried it with Excel:2001 and Excel v.X. In both
cases, it defaults to header row when first row contains capitals (or when
text is heading numbers), but it seems not to be very reliable. When
changing the headline, I could notice it didn't always modify the way it
worked. When sorting from the "Data" menu, it doesn't seem to get so
"confused".