Skip to main content

Quickly delete blank or hidden rows (columns) in Excel

Author: Xiaoyang Last Modified: 2024-11-29

Kutools for Excel

Boosts Excel With 300+
Powerful Features

One of the most common tasks in Excel is to delete blank (empty) rows or columns. If you are looking for an easier way to delete blank rows or columns, the Kutools for Excel’s Delete Hidden (Visible) Rows & Columns utility can quickly apply the following operations:

Delete blank rows or columns from a range, selected sheets, active sheet or all sheets

Delete hidden rows or columns from a range, selected sheets, active sheet or all sheets

Delete visible rows or columns from a range, selected sheets, active sheet or all sheets


Click Kutools >> Delete >> Delete Hidden (Visible) Rows & Columns. See screenshot:

shot-delete-hidden-blank-row-1


Delete blank rows or columns from a range, selected sheets, active sheet or all sheets

If you want to delete blank rows or columns from a range, selected sheets, active sheet or all sheets, you can get it done as follows:

1. Apply this utility by clicking Kutools > Delete > Delete Hidden (Visible) Rows & Columns.

2. In the Delete Hidden (Visible) Rows & Columns dialog box, please specify the scope that you want to apply the operation from Look in drop down list. Tip: If you want to delete blank rows or columns from a range, please select In Selected Range option in Look in drop down list. If you want to delete blank rows or columns from other scopes, please select other options, such as In Active Sheet, In Selected Sheets and In All Sheets.

3. Please check Rows under Delete type. Tip: If you want to delete blank columns, please checked Columns.  And select Blank rows from Detailed type. See screenshot:

shot-delete-hidden-blank-row-3

4. Click OK. All of the blank rows have been deleted from the selected range. See screenshot:

shot-delete-hidden-blank-row-4


Delete hidden rows or columns from a range, selected sheets, active sheet or all sheets

Supposing there are multiple hidden rows or columns in the workbook that you need to delete them. Normally, you need to unhide them and delete the rows or columns one by one. This is a tedious job for us. But with the option delete hidden rows or columns of Delete Hidden (Visible) Rows & Columns utility, you can quickly delete the hidden rows or columns.

1. Go to the Delete Hidden (Visible) Rows & Columns dialog box, specify the scope that you want to apply the operation from Look in drop down list. (If you choose In Selected Range, you must select a range that you want to use first.)

2. Then check Rows under Delete type. And select Hidden rows from Detailed type. See screenshot:

shot-delete-hidden-blank-row-5

3. Then click OK, and the hidden rows have been deleted from the selected range. See screenshot:

shot-delete-hidden-blank-row-6

If you want to delete the hidden columns, please check Columns option from Delete type.


Delete visible rows or columns from a range, selected sheets, active sheet or all sheets

Supposing you have a workbook which contains multiple hidden rows or columns, and now you need to remove the visible rows only. If you delete the contents directly, the hidden rows will be removed together. How do you delete the visible rows only?

1. Go to the Delete Hidden (Visible) Rows & Columns dialog box, specify the scope that you want to apply the operation from Look in drop down list. (If you choose In Selected Range, you must select a range that you want to use first.)

2. Then check Rows under Delete type. And select Visible rows from Detailed type. See screenshot:

shot-delete-hidden-blank-row-7

3. Then click OK, only the visible rows have been removed from the selected range, and the hidden rows are still kept. See screenshot:

shot-delete-hidden-blank-row-8

If you want to delete the visible columns only, please check Columns option from Delete type.


Note:

This utility supports Ctrl + Z undo shortcuts.

Demo: Quickly delete blank or hidden rows (columns) in Excel

 
Kutools for Excel: Over 300 handy tools at your fingertips! Enjoy permanently free AI features! Download Now!

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...


Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

šŸŒ Supports 40+ interface languages
āœ… Trusted by 500,000+ users and 80,000+ businesses worldwide
šŸš€ Compatible with all modern Excel versions
šŸŽ 30-day full-featured trial — no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon