What it does
It applies freeze panes at the selected location for all selected sheets.  Note that this is not supported natively in Excel (where only one sheet can have freeze panes applied at a time).

When to use it
When you want to apply freeze panes in the same cell/column/row location across multiple sheets in one step.

Why to use it
It’s an efficient way to apply freeze panes (a really useful feature in Excel) to multiple sheets in one step.

Default shortcut
None

Other Details

• Category: Sheets / Multi-sheets
• Difficulty: 2/5
• Usage/frequency: 2/5
• Automation factor: 5/5 (estimated 60 seconds saved each time used)
• Type: Bulk
• Date added: 1/1/2014
• Tags: Freeze panes, multiple sheets, bulk

Related Macros
None

Other Articles
None

None

Prerequisites
Select multiple sheets, then select the cell, column, or row where you want to apply freeze panes.

Instructions
After selecting the sheets and cell/column/row to apply freeze panes at, run the Freeze Selected Sheets macro.  It will apply (or move) freeze panes to the specified spot.  That’s it!

None