#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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)?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default 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)?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofilter and IRM RERE18Guate Excel Discussion (Misc queries) 0 August 30th 06 04:13 AM
Using Autofilter changetires Excel Discussion (Misc queries) 3 June 15th 06 02:14 PM
How to Sort within AutoFilter with Protection on (and AutoFilter . giblon Excel Discussion (Misc queries) 1 February 16th 06 12:23 PM
Autofilter D Excel Discussion (Misc queries) 3 November 3rd 05 05:56 PM
Autofilter bug? mikebo Excel Discussion (Misc queries) 7 April 26th 05 01:02 PM


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"