ExcelBanter - Filtering Data in Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filtering Data in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/59004-filtering-data-excel-2003-a.html)

[email protected]

Filtering Data in Excel 2003

When doing an Auto Filter in Excel 2003 the top choice is no longer All
in a column that has not been been sorted. The first 2 choices are now
sort ascending and sort descending. The 3rd choice being All. How do
I remove the sort choices, or at least move them?

Gord Dibben

Filtering Data in Excel 2003

This is new feature with Excel 2003.

I don't believe you can remove or move the sort choices from that dialog.

Gord Dibben Excel MVP

On 6 Dec 2005 11:13:32 -0800, wrote:

When doing an Auto Filter in Excel 2003 the top choice is no longer All
in a column that has not been been sorted. The first 2 choices are now
sort ascending and sort descending. The 3rd choice being All. How do
I remove the sort choices, or at least move them?

All times are GMT +1. The time now is 01:28 PM.