#FREEZE TOP 3 ROWS IN EXCEL 2016 HOW TO#

Note that freezing panes has no effect on printing. Just select the first cell in the data that you don't want to freeze, and choose Freeze Panes. The Freeze Panes option is especially useful when your worksheet contains more than just your data, as in this example. Now the rows above this cell, and the columns to the left of this cell will be frozen and will remain visible as you scroll. To freeze both rows and columns, select the upper left cell in the data that you don't want to freeze. You can also freeze both columns and rows at the same time. To unfreeze the first column, choose Unfreeze Panes from the menu. To keep the first column in place as you scroll horizontally, select Freeze First Column. If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row.

The first column in the visible portion of the worksheet will now be locked and will remain visible as you scroll. Click Freeze Top Row or Freeze First Column. To freeze only the first visible column, select Freeze First Column from the menu. You can quickly look at it while working to know the data that are contained in each row. To unfreeze the top row, choose Unfreeze Panes from the same menu. Row headings are very useful when working on your spreadsheet. The top row in the visible portion of the worksheet will then be locked and remain visible as you scroll down through the data. If you want to freeze only the top row of a list in a worksheet, choose Freeze Top Row from the menu. These options are visible on the view tab in the Freeze Panes menu. This makes it hard to understand the worksheet because we aren't able to see the columns and headers that give the data meaning.Įxcel provides three options for freezing columns and rows so that they don't scroll off the screen as you move through large sets of data. Notice that as we scroll down through the data, the headers scroll off the screen.Īnd, if we scroll to the right, the company name is no longer visible. Here we have a large data table with a header row at the top.

#FREEZE TOP 3 ROWS IN EXCEL 2016 HOW TO#

In this lesson we'll look at how to do that. The rows will be frozen in place, as indicated by the gray. On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. In our example, we want to freeze rows 1 and 2, so well select row. When you're working with a big list, it's often handy to freeze headers or columns so that they're always visible as you scroll through the data. To freeze rows: Select the row below the row (s) you want to freeze.

Freeze top 3 rows in excel 2016