This article was co-authored by wikiHow staff writer, Rain Kengly. Rain Kengly is a wikiHow Technology Writer. As a storytelling enthusiast with a penchant for technology, they hope to create long-lasting connections with readers from all around the globe. Rain graduated from San Francisco State University with a BA in Cinema.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 239,376 times.
Learn more...
Freezing rows or columns in Excel ensures that certain cells remain visible as you scroll through the data. If you want to easily edit two parts of the spreadsheet at once, splitting your panes will make the task much easier. You can do this whether you're using the desktop application or the mobile app. This wikiHow teaches you how to freeze specific rows and columns in Microsoft Excel using your computer, iPhone, iPad, or Android.
Things You Should Know
- To freeze the first column or row, click the "View" tab. Click the "Freeze Panes" menu and select "Freeze Top Row" or "Freeze First Column".
- To unfreeze, click "Freeze Panes" menu and select "Unfreeze Panes".
- On mobile, tap "Home" → "View" → "Freeze Top Row" or "Freeze First Column". To unfreeze, tap it again.
Steps
-
Open a project in Microsoft Excel. You can open an existing project or create a new spreadsheet.
- Microsoft Excel is available on Windows and Mac. You can also use the online web version at https://www.office.com/.
- You can use Excel to make tables, type formulas, and more.
-
Click the View tab. It's at the top of Excel. Frozen cells are rows or columns that remain visible while you scroll through a worksheet.[1] If you want column headers or row labels to remain visible as you work with large amounts of data, you'll likely find it helpful to lock those cells into place.
- Only whole rows or columns can be frozen. It is not possible to freeze individual cells.
Advertisement -
Click the Freeze Panes button. It's in the "Window" section of the toolbar. A drop-down menu will open with a set of three freezing options.[2]
-
Click Freeze Top Row or Freeze First Column. If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row. To keep the first column in place as you scroll horizontally, select Freeze First Column.
-
Unfreeze your cells. If you want to unlock the frozen cells and scroll normally, click the Freeze Panes menu again and select Unfreeze Panes.[3]
-
Open a project in Microsoft Excel. You can open an existing project or create a new one.
-
Select the row or column after those you want to freeze. If the data you want to keep stationary takes up more than one row or column, click the column letter or row number after those you want to freeze. For example:[4]
- If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, click row 4 to select it.
- If you want columns A and B to remain still as you scroll sideways through your data, click column C to select it.
- Frozen cells must connect to the top or left edge of the spreadsheet. It's not possible to freeze rows or columns in the middle of the sheet.
-
Click the View tab. It's at the top of Excel.[5]
-
Click the Freeze Panes button. It's in the "Window" section of the toolbar. A drop-down menu will open with a set of three freezing options.[6]
-
Click Freeze Panes on the menu. It's at the top of the menu. This freezes the columns or rows before the one you selected.[7]
- When you scroll, those columns or rows will be frozen in place.
-
Unfreeze your cells. If you want to unlock the frozen cells, click the Freeze Panes menu again and select Unfreeze Panes.[8]
-
Open a project in the Microsoft Excel app. The app looks like an x on top of a green rectangle.
- Microsoft Excel is available on iOS and Android.
-
Tap Home. If you don't see the menu, tap the icon of the A in front of a pencil.
-
Tap View. This is at the bottom of the pop-up menu.
-
Tap Freeze Top Row or Freeze First Column. If you want to keep the top row of cells in place as you scroll down through your data, select Freeze Top Row. To keep the first column in place as you scroll horizontally, select Freeze First Column.
-
Unfreeze your cells. If you want to unlock the frozen cells, tap Freeze Top Row or Freeze First Column again to remove the checkmark.
-
Freeze multiple columns or rows (optional). If the data you want to keep stationary takes up more than one row or column, tap the column letter or row number after those you want to freeze. For example:
- If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, tap row 4 to select it.
- If you want columns A and B to remain still as you scroll sideways through your data, tap column C to select it.
- Frozen cells must connect to the top or left edge of the spreadsheet. It's not possible to freeze rows or columns in the middle of the sheet.
- Once selected, tap Home.
- Tap View.
- Tap Freeze Panes. This freezes the columns or rows before the one you selected.
- To unfreeze, tap Freeze Panes again to remove the checkmark.
- If you want to keep rows 1, 2, and 3 in place as you scroll down through your data, tap row 4 to select it.
Community Q&A
-
QuestionHow do I freeze the top two rows?Community AnswerSelect the row directly under the rows you want to freeze (in this case, the third row). Go to View, Freeze Panes, and select "Freeze Panes." Everything above the row you have selected will be frozen.
Tips
wikiHow Video: How to Freeze Panes in Excel
References
- ↑ https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
- ↑ https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
- ↑ https://support.microsoft.com/en-us/office/unfreeze-locked-panes-4230b27b-a5a0-41ae-9a58-7d7fb9e05a8e
- ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
- ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
- ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
- ↑ https://edu.gcfglobal.org/en/excel/freezing-panes-and-view-options/1/
- ↑ https://support.microsoft.com/en-us/office/unfreeze-locked-panes-4230b27b-a5a0-41ae-9a58-7d7fb9e05a8e
About This Article
1. Click View.
2. Click Freeze Panes.
3. Select Freeze Top Row or Freeze First Column.