XLEV8 EXCEL PRODUCT MANUAL
TOGGLE HIDDEN CELLS
Details
What it does
Creates a hidden sheet that captures any hidden columns and rows so that you can easily toggle them to be hidden or visible in one bulk step. It can hide or unhide all the columns and rows in the active sheet or all sheets in the workbook in one step.
When to use it
When you have hidden columns or rows and want to quickly make them visible and also quickly be able to hide the same columns and rows again.
Why to use it
It’s a super quick and easy way to toggle the visibility of columns and rows in one or more workbooks, retaining a list of columns and rows to toggle in the background.
Default shortcut
None
Other Details
- Category: Formatting / General
- Difficulty: 2/5
- Usage/frequency: 3/5
- Automation factor: 4/5 (estimated 90 seconds saved each time used)
- Type: Shortcut
- Date added: 12/21/2023
- Tags: Formats, hidden, visible, columns, rows
Related Macros and Articles
Related Macros
Misc Picker
Sheet Action Picker
Other Articles
None
Example Files
None
Instructions
Prerequisites
Hide the columns(s) and row(s) throughout your workbook that you’d like to be able to toggle on/off in one step.
Instructions
With the columns(s) and row(s) hidden per the prerequisites above, run the Toggle Hidden Cells macro. It will list any hidden columns or rows across all sheets in your active workbook in a hidden sheet called Toggle_Hidden_Cells. Run the Toggle Hidden Cells macro again to unhide all the rows and columns for the active sheet or all sheets in the active workbook. Run it to hide the the columns and rows again.
To make any changes to the columns and rows that can be easily toggled on/off, you have two options:
Hide any columns or rows you want to be able to easily toggle to hidden or visible. Run the Toggle Hidden Cells macro and click the Refresh button to capture the revised list of hidden columns and rows. Note that this will overwrite the list.
Unhide the Toggle_Hidden_Cells sheet and make the changes yourself, then hide the sheet again.
Screenshots
Screenshot of Toggle Hidden Cells macro.
I don’t get it. I’ve searched for the Macro or Menu item for Toggle Hidden Cells. Nothing comes up with that description. I looked under Formatting-General and don’t see anything. I looked under Sheet Action Picker and, nothing. I created a list of all Macros and searched it … nothing. My version is 2023-11.15_v1.5.1. I am overlooking it?
Hey there, I had set the newest version (2023-12-29_v1.6.1) to go live on 12/29/2023 when that macro was first announced. It looks like it didn’t finish updating. I’ve been on vacation, so I didn’t notice it as quickly as usual.
I just updated the newest live version. It should prompt you if you check your version or relaunch Excel. Please let me know if you’re still not seeing it after loading the newest version!