![how to freeze top 3 rows in excel 2013 how to freeze top 3 rows in excel 2013](https://cdn.ablebits.com/_img-blog/freeze-panes/freeze-columns-excel.png)
Select Freeze Panes and you will have frozen the desired row. On a blank worksheet click in the Name Box type A1A50 and then press Enter to select a range of 50 cells. When the columns towards the right side are empty youll observe that the cell border of the Columns will be extended with long text strings. Each sheet has columns addressed by letters starting at A.
#How to freeze top 3 rows in excel 2013 how to#
How to freeze a row in excel that isnt the top row. How To Freeze Panes In Excel Lock Rows And Columns The cell_format parameter will be applied to any cells in the row that dont have a format. Add a description into each cell in row 1. Select the option and your row or column will freeze.Likewise if the header row is formatted the same as the other rows in the data range then it may not recognize it. As you click on the drop down menu you will find three options to freeze pane. Select Freeze Panes.įreeze pane function is found in the VIEW tab > Window group > freeze tab. Select the first cell in the column below the row you want to freeze. If your headings take up more than a single row or you want to compare data in a couple of the top rows to elsewhere in the spreadsheet, you can freeze multiple rows in a similar way. Then choose the “Freeze Panes” command from the drop-down menu.įreeze multiple rows in Excel. Then click the “Freeze Panes” button in the “Window” button group. To freeze panes in both columns and rows in a worksheet, select the cell below the row and to the right of the column to freeze. How do you freeze multiple areas in Excel?įreeze Panes in Excel: Instructions. ‘ Then choose the option ‘ Freeze panes ‘
![how to freeze top 3 rows in excel 2013 how to freeze top 3 rows in excel 2013](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2015/10/excel-2013-freeze-multiple-rows-1.jpg)
For example, if you want to freeze the first 3 columns (A – C), select the entire column D or cell D1.
#How to freeze top 3 rows in excel 2013 windows#
![how to freeze top 3 rows in excel 2013 how to freeze top 3 rows in excel 2013](http://markimarta.com/wp-content/uploads/2013/12/excel-fix-row-2.gif)
![how to freeze top 3 rows in excel 2013 how to freeze top 3 rows in excel 2013](https://libroediting.files.wordpress.com/2013/01/1-document.png)