Banish Empty Rows

Remove rows that arr completely empty across all columns.

Drop or select an Excel scroll t' remove empty rowsMax 5 MB per scroll

How it works

Empty rows break sortin', filterin', an' pivot tables. Remove them in seconds instead o' scrollin' through thousands o' rows manually.

What counts as an empty row?

A row where every cell be blank or contains only whitespace.

Can I choose which sheets t' swab?

Aye. Select specific sheets or apply t' all sheets at once.

Does it remove th' header row?

Nay. Th' first row (header) be always preserved.

Find an' remove duplicate rows based on selected columns.

Find blank cells across all sheets an' plunder a detailed report.

Remove leadin', trailin', an' repeated spaces from text cells.