software

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.

Sorry the orginal post sounded quot;angryquot; this was not intended, but after
spending 20 minutes trying to do something you used to be able to do, but
cant any more, does make the blood pressure rise, make getting old seem quite
scary ;-)

Tim

quot;Timbooquot; wrote:

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

the behavior in Sort is exactly the same.

If you go to Data=gt;sort, there is a checkbox at the bottom of the dialog
that indicates that there is or isn't a header. Usually Excel is pretty
smart in being able to determine if there is or isn't, but not always. If
you bold your header row and the rest of the data is not bold, then that
usually makes it different enough to figure it out - but when Excel is wrong,
use the dialog and tell it.

As far as telling whether new data has been added or not, I can't say of a
good way beyond comparing what was sent out to what was sent back.

--
Regards,
Tom Ogilvyquot;Timbooquot; wrote:

gt; Sorry the orginal post sounded quot;angryquot; this was not intended, but after
gt; spending 20 minutes trying to do something you used to be able to do, but
gt; cant any more, does make the blood pressure rise, make getting old seem quite
gt; scary ;-)
gt;
gt; Tim
gt;
gt; quot;Timbooquot; wrote:
gt;
gt; gt; I am sure in previous version of Excel you could mark the first row as
gt; gt; headings, and they would not then be sorted. (I think there was a tick box
gt; gt; somewhere) How do I do this in 2003, and why is it either not a default, or
gt; gt; logically easy to see how to do it (I asked four IT people in the office how
gt; gt; to and nobody knew, and I'm not too bad with other Office products).
gt; gt;
gt; gt; Also before I email the spreadsheet out to a large number of users, (who
gt; gt; will add data) I will turn on tracking changes, but is there anything else I
gt; gt; should do to aid visibility in identifying on the returned sheets what data
gt; gt; has been added - or that might aid merging the returned spreadsheets into a
gt; gt; single sheet?
gt; gt;
gt; gt; Thank you, Tim.

in the Data/Sort dialog, there's an option button for Header row

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

Firstly I had made the first row bold, text, bigger font, to hint to Excel
that it was a header (just in case) Secondly I also found the tick box under
quot;my data has header rowquot; and that is ticked, but it still throws the header
row into the sorted data, dispite the tick box being filled. So perhaps I
was on the right tracks, but this sheet may be a bit qwerky, thanks Tim

quot;Tom Ogilvyquot; wrote:

gt; the behavior in Sort is exactly the same.
gt;
gt; If you go to Data=gt;sort, there is a checkbox at the bottom of the dialog
gt; that indicates that there is or isn't a header. Usually Excel is pretty
gt; smart in being able to determine if there is or isn't, but not always. If
gt; you bold your header row and the rest of the data is not bold, then that
gt; usually makes it different enough to figure it out - but when Excel is wrong,
gt; use the dialog and tell it.
gt;
gt; As far as telling whether new data has been added or not, I can't say of a
gt; good way beyond comparing what was sent out to what was sent back.
gt;
gt; --
gt; Regards,
gt; Tom Ogilvy
gt;
gt;
gt; quot;Timbooquot; wrote:
gt;
gt; gt; Sorry the orginal post sounded quot;angryquot; this was not intended, but after
gt; gt; spending 20 minutes trying to do something you used to be able to do, but
gt; gt; cant any more, does make the blood pressure rise, make getting old seem quite
gt; gt; scary ;-)
gt; gt;
gt; gt; Tim
gt; gt;
gt; gt; quot;Timbooquot; wrote:
gt; gt;
gt; gt; gt; I am sure in previous version of Excel you could mark the first row as
gt; gt; gt; headings, and they would not then be sorted. (I think there was a tick box
gt; gt; gt; somewhere) How do I do this in 2003, and why is it either not a default, or
gt; gt; gt; logically easy to see how to do it (I asked four IT people in the office how
gt; gt; gt; to and nobody knew, and I'm not too bad with other Office products).
gt; gt; gt;
gt; gt; gt; Also before I email the spreadsheet out to a large number of users, (who
gt; gt; gt; will add data) I will turn on tracking changes, but is there anything else I
gt; gt; gt; should do to aid visibility in identifying on the returned sheets what data
gt; gt; gt; has been added - or that might aid merging the returned spreadsheets into a
gt; gt; gt; single sheet?
gt; gt; gt;
gt; gt; gt; Thank you, Tim.