Stop heading row being sorted (Excel 2003)
in the Data/Sort dialog, there's an option button for Header row
"Timboo" wrote in message
...
I am sure in previous version of Excel you could mark the first row as
headings, and they would not then be sorted. (I think there was a tick box
somewhere) How do I do this in 2003, and why is it either not a default,
or
logically easy to see how to do it (I asked four IT people in the office
how
to and nobody knew, and I'm not too bad with other Office products).
Also before I email the spreadsheet out to a large number of users, (who
will add data) I will turn on tracking changes, but is there anything else
I
should do to aid visibility in identifying on the returned sheets what
data
has been added - or that might aid merging the returned spreadsheets into
a
single sheet?
Thank you, Tim.
|