Software

Ask something
Discussion Locked

Excel auto filter

0 helpful
2 replies

by nigel.brown

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I HAVE A SPREADSHEET WHICH WHEN I ENGAGE A FILTER, THE AMOUNT OF VALUES SELECTED BY THE FILTER SHOWS ON THE STATUS BAR AS A COUNT OF THE TOTAL IE 3 OF 136 RECORDS FOUND. THIS COUNT APEARS TO BE AUTOMATIC ON THIS PARTICULAR SHEET BUT I CANNOT ACTIVATE IT ON ANY OTHER SHEET I HAVE. i HAVE TRIED RIGHT CLICKING ON THE STATUS BAR AND SELECTED EACH OF THE OPTIONS IN TURN BUT NONE APPEAR TO ACTIVATE THIS FUNCTION.

2 replies

by walid sabra

You might has hide some rows.
Try to select all cells and unhide.
Then try the auto fillter.

This discussion is closed to new replies.