logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Delete All Hidden Rows, Columns, or Both...

ASAP Utilities  › Columns & Rows  ›  11. Delete All Hidden Rows, Columns, or Both...

This tool removes all hidden rows, hidden columns, or both from your current worksheet, making it easy to clean up your file before sharing or distributing it. For example, when you filter data in Excel, hidden rows and columns can clutter your worksheet or cause confusion. By deleting them, you keep only the visible, relevant data. Please note: If your worksheet contains formulas with cell references to cells in the hidden rows or columns, update those formulas or replace them with their calculated results before using this tool. Otherwise, the formulas may return error values (#REF!) once the hidden rows and columns are removed.

Screenshots

Columns & Rows  ›  11 Delete All Hidden Rows, Columns, or Both...
ASAP Utilities makes YOU rock in Excel!

Practical tricks on how this can help you

Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

Starting this tool


Columns & Rows  ›  11 Delete All Hidden Rows, Columns, or Both...
Additional keywords for this tool:
Delete hidden rows in Excel, Delete hidden columns in Excel, Remove hidden rows and columns, Delete all hidden rows and columns, Clean up hidden data in Excel, Remove filtered rows and columns, Delete non-visible rows, Remove hidden cells in worksheet, Delete rows not shown in Excel, Remove autofiltered-out rows and columns, Clean up worksheet hidden rows columns

Choose your language preference below

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Download
Choose and Unhide Hidden Rows and Columns...




Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.