View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default how do I sort data excluidng headings?

In the sort dialog box, there would be check box with something like 'My data
has headers'... If it is checked then sort will exclude the top row in the
range selected.
--
--------
If this is what you wanted then press the ''''YES'''' button (if you see it)


"megido" wrote:

I have created a spreadsheet and freezed the headings so that I can scroll
down and keep the headings on top. Now I am trying to sort the data depending
on what
information I need (by name, by dollar amount, by state, etc) but when I do
it the headings of the columns are also rearranged. How do I keep them on top
and just sort out the data? If I just select the data and leave out the
heading it will sort it but only by the data in the first colum. Thanks!!