Hi Dave,

Thanks for your response. Again, this is something that is already in the
spreadsheet. I guess I am just going to have to live with the Data/Sort,
mark the option thing! Perhaps I should just quit being so lazy! LOL

Thanks!
--
Harley


"Dave Peterson" wrote:

Sometimes, just formatting that header row will be enough for excel to guess
correctly.

Try bolding the headers (or making them italics or underlining them...)

Harley wrote:

Hi,

I ahve what is likely an easy question that my brain just won't answer for
me today so I am looking for some help. In my really long spreadsheet, I
want to make the first row a header row. I would like to be able to have the
option to sort it in all different ways with my header row staying just where
it is.

I know if I go to Data/Sort and mark off "My data range has a header row"
that will allow me to sort without moving my header row. My question is, how
do I make that stay without having to continually go into Data/Sort and
marking that option? I have seen other spreadsheets that do that, I just
can't find how to do that in mine.

Thanks!

--
Harley

--

Dave Peterson