How to Freeze Rows and Columns in Excel 2016.

Put your best Excel related tips and tricks here.
Forum rules
This is the place to put all of your Excel Tips & Tricks.
banquethall
Posts: 1
Joined: Tue Apr 11, 2017 11:39 am

How to Freeze Rows and Columns in Excel 2016.

Postby banquethall » Tue Apr 11, 2017 11:55 am

1. Select the row right below the row or rows you want to freeze.

If you want to freeze columns, select the cell immediately to the right of the column you want to freeze. In this example, we want to freeze rows 1 to 6, so we've selected row 7.
Image

2. Go to the View tab

3. Select the Freeze Panes command and choose "Freeze Panes."

Image

That's all there is to it. As you can see in our example, the frozen rows will stay visible when you scroll down. You can tell where the rows were frozen by the green line dividing the frozen rows and the rows below them.

Image

If you want to unfreeze the rows, go back to the Freeze Panes command and choose "Unfreeze Panes".
Image

Note that under the Freeze Panes command, you can also choose "Freeze Top Row," which will freeze the top row that's visible (and any others above it) or "Freeze First Column," which will keep the leftmost column visible when you scroll horizontally.

Besides allowing you to compare different rows in a long spreadsheet, the freeze panes feature lets you keep important information, such as table headings, always in view.

Return to “Excel Tips & Tricks”

Who is online

Users browsing this forum: No registered users and 2 guests