Tip of the Day | Monday 3 August 2026

Discover new tools to get things done.

Choose and Unhide Hidden Rows and Columns...

This tool shows a complete list of all hidden rows and columns on your worksheet, allowing you to choose which ones to unhide.

This tool gives you more flexibility than Excel's built-in unhide method, which requires manually selecting the surrounding rows or columns. For example, if a group of rows (for example, rows 10 to 50) is hidden in Excel, you normally have to unhide all of them at once; you cannot unhide just a single row like row 20. With this tool, you can selectively unhide individual rows or columns, making it much easier to manage hidden data.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Tip:Alt+P for the previous tool.