Tip of the Day | Thursday 6 August 2026

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.

Starting this tool