Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to change left bottom note that tell number records found?
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why don't my filter results always appear on the bottom left? | Excel Discussion (Misc queries) | |||
how do I display filtered records found | Excel Discussion (Misc queries) | |||
Advanced Filter: Number of Records Found | Excel Discussion (Misc queries) | |||
Sorting in reverse (from right-to-left and from top-to-bottom) | Excel Discussion (Misc queries) | |||
"Calculate" note at bottom of my screen? | Excel Worksheet Functions |