If you have a large worksheet, you may wish to keep the data labels of your rows and/or columns in view as you scroll. To accomplish this, freeze rows and/or columns in place by using the Freeze Panes command on the View Ribbon. The frozen columns or rows will be bordered by a thin black line. When scrolling downward, any rows that are frozen will remain on the top of the screen in view as you scroll. Likewise, as you scroll to the right, any columns that are frozen will remain on the left of the screen in view as you scroll.
To Freeze/Unfreeze Rows or Columns in Place
- Select the cell below the row(s) and/or to the right of the column(s) you wish to freeze.
- Click the View tab on the Ribbon
- Click the Freeze Panes button and then click the option you want (Freeze Panes, Freeze Top Row or Freeze First Columns).
- To unfreeze panes, click anywhere in your worksheet, click the Freeze Panes button and then click Unfreeze Panes.
Similar Posts:
- None Found
