sorting columns sorts header values too
Assuming your header row is row 1 (and only 1 row). When you sort, there
should be a check box that says My Range has, it may default to NO HEADER
ROW, just choose HEADER ROW and you should be good to go.
--
John C
"Matt" wrote:
Hi Folks,
I have Excel 2003 updated and I have very simply set up columns of data by
pasting in each column and typing in header names above them at the top of
the worksheet. I select each column and click sort ascending expanded and my
headers are of course rearranged. Is there a way I can sort on the entire
column like this without having the first row moved? Thanks in advance!
Matt
|