Sort forgets last sort and forgets I have header rows

Normal behavior:
I have many spreadsheets that I autofilter and sort to analyze.
Usually when I choose to sort...
Excel remembers the last sort and also automatically selects "Header Row".

In one document, however:
Excel does NOT remember the last sort criteria and automatically selects "No Header Row".
After manually choosing "Header Row", I am able to choose what I want, but it does not remember any prior sort criteria.

I'm using Excel 2000 and have no discernment regarding how this ONE document is different from any other. I've never encountered this before.

Excel can usually guess if you have a header row if you format it nicely--bold,
underlines.

So maybe you could just add formatting to the header row to see if that helps.

medlint wrote:

Normal behavior:
I have many spreadsheets that I autofilter and sort to analyze.
Usually when I choose to sort...
Excel remembers the last sort and also automatically selects "Header Row".

In one document, however:
Excel does NOT remember the last sort criteria and automatically selects "No Header Row".
After manually choosing "Header Row", I am able to choose what I want, but it does not remember any prior sort criteria.

I'm using Excel 2000 and have no discernment regarding how this ONE document is different from any other. I've never encountered this before.

--

Dave Peterson

My header rows in the forgetful document are formatted the same way as they are in all my non-forgetful documents...bold, shading.

"Dave Peterson" wrote:

Excel can usually guess if you have a header row if you format it nicely--bold,
underlines.

So maybe you could just add formatting to the header row to see if that helps.

medlint wrote:

Normal behavior:
I have many spreadsheets that I autofilter and sort to analyze.
Usually when I choose to sort...
Excel remembers the last sort and also automatically selects "Header Row".

In one document, however:
Excel does NOT remember the last sort criteria and automatically selects "No Header Row".
After manually choosing "Header Row", I am able to choose what I want, but it does not remember any prior sort criteria.

I'm using Excel 2000 and have no discernment regarding how this ONE document is different from any other. I've never encountered this before.

--

Dave Peterson

My header rows in the forgetful document are formatted the same way as they are in all my non-forgetful documents...bold, shading.

"Dave Peterson" wrote:

Excel can usually guess if you have a header row if you format it nicely--bold,
underlines.

So maybe you could just add formatting to the header row to see if that helps.

medlint wrote:

Normal behavior:
I have many spreadsheets that I autofilter and sort to analyze.
Usually when I choose to sort...
Excel remembers the last sort and also automatically selects "Header Row".

In one document, however:
Excel does NOT remember the last sort criteria and automatically selects "No Header Row".
After manually choosing "Header Row", I am able to choose what I want, but it does not remember any prior sort criteria.

I'm using Excel 2000 and have no discernment regarding how this ONE document is different from any other. I've never encountered this before.

--

Dave Peterson

My header rows in the forgetful document are formatted the same way as they are in all my non-forgetful documents...bold, shading.

"Dave Peterson" wrote:

Excel can usually guess if you have a header row if you format it nicely--bold,
underlines.

So maybe you could just add formatting to the header row to see if that helps.

medlint wrote:

Normal behavior:
I have many spreadsheets that I autofilter and sort to analyze.
Usually when I choose to sort...
Excel remembers the last sort and also automatically selects "Header Row".

In one document, however:
Excel does NOT remember the last sort criteria and automatically selects "No Header Row".
After manually choosing "Header Row", I am able to choose what I want, but it does not remember any prior sort criteria.

I'm using Excel 2000 and have no discernment regarding how this ONE document is different from any other. I've never encountered this before.

--

Dave Peterson

My header rows in the forgetful document are formatted the same way as they are in all my non-forgetful documents...bold, shading.

"Dave Peterson" wrote:

Excel can usually guess if you have a header row if you format it nicely--bold,
underlines.

So maybe you could just add formatting to the header row to see if that helps.

medlint wrote:

Normal behavior:
I have many spreadsheets that I autofilter and sort to analyze.
Usually when I choose to sort...
Excel remembers the last sort and also automatically selects "Header Row".

In one document, however:
Excel does NOT remember the last sort criteria and automatically selects "No Header Row".
After manually choosing "Header Row", I am able to choose what I want, but it does not remember any prior sort criteria.

I'm using Excel 2000 and have no discernment regarding how this ONE document is different from any other. I've never encountered this before.

--

Dave Peterson

When I only have one header row, bolded (and the data not bold), then excel sure
seems to guess correctly.

But when I had multiple header rows (all bold), then excel didn't guess
correctly.

If you're using multiple header rows, you may want to put the headers in one
cell (use alt-enter to force new lines within the cell).

Bold that row and see if helps.

Maybe you'll get lucky.



medlint wrote:

My header rows in the forgetful document are formatted the same way as they are in all my non-forgetful documents...bold, shading.

"Dave Peterson" wrote:

Excel can usually guess if you have a header row if you format it nicely--bold,
underlines.

So maybe you could just add formatting to the header row to see if that helps.

medlint wrote:

Normal behavior:
I have many spreadsheets that I autofilter and sort to analyze.
Usually when I choose to sort...
Excel remembers the last sort and also automatically selects "Header Row".

In one document, however:
Excel does NOT remember the last sort criteria and automatically selects "No Header Row".
After manually choosing "Header Row", I am able to choose what I want, but it does not remember any prior sort criteria.

I'm using Excel 2000 and have no discernment regarding how this ONE document is different from any other. I've never encountered this before.

--

Dave Peterson



--

Dave Peterson