Why won't my sort info save?

G

Gillian White

I have a spreadsheet with 10 columns. I regularly sort as new info is added
to keep it all in place.

Problem is, my sort won't save. I go into Data/Sort, set everything up and
press OK. I add a couple of new rows, go to do the Sort again, and find that
I have to redo everything.

Is there any way to get Excel to save the Sort settings, so I don't have to
constantly reselect my columns and orders?

It's not a huge problem, but I do a lot of sorting, so it gets a bit
tedious.

Thanks!

Gillian
 
R

RWN

I've found this happens if you do not have a header row.
With a header row (and the "List as Header Row" option selected) xl retains the sort
parameters.
(XL2k)
 
G

Gillian White

I've found this happens if you do not have a header row.
With a header row (and the "List as Header Row" option selected) xl
retains the sort
parameters.
Click to expand...

I have a header row, and I keep having to select the Header Row option when
I do the sort, along with everything else :)

It's very annoying!

Gillian
 
D

Dave Peterson

Sometimes, just changing the format of that header row will allow excel to guess
correctly. (Bolding the cells in the header may be enough.)
 
R

RWN

I should have noted-as Dave Peterson does-that you should format your header so that it's
different than the rest of the sheet.
The format difference allows xl to "guess" that it's a header and sets the box based on
its findings-format difference = probably a header.
In my case I set it to bold and have no problem with it saving the Sort parameters.

Sorry 'bout that-I'm just so used to doing it that I forgot to mention it.
 
Top