Sorting

  • Thread starter Francis Hookham
  • Start date
F

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
 
B

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting column 1
Sort Issue Excel 2003 1
Sorting without selecting 1
Shortcut keys 0
Sorting 2
Sorting problem 3
TOP ROW scerwed up. 2
Protection of 1st row (headings) only 1

Top