When you say 'one of the headers' gets left behind', are you implying
that you have two or more header rows, or do you mean one of the
headers in one of the columns of a single header row gets left behind?

Rgds



On Sat, 29 Oct 2005 11:12:41 -0500, mpjoyce
wrote:


It's been a while since I've used Excel beyond fairly basic
spreadsheets, and I'm now in a job where once a month, I update a
worksheet created by someone else. The two of us are the primary
users of the document. There are ten columns, and multiple sorting
options, but the users of the worksheet use just a few of them. The
problem I'm having is that when I do the dual sort (First Priority,
Second Priority) requested by the creator for getting the document back
to her, at least one of the headers gets left behind. I don't know why
this is happening. Can someone explain that, and what I can do to
correct it?

The creator of the document deals with the problem with a
cut-paste-cell merge solution that strikes me as a bit messy, and that
I can't seem to replicate. Is there a cleaner solution?

Many thanks in advance!

MJ

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________