ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   No. of rows selected from auto filter not visible on toolbar? (https://www.excelbanter.com/excel-discussion-misc-queries/111112-no-rows-selected-auto-filter-not-visible-toolbar.html)

Asif Akbar

No. of rows selected from auto filter not visible on toolbar?
 
When i put an auto filter on a column on excel, and select a particular
option from the drop down filter menu, the number of rows selected for that
option is not appearing at the bottom left hand corner on the toolbar....

Stefi

No. of rows selected from auto filter not visible on toolbar?
 
Is Application.DisplayStatusBar set to Tue?

Regards,
Stefi



€žAsif Akbar€ť ezt Ă*rta:

When i put an auto filter on a column on excel, and select a particular
option from the drop down filter menu, the number of rows selected for that
option is not appearing at the bottom left hand corner on the toolbar....


Abhishek kedia

No. of rows selected from auto filter not visible on toolbar?
 


Try
the farmulae at the bottom of your data

=subtotal(2,a1:a100)

"Asif Akbar" wrote:

When i put an auto filter on a column on excel, and select a particular
option from the drop down filter menu, the number of rows selected for that
option is not appearing at the bottom left hand corner on the toolbar....



All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com