Remove Hidden Rows
The Remove Hidden Rows is related to the Extract Filtered Rows tool. However, instead of taking the filtered data and extracting it to a new worksheet, the Remove Hidden Rows tool will delete the hidden rows in a filtered table.
- Select Source Table: Select the workbook, worksheet, and range where the data is located. The table does not have to be an Excel table - any range will work.
- Save Workbook: See Close and Re-Open Workbook for details.