Delete hidden rows

Location on ribbon: Tab DVD Addin → Group Cells and Rows

Command ID: btnDeleteHiddenRows

What it does

Permanently removes the rows that are currently hidden inside a range you point at, instead of just unhiding them. It is the quick way to "freeze" a filtered table: once AutoFilter or manual hiding has left only the part you want to issue, this command drops the rest for good — useful when splitting one section's quantities into its own file, or producing an extract that contains only the accepted work items.

How to use

1. Hide (or filter and hide) the rows you do not want to keep.
2. Click Delete hidden rows in tab DVD Addin → group Cells and Rows.
3. A range prompt appears: "Select range to delete hidden rows". Select the range and click OK; Cancel exits without changes.
4. The add-in scans each row in the range, collects the hidden ones and deletes them bottom-up.
5. Press ESC while it runs to stop early — the rows already deleted stay deleted.
6. The status bar reports the result, for example Deleted 154 hidden row(s).

Example

A consolidated quantity workbook holds five sections on one sheet, 900 rows in total. The Steel structure part has to be issued separately to a subcontractor.

Save a copy of the file → AutoFilter the "Section" column to Steel structure so the other rows are hidden → select A6:K905 → click Delete hidden rows. What remains is only the steel-structure scope, safe to send without exposing the other sections' quantities.

Notes

• The command deletes entire sheet rows — data outside your selection but on the same rows is lost as well.
• It cannot be cleanly undone with Ctrl+Z; always work on a copy of the original, especially when the output leaves your office.
• Rows hidden by a collapsed row group (outline) count as hidden and will be deleted too — expand all groups first if you are unsure.
• Large ranges take a while because each row is a separate delete call; ESC stops it mid-way.
• Afterwards, re-check total formulas and print areas, since the referenced ranges have changed.

Related

• Delete blanks — removes empty rows and by default keeps hidden ones.
• Select visible — select only what you can see, to copy rather than delete.
• Copy and paste visible — the safer route: move the visible part to a new sheet.
• Hide empty rows — hide rows for printing without touching the data.