![how to freeze top 3 rows in excel 2016 how to freeze top 3 rows in excel 2016](https://libroediting.files.wordpress.com/2013/01/2-freeze-top-or-side.png)
Select the rows/columns by clicking on the header number/letter of the first row/column to freeze, and then click the last one while holding down the Shift key on your keyboard. You will need to use Freeze Panes to freeze multiple rows or columns.Expanding upon this, if you choose the upper-left most, singular cell, that you do not want to be frozen, and choose freeze panes, all panes above and to the left of that single cell are frozen. Previous Article Super Mario Bros Princess Peach Coloring Pages. If you select cell B2, and under 'View,' choose 'Freeze Panes,' the first column AND row will be frozen simultaneously. Microsoft Excel 2016 Cheatsheet Microsoft Excel Microsoft Excel Tutorial Excel Tutorials. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.
#How to freeze top 3 rows in excel 2016 how to#
Augon How To Freeze The First Row In Excel 2016. If you have a large table of data in Excel, it can be useful to freeze rows or columns. You can freeze multiple rows, multiple columns, or a combination of both How To Freeze The First Row In Excel 2016.You cannot freeze rows or columns in the middle of the sheet.Freeze Top Row will freeze only the top row. With the row selected, click on the View tab at the top, select Freeze Panes and you’ll see several different options you can choose: Freeze Panes will freeze all rows above your selected row. Here are some tips for effective freezing: Select the row below the row you want to freeze.To select a row, you need to select the entire row on the left side. If I had selected B3, the top two rows and first column would be frozen.Ģ.Go to the View tab, and click Freeze Panes.ģ.Lines will appear on your spreadsheet separating out the frozen columns and rows from the scrollable part of your spreadsheet.Ĥ.If you want to turn off your frozen rows and columns, go back to View>Freeze Panes and select Unfreeze Panes. In my example, I want to freeze the top row and the first column, so I click on cell B2. That means that every cell above it and to the left of it will be frozen. Freeze Rows AND Columns at the Same Timeġ.Select the first cell that you want to be unfrozen. If you want to freeze rows AND columns at the same time, follow the steps below. If you want to freeze the top row or first column, just go to View> Freeze Panes, and then click on either Freeze Top Row or Freeze First Column. A good solution to this is to freeze columns, rows, or both so that they stay displayed on your screen while you scroll through the rest of your data. It is particularly aggravating when several columns or rows of data are similar, so you have to keep jumping back to the header to remember what you are viewing. Working with a large set of data in Microsoft Excel can be tricky.