ExcelBanter - AutoFilter

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

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

- - AutoFilter (https://www.excelbanter.com/excel-discussion-misc-queries/154528-autofilter.html)

Millington

AutoFilter

Can you create an AutoFilter to 3 separate columns so the grey box with the
black down arrow appears in each of the 3 columns at the same time (a filter
to sort items in column 1, then column 2, then column 3)?

challa prabhu

AutoFilter

Hi,

Do the following:

1. Select the first column header
2. On the Data menu, point Filter, and the click AutoFilter.

Challa Prabhu

"Millington" wrote:

Can you create an AutoFilter to 3 separate columns so the grey box with the
black down arrow appears in each of the 3 columns at the same time (a filter
to sort items in column 1, then column 2, then column 3)?

All times are GMT +1. The time now is 08:05 AM.