Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
okhameed
 
Posts: n/a
Default how do i set results to appear in status bar of excel

how do i set autofilter results to always appear in the status bar of excel
(e.g "4 of 38 records" displayed instead of "filter mode")
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

http://www.contextures.com/xlautofilter02.html#Count


--
Regards,

Peo Sjoblom

(No private emails please)


"okhameed" wrote in message
...
how do i set autofilter results to always appear in the status bar of
excel
(e.g "4 of 38 records" displayed instead of "filter mode")


  #3   Report Post  
Paul B
 
Posts: n/a
Default

okhameed, have a look here for why filter mode might stay in the status bar

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 2002 & 2003

"okhameed" wrote in message
...
how do i set autofilter results to always appear in the status bar of

excel
(e.g "4 of 38 records" displayed instead of "filter mode")



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
results display in filter function Morphyus C via OfficeKB.com Excel Worksheet Functions 0 August 16th 05 03:46 PM
calculating results in formulas Linda Excel Discussion (Misc queries) 9 July 6th 05 09:20 AM
Equation giving unexpected results Mike K Charts and Charting in Excel 2 January 27th 05 03:58 PM
Status Bar - Key Board Short Cut excel_googler Excel Discussion (Misc queries) 1 November 26th 04 01:58 AM
?odd results for =left(F#,2) Steven Stadelhofer Excel Worksheet Functions 1 November 4th 04 10:54 PM


All times are GMT +1. The time now is 03:36 PM.

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

About Us

"It's about Microsoft Excel"