How to use
Use Unhide All in the intended workbook, review the revealed sheets/columns and avoid exposing confidential helper content when sharing the workbook. Check the result before saving changes.
Assist Pro+ / Find / Quick Access
Unhide All
Reveals hidden worksheets, rows and columns.
Where to find it
Follow the ribbon path.
Assist Pro + → Find / Quick Access → Unhide All
Part of Assist Pro+. Eligible tools can also be selected through Assist Pro’s 30-tool Vault allowance. Check the Vault for availability.
Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.
Browse all toolsPractical guidance
Use this tool in your workflow.
Best use case
Revealing hidden worksheets or ranges before reviewing a workbook.
Everyday Excel
Reduces repeated clicks and manual edits in everyday spreadsheets when you need to reveal hidden worksheets, rows and columns.
Accounting and audit
Speeds preparing working-paper schedules and client exports when you need to reveal hidden worksheets, rows and columns.