The ASAP Utilities menu in Excel (English)
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
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
- Click ASAP Utilities › Columns & Rows › 11. Delete All Hidden Rows, Columns, or Both...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
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
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) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Choose and Unhide Hidden Rows and Columns... |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 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.
🏆 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.