Calculation of records on spreadsheet

[Les Stout]

Good day,

I am not sure if this is the right forum for this question, but would
appreciate any help.

I have a spread sheet with a lot of rowws in, about 5000 and before i
deleted a lot i had 9000.
The question is that when i filter by a certain criteria, i get a
message at the very bottom of the spreadsheet saying; "500 of 9540
records found".
Can a person change this or is this something that Excel does itself ?

Les Stout


Les Stout

 

[Frank Kabel]

Hi
this is an Excel build-in feature.

 

[JE McGimpsey]

If your question is "can the status bar reflect the actual number of
records rather than the previous maximum" the answer is yes.

The problem is caused when there is text (perhaps a space character) or
formatting applied to rows in which the contents were deleted or
replaced, but the row itself wasn't deleted. XL still considers those
rows used.

Select from the row below your last record through a row past the end of
your previous data (one way: if you have 5000 records, enter 5001:20000"
(without quotes) in the name box at the left of the formula bar).
Right-click a selected row headers and choose delete.

Depending on your version of XL, you may have to then save and reopen
the file, save the file, or do nothing, but when you next filter, the
status bar will reflect the right number of records.