![how to freeze top rows in excel 2016 how to freeze top rows in excel 2016](https://tipsmake.com/data/images/how-to-fix-column-and-header-rows-in-excel-2007-2010-2013-2016-picture-6-1OLJ2BeBt.jpg)
In a unmarried step, select cell B2 and click Select a cell below the last row and to the right of the last column you’d like to freeze.Visible, any columns that are out of view will be hidden after freezing.īesides locking columns and rows separately, Microsoft Excel lets you freeze both rows and columns at the same time. All the columns to be locked should exist.Columns in the middle of the worksheet cannot be frozen. This will lock the first ii columns in identify, as indicated by the thicker and darker border, enabling you lot to view the cells in frozen columns as you move across the worksheet: Select the column (or the first prison cell in the column) to the right of the last column yous want to lock.įor example, to freeze the first 2 columns, select the whole column C or cell C1, and click.In case yous want to freeze more than i column, this is what you need to exercise: This will make the leftmost column visible at all times while you lot scroll to the right. To freeze the first cavalcade in a sheet, click
#HOW TO FREEZE TOP ROWS IN EXCEL 2016 HOW TO#
For more than data, please come across How to avoid frozen hidden rows in Excel.įreezing columns in Excel is done similarly by using theĬommands. If some of the rows are out of view, such rows will be subconscious after freezing.
![how to freeze top rows in excel 2016 how to freeze top rows in excel 2016](https://cdn.ablebits.com/_img-blog/excel-freeze-header-rows/excel-freeze-top-row.jpg)
Other ways to lock columns and rows in Excelįreezing rows in Excel is a few clicks thing.This tin can exist hands done by using theĬontrol and a few other features of Excel. When working with big datasets in Excel, you may often want to lock certain rows or columns and then that you lot can view their contents while scrolling to another area of the worksheet. Beneath you will find the detailed steps on how to lock a row or multiple rows, freeze one or more than columns, or freeze cavalcade and row at once. The tutorial shows how to freeze cells in Excel to keep them visible while yous navigate to another area of the worksheet.