recovering data

Since hidden rows, filters, and Undo have already been checked, preserve what remains before further troubleshooting. Save the current workbook under a different name without overwriting the original, and avoid closing Excel until you have inspected available recovery information.
Open File, Info, Manage Workbook and look for recovered versions or Recover Unsaved Workbooks. Check File, Options, Save for the configured AutoRecover location, then copy any relevant recovery files elsewhere before opening them. AutoRecover must have captured the missing content beforehand; enabling it now cannot recreate those rows.
If the original workbook was in OneDrive or SharePoint, inspect Version History and open promising versions separately rather than immediately restoring over the current file. Even if the latest edits were unsaved, an earlier snapshot might recover part of the information. Temporary files and caches are not guaranteed backups. If no saved or recovered version contains the rows, complete recovery cannot be promised.