How to Unhide and Rehide Hidden Worksheets, Rows & Columns

Hiding sheets, rows and columns can be a neat solution to present the spreadsheet to an end-user, but very annoying to the spreadsheet developer. In this video we’ll show you how you can easily unhide and rehide hidden worksheets in Excel with the PerfectXL add-in.

Introduction

An end-user who doesn’t need to know about the specifics of the spreadsheets doesn’t care about hidden worksheets, rows or columns. But to spreadsheet builders it is very inefficient to keep having to unhide everything to make changes and rehide everything when they’re done. Find out how easy this process gets with the PerfectXL Add-in for Excel.

Case

Imagine you’re an accountant and you receive a spreadsheet with a financial report you have to audit. Obviously, it’s very important to have all information at your fingertips. Having immediate access to all content of the spreadsheet model is key. If anything is hidden, it takes extra work to find potential mistakes.

Unhide Everything / Rehide

PerfectXL has an ideal feature for this, called ‘Unhide Everything’. You see, a lot in Excel can be hidden: worksheets, rows, columns and filtered tables.

Worksheets can be ‘very hidden’, which means they won’t appear in the unhidden worksheets dialog.

Very Hidden Worksheets :: How to Unhide and Rehide Tutorial :: PerfectXL Spreadsheet Validation Tool

Click ‘unhide everything’ and PerfectXL unhides all these items, so you can easily inspect them.

Unhide Everything :: How to Unhide and Rehide Tutorial :: PerfectXL Spreadsheet Validation Tool

Once you’re done inspecting the file, you can click that same button again (now named ‘Rehide’) and everything that used to be hidden will be hidden again.

Rehide :: How to Unhide and Rehide Tutorial :: PerfectXL Spreadsheet Validation Tool

Text & narration: Jan Karel Pieterse, Microsoft Excel MVP since 2002, JKP Application Development Services

More Excel Add-in Video Tutorials

How to spot recorded macros in your spreadsheet :: Tutorial :: PerfectXL Add-in

How to Spot Recorded Macros in Your Spreadsheet

VBA is very powerful, but when not properly programmed they can also pose a risk. Recorder macros in particular are unreliable and highly context-specific. In this video we’ll explain to you how to find them with the PerfectXL Add-in for Excel.

Learn how to spot recorded macros in your spreadsheet

How to find circular references in your spreadsheet :: Tutorial :: PerfectXL Add-in

Find (Hidden) Circular References in your Spreadsheet

(Hidden) circular references occur when Excel tries to compute a result of a cell that’s already been visited during the calculation round. Excel doesn’t warn us of conditional circular references. In this video we’ll show you how PerfectXL detects any circular reference.

Learn how to find circular references in your spreadsheet