Hide or show rows or columns. Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019. Show or hide columns and rows. Insert or delete a.
The way that worked for me was, assuming the filter is easy to reverse:. Clear your filter. Create a temporary column, say called 'TEMP ORDER'. Set every value in that column to 0. Reverse your filter (filter for everything you want to delete).
Set every value in the 'TEMP ORDER' column to 1 on the filtered results. Clear your filter. Sort your data by the 'TEMP ORDER' column, smallest to largest.
![Excel For Mac Delete Hidden Rows Excel For Mac Delete Hidden Rows](/uploads/1/2/5/4/125459523/511132503.jpg)
Find on which row the first '1' occurs. Resize your table (Design tab), having the last row be the row before the first '1'. Delete the rows that are no longer in your table.
This may be a preferable solution if you don't want to mess up any other sheets in your workbook and are concerned about what might happen if you copy and paste your data around. The accepted relating to 'inspect document' is excellent. In addition, the procedure indicated would apply to the whole workbook, so you might be messing other worksheets in the same workbook.
![Delete Delete](https://cdn.extendoffice.com/images/stories/shot-kutools-excel/delete-rows-columns/shot-delete-hidden-blank-row01.png)
In this case, you have to move the worksheet to a separate workbook, apply the procedure, and move the worksheet back to your original workbook. Cross linking of references/ formulas/ chart series among worksheets, involving the worksheet in question, might be a challenge.
As an alternative to (which cannot handle the case of charts, etc., as requested by the OP), Home - Find & Select - Go To Special - Visible cells only. It appears to be exactly the same command (and then I wonder why it is listed under Commands Not in the Ribbon).