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

Additional keywords to help you find this tool:
Unhide hidden rows in Excel, Unhide hidden columns in Excel, Choose and unhide rows and columns, Selectively unhide rows in Excel, Reveal hidden rows and columns, Manage hidden rows and columns, Display hidden rows, Hidden data management, Show hidden cells

Tip:Alt+P for the previous tool.