Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter calculating in Status bar
I have two excel worksheet using 2003, the worksheet are the same. When I
autofilter one, it display the number of records being shown in the lower left hand corner of the status bar, the second worksheet display filter mode in the status instead. How do I get the number of records being display instead. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter calculating in Status bar
Debra Dalgleish explains it and offers a couple of work arounds:
http://contextures.com/xlautofilter02.html#Count cyndi wrote: I have two excel worksheet using 2003, the worksheet are the same. When I autofilter one, it display the number of records being shown in the lower left hand corner of the status bar, the second worksheet display filter mode in the status instead. How do I get the number of records being display instead. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilter report in status bar | Excel Discussion (Misc queries) | |||
Create list of text matching criteria | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |