Tip of the Day | Friday December 12th, 2025
Discover new tools to get things done.
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
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...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©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.