For instance, to lock the first 2 rows and 2 columns, you select cell C3 to fix 3 rows and 3 columns, select cell D4 etc.
![microsoft excel keeps freezing up windows 10 microsoft excel keeps freezing up windows 10](https://media.gcflearnfree.org/content/561fbc87287fc10e146dbf44_10_15_2015/freeze-rows-dropdown-menu.png)
In the same fashion, you can freeze as many Excel panes as you want. To lock several rows and columns at a time, select a cell below the last row and to the right of the last column you want to freeze.įor example, to freeze the top row and first column, select cell B2, go to the View tab and click Freeze Panes under Freeze Panes:
MICROSOFT EXCEL KEEPS FREEZING UP WINDOWS 10 HOW TO
How to freeze multiple panes in Excel (rows and columns)ĭo you wish to lock multiple rows and columns? No problem, you can do this as well, provided that you always start with the top row and first column. For more details, please see How to avoid hidden columns in Excel. If some of the columns are out of view, you won't see them later. Please make sure that all the columns you want to lock are visible at the moment of freezing.
![microsoft excel keeps freezing up windows 10 microsoft excel keeps freezing up windows 10](https://i.ytimg.com/vi/ffoRpACo6D8/maxresdefault.jpg)
Just remember that frozen columns will always start from the left-most column (A), it's not possible to lock several columns somewhere in the middle of the sheet. For example, if you want to freeze the first 3 columns (A - C), select the entire column D or cell D1.
![microsoft excel keeps freezing up windows 10 microsoft excel keeps freezing up windows 10](https://10scopes.com/wp-content/uploads/2021/11/fix-microsoft-excel-freezing-or-slow-.jpg)
Bellow you will find the detailed steps that work in any for Excel version. In Microsoft Excel terms, to freeze panes means to always show certain rows and/or columns at the top of a spreadsheet when scrolling. The good news is that you can easily fix that inconvenience by freezing panes in Excel. Hardly anyone will ever use them to the limit, but if your worksheet contains tens or hundreds of rows, the column headers in the top row disappear when you are scrolling down to view lower entries. These tips work in all modern versions of Excel 365, 2021, 2019, 2016, 2013, 20.Īs you probably know, the current versions of Excel allow using more than a million rows and over 16,000 columns per sheet.
![microsoft excel keeps freezing up windows 10 microsoft excel keeps freezing up windows 10](https://www.techbout.com/wp-content/uploads/2017/08/fix-microsoft-excel-not-responding-error-in-windows-10.png)
You will also see how to freeze several panes at a time to make Excel always show certain rows or/and columns when you scroll down or right. You will learn how to quickly lock header row or/and the first column. The tutorial demonstrates quick ways to freeze panes in Excel.