Home Screenshots 10 Languages Why use it?

Tip of the Day | Friday March 13th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Freeze Panes on Multiple Sheets at Once

Quickly apply Freeze Panes to multiple worksheets at once, keeping headers, labels, or key data visible while scrolling.

In Excel, you can only freeze panes on one sheet at a time, which can be slow and repetitive.
This tool lets you apply the same freeze pane settings to multiple sheets.

Freeze Panes freezes the rows above and the columns left of the selected cell.

If only one sheet is selected, it applies to all worksheets in your workbook

If multiple sheets are selected, it applies to those sheets only.

Before running this tool, place your selection based on how you want panes to be frozen:

Freeze top row(s): Select the first row below the row(s) you want to lock in place.

Freeze first column(s): Select the first column to the right of the column(s) you want to lock in place.

Freeze both rows and columns: Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.

Screenshots

Sheets › Freeze Panes on Multiple Sheets at Once

Starting this tool

Click ASAP Utilities › Sheets › 22. Freeze Panes on Multiple Sheets at Once
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Yesterday's Tip

Tomorrow's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.