What it does
It allows you to quickly toggle fields (columns) in one or more sheets between hidden and visible.

When to use it
When you have one or more sheets with a lot of extra columns you want to be able to hide or show quickly.

Why to use it
It’s a quick way to reduce the extra columns in your tabular data sheets by hiding them but still be able to quickly display them again.

Default shortcut
None

Other Details

• Category: Formatting / General
• Difficulty: 2/5
• Usage/frequency: 3/5
• Automation factor: 4/5 (estimated 60 seconds saved each time used)
• Type: Shortcut
• Date added: 6/24/2025
• Tags: Columns, show, hide, shortcut

Related Macros
Toggle Hidden Cells
Toggle Hidden Sheets

Other Articles
None

None

Prerequisites
[Optional – easier way] Hide the columns you want to be able to quickly toggle between hidden and visible in one or more sheets.  Alternatively, identify those columns that you can list out.

Instructions
Run the Toggle Unused Fields macro.  It will prompt you whether or not to capture any hidden columns within your workbook.  Click the Yes button to capture them, or No to list them yourself.

When you click either Yes or No at the prompt, the Toggle_Unused_Fields sheet will be created in your active workbook.  These are the columns within the Toggle_Unused_Fields sheet you’ll want to fill in:

• Column A – Sheet name (required): enter the worksheet name containing the columns to toggle hiding.
• Column B – Column range (required): enter the column-only ranges to toggle hiding (i.e. $A:$A).

If you frequently download the same file where you’d like to be able to toggle the same columns quickly, you can save the settings you use in a saved template.  Simply enter “DEFAULT” and a number from 1 to 5 in cell L1 on the Toggle_Unused_Fields sheet.  Any saved fields will be presented to you when you first run the Toggle Unused Fields macro.