Disappearing records after using a filter

On a spreadsheet which has filters, it has been filtered and records have continued to be added but once the sheet has been unfiltered to show ALL records, those records that were added whilst it was filtered have now disappeared.

I can see that there are records that aren’t showing as the row numbers skip a few inbetween e.g. 472 shows but then there is a row 473, 474, 475 which appear in the row numbers but the record itself doesn’t show.

If anyone knows how I can retrieve those records I would really appreciate it.

By: Sam

Leave a Reply

Your email address will not be published. Required fields are marked *