Excel

Scroll by fixing the head of a row or column

Page creation date :

Overview

When scrolling cells, you may want to scroll with the column or row headers fixed. Here's how to do that.

行や列の頭を固定してスクロールする

Confirmed version of the operation

Supported Excel version

  • 2002
  • 2003
  • 2007
  • 2010

Make sure Excel version

  • 2010

Contents

If you have rows or columns that you want to pin when scrolling, make the Next Matrix Cell selected for the matrix you want to pin.

In the example shown on the right, we want to fix the first two rows of rows and two columns of columns, so select the cell "C3" in the third row and third column.

Select the View tab and click Pin Window Frame in the Windows group. Select "Fix Window Frame" from the menu that appears.

A black line will appear on the grid. This will be the matrix that will be fixed when scrolling.

If you actually scroll, you'll see that the matrix is fixed. To un pinned, if you display the same menu as before, the menu is set to "Un-lock window frame", so you can select it and cancel it.

Reverse the + orientation of grouping in Excel
Automatically set a border on the bottom line of a page break when printing in Excel (Conditional Formatting)