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 ????

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