Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel status bar: How did I get 65533 records.

I only have 116 line entries in a spreadsheet.

After Data/Filter I end up with this number in the Status Bar:

15 of 65533 records found. This should read
15 of 116 records found.

How do I fix it?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Excel status bar: How did I get 65533 records.

Select the rows you wish to include in your filter before you set up the
filter.
--
David Biddulph

"sligg" wrote in message
...
I only have 116 line entries in a spreadsheet.

After Data/Filter I end up with this number in the Status Bar:

15 of 65533 records found. This should read
15 of 116 records found.

How do I fix it?



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
Excel status bar: How did I get 65533 records. Dave F Excel Worksheet Functions 0 March 28th 07 12:20 AM
Excel Status Toolbar Hugues Excel Discussion (Misc queries) 2 November 10th 06 07:22 PM
What means Fix in the status bar in excel Spil Excel Discussion (Misc queries) 2 September 19th 06 03:31 PM
EXCEL STATUS BAR QUERIES Setting up and Configuration of Excel 1 July 17th 06 02:15 PM
excel status bar shoe gal Excel Discussion (Misc queries) 2 January 19th 05 10:48 PM


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

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"