![how to freeze top rows in excel 2016 how to freeze top rows in excel 2016](https://media.gcflearnfree.org/content/561fbc87287fc10e146dbf44_10_15_2015/freeze-rows-after-change.png)
This way, the header row and leftmost column of your table will always be viewable equally y’all scroll down and to the right: In a unmarried step, select cell B2 and click Select a cell below the last row and to the correct of the last cavalcade you’d like to freeze.Likewise locking columns and rows separately, Microsoft Excel lets you freeze both rows and columns at the aforementioned time. Visible, whatever columns that are out of view will be hidden after freezing. Columns in the centre of the worksheet cannot be frozen.
![how to freeze top rows in excel 2016 how to freeze top rows in excel 2016](https://tipsmake.com/data/images/how-to-freeze-cells-in-excel-picture-9-zsb0Ofa32.jpg)
This volition lock the first two columns in identify, as indicated by the thicker and darker border, enabling you lot to view the cells in frozen columns as yous move beyond the worksheet:
#How to freeze top rows in excel 2016 how to
For more than information, please see How to avoid frozen hidden rows in Excel.įreezing columns in Excel is done similarly past using theĬommands. If some of the rows are out of view, such rows volition be hidden after freezing. Make sure that all the rows to exist locked are visible at the moment of freezing.It is not possible to lock rows in the eye of the sheet. Select the row (or the first cell in the row) right below the terminal row you want to freeze.įor example, to freeze top two rows in Excel, nosotros select cell A3 or the unabridged row 3, and clickĪs the result, y’all’ll be able to curlicue through the sheet content while continuing to view the frozen cells in the first two rows:.
![how to freeze top rows in excel 2016 how to freeze top rows in excel 2016](https://cdn-adclh.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/optimized/rev-ae61699/wp-content/uploads/2015/12/Using-Excel-Freeze-Panes-Headers-Disappear.gif)
In case you want to lock several rows (starting with row one), carry out these steps: You can determine that the top row is frozen by a grey line below information technology: This will lock the very first row in your worksheet so that it remains visible when yous navigate through the rest of your worksheet. You only clickĪnd choose one of the following options, depending on how many rows you wish to lock: Other means to lock columns and rows in Excelįreezing rows in Excel is a few clicks thing.This can exist easily done by using theĬommand and a few other features of Excel. When working with large datasets in Excel, y’all may often want to lock sure rows or columns so that you tin can view their contents while scrolling to some other area of the worksheet. Beneath y’all volition find the detailed steps on how to lock a row or multiple rows, freeze 1 or more columns, or freeze cavalcade and row at once. The tutorial shows how to freeze cells in Excel to keep them visible while you navigate to another surface area of the worksheet.