Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

AutoFilter

Posted by Stevie Mc on December 10, 2001 10:15 AM

When in Excel the AutoFilter option is not available. Although it has a 'tick' indicating it is on, there is no way I can select this option.

Any Ideas anyone ????

Re: AutoFilter

Posted by Chris D on December 10, 2001 11:36 AM

Maybe the column or row that the filters is on is hidden ?

try clicking top left to highlight all columns and rows, then drag across and unhide any columns, and drag down to unhide any rows .....

You can send it to me, I'm on UK time too, I'll take a look at it

HTH
Chris D

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.