![microsoft excel how many rows and columns microsoft excel how many rows and columns](https://d295c5dn8dhwru.cloudfront.net/wp-content/uploads/2019/05/15164956/Figure-5.-Hiding-Columns.png)
Columns in the middle of the worksheet cannot be frozen. You can only freeze columns on the left side of the sheet.This will lock the first two columns in place, as indicated by the thicker and darker border, enabling you to view the cells in frozen columns as you move across the worksheet:
![microsoft excel how many rows and columns microsoft excel how many rows and columns](https://i0.wp.com/www.supportyourtech.com/wp-content/uploads/2019/07/how-restore-headings-microsoft-excel-2.jpg)
Go to the View tab, and click Freeze Panes > Freeze Panes.įor example, to freeze the first two columns, select the whole column C or cell C1, and click Freeze Panes:.
![microsoft excel how many rows and columns microsoft excel how many rows and columns](https://excel.officetuts.net/wp-content/uploads/sites/2/2018/11/rows.png)
Select the column (or the first cell in the column) to the right of the last column you want to lock.In case you want to freeze more than one column, this is what you need to do: This will make the leftmost column visible at all times while you scroll to the right. To freeze the first column in a sheet, click View tab > Freeze Panes > Freeze First Column.
Microsoft excel how many rows and columns how to#
For more information, please see How to avoid frozen hidden rows in Excel.įreezing columns in Excel is done similarly by using the Freeze Panes commands. If some of the rows are out of view, such rows will be hidden after freezing.
![microsoft excel how many rows and columns microsoft excel how many rows and columns](https://i.ytimg.com/vi/Keq5l5YQDUo/maxresdefault.jpg)
When working with large datasets in Excel, you may often want to lock certain rows or columns so that you can view their contents while scrolling to another area of the worksheet. Below you will find the detailed steps on how to lock a row or multiple rows, freeze one or more columns, or freeze column and row at once. The tutorial shows how to freeze cells in Excel to keep them visible while you navigate to another area of the worksheet.