Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
cwd cwd is offline
external usenet poster
 
Posts: 1
Default How to make the record count always show when using filters...

I use filters a lot, and usually have the results set record count (e.g. X of
Y records) shown in the lower left corner when I apply a filter. For some
reason this count isn't showing anymore, and I can't figure out how to make
this information reappear in my excel workbooks. I use filters a great deal,
and that count info is extremely helpful.

How do I get it to display again?

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to make the record count always show when using filters...

Debra Dalgleish explains and offers a work-around he
http://contextures.com/xlautofilter02.html#Count

cwd wrote:

I use filters a lot, and usually have the results set record count (e.g. X of
Y records) shown in the lower left corner when I apply a filter. For some
reason this count isn't showing anymore, and I can't figure out how to make
this information reappear in my excel workbooks. I use filters a great deal,
and that count info is extremely helpful.

How do I get it to display again?

Thanks!


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a "fuel gauge" type graph (from 1-5) to show data Gene Flood Charts and Charting in Excel 2 May 14th 10 12:06 AM
Make a count based on Drop Down Option Chart_Maker_Wonderer Excel Worksheet Functions 0 January 31st 07 08:49 AM
how do I make make my hyperlinks show the email address they are . Dustin Excel Discussion (Misc queries) 0 January 13th 05 02:39 AM
Formula to make Excel count business days/skip weekends? Inga Excel Worksheet Functions 1 November 17th 04 08:45 PM
how do I make a function to count days? khamsta Excel Worksheet Functions 2 November 1st 04 11:53 PM


All times are GMT +1. The time now is 04:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"