How to change left bottom note that tell number records found?

C

Cpviv

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?
 
S

Sean Timmons

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top