Toggle Help Topics Menu >

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.

Form Fields

  • 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.