View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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