View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default How to change left bottom note that tell number records found?

If you have any formulas that read these filtered records, you will typically
not be able to view the # of records found. If you go to Tool - Options -
Calculation and change to Manual, you would be able to view # of records.
Beware, as this will not automatically calculate your formulas for you.
Pressing F9 will perform calculations...

"Cpviv" wrote:

Hi,

At the left bottom corner of Exel 2003 spreadsheet, a display note 'Ready'
remains as it is, though I have filtered the items using the filter command,
the note usually displays number of records found.

How to return back the display note 'number of records found' in Excel 2003
spreadsheet?

--
Thank you,
Cpviv