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.

Starting this tool

Additional keywords to help you find 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

Tip:Alt+P for the previous tool.