Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter Summary in Status Bar
I have a spreadsheet where I've set the Autofilter. The basic filtering is
working but it used to give me a summary in the status bar (e.g. "Showing 34 of 2388" or something like that). Now it's not working. Having had a search through this section I thought I'd found the solution, but it doesn't seem to be working for me. I have right-clicked on the status bar to ensure that the SUM option is ticked and it is. I've unticked and ticked it again, but still I'm not getting the filter data appearing. Anything ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter Summary in Status Bar
Andrew, see if this will help,
http://www.contextures.com/xlautofilter02.html#Count -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2003 "AndrewJ" wrote in message ... I have a spreadsheet where I've set the Autofilter. The basic filtering is working but it used to give me a summary in the status bar (e.g. "Showing 34 of 2388" or something like that). Now it's not working. Having had a search through this section I thought I'd found the solution, but it doesn't seem to be working for me. I have right-clicked on the status bar to ensure that the SUM option is ticked and it is. I've unticked and ticked it again, but still I'm not getting the filter data appearing. Anything ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter status | Excel Discussion (Misc queries) | |||
Auto Filter and Status Bar | Excel Discussion (Misc queries) | |||
Lost the summary totals on status bar when highlighting cells | Excel Discussion (Misc queries) | |||
Auto Filter Status Bar | Excel Worksheet Functions | |||
Auto filter not displaying number of results in status bar. | Excel Discussion (Misc queries) |