Tip of the Day | Saturday 12 September 2026

Discover new tools to get things done.

Unfreeze Panes on Multiple Sheets at Once

Quickly unlock all frozen rows and columns on multiple worksheets at once, allowing you to scroll freely.

In Excel, you can only unfreeze panes on one sheet at a time, which can be slow and repetitive.
This tool lets you unfreeze panes across multiple sheets in one step, saving time and ensuring consistency.

  • If only one sheet is selected, it unfreezes panes on all worksheets in your workbook.
  • If multiple sheets are selected, it unfreezes panes only on those sheets.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Tip:Alt+P for the previous tool.