What happens to the rows that do not meet the filter criteria when applying a filter in Excel?

They are deleted from the worksheet.

They are hidden from view temporarily.

They remain visible in the worksheet.

They are highlighted with a different colour

They remain visible in the worksheet.