MENU
Donate
=DIRECTORY.ENTRY
support.microsoft.com

Freeze Panes to Lock Rows and Columns

Microsoft guide to freezing rows and columns while navigating worksheets.

  • Sites
  • Free
Visit support.microsoft.com (opens in a new tab)

What it is

When a spreadsheet extends far enough that headers scroll off screen, freeze panes keeps them in view no matter how far down or across you navigate. This official guide covers every option: locking the top row, locking the first column, or fixing both at a custom position using the split-pane technique.

At a glance

Source
support.microsoft.com
Type
Microsoft Excel sites
Category
Official Microsoft
Cost
Free

Also in Official Microsoft

All microsoft excel sites