Show everything that is hidden
Unhide every sheet, plus the hidden rows and columns on this sheet.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Show all hidden sheets
- Show rows 1 to 1000
- Show columns A to Z
Use it in MacroRoni: open the Starter gallery, search for "Show everything that is hidden", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More sheets & safety macros
Sheets & safetySave a backup copySave a dated copy of the workbook before you make big changes.Doesn't change valuesSheets & safetyFormat every sheet the sameStyle the header, freeze the top row and fit columns on every sheet in the workbook.Doesn't change valuesSheets & safetyLock the finished sheetAsk first, then replace formulas with their results and protect the sheet from edits.Changes data · backup on