Download Article
Download Article
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene has been writing and editing tech content at wikiHow since 2019. She previously worked for AppleCare, served as a writing tutor, volunteered in IT at an animal rescue, and taught as an adjunct professor for EN101 and EN102. Darlene has completed Coursera courses on technology, writing, and language. She holds both a BA (2011) and an MA (2012) from Rowan University in Writing, with a focus on workplace communication. With her extensive experience, academic background, and ongoing learning, Darlene has become the go-to grammar expert for her friends and family, as well as a skilled wordsmith for anyone in need.
This article has been viewed 54,972 times.
Learn more...
When you freeze a column or a row, it will stay visible when you're scrolling through that worksheet, which is a useful tool when you're comparing data. You can freeze a single panel or multiple panels. When you freeze columns or rows, they are referred to as "panes." This wikiHow will show you how to freeze and unfreeze panes to lock rows and columns in Excel.
How to Freeze a Single Pane in Excel
- Open your project in Excel.
- Click a cell to the right of the column you want to freeze.
- Click View at the top of the screen.
- Click Freeze Panes.
- Select Freeze Panes from the dropdown menu.
Steps
-
Open your project in Excel. You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer.- This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007.[1]
-
Select a cell to the right of the column you want to freeze. The frozen columns will remain visible when you scroll through the worksheet.- You can press Ctrl or Cmd as you click a cell to select more than one, or you can freeze each column individually.
Advertisement -
Click View. You'll see this either in the editing ribbon above the document space or at the top of your screen. -
Click Freeze Panes. A menu will drop-down. -
Click Freeze Panes. This will freeze the panes in the columns next to what you have selected.[2]- You'll notice when you freeze panes if you scroll away and a column or row stays on the screen.
- We'll show you how to unfreeze panes further down.
-
Open your project in Excel. You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer.- This will work for Windows and Macs using Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007.[3]
-
Select a cell to the right of the column you want to freeze. The frozen columns will remain visible when you scroll through the worksheet. -
Press the Ctrl or ⌘ Cmd key as you click. All the cells you click will be added to your selection when you have that key pressed.- You can release the key when you are done making your selections.
-
Click View. You'll see this either in the editing ribbon above the document space or at the top of your screen. -
Click Freeze Panes. A menu will dropdown. -
Click Freeze Panes. This will freeze the panes in the columns next to what you have selected.[4]- You'll notice when you freeze panes if you scroll away and a column or row stays on the screen.
-
Open your project in Excel. You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer. -
Go to View. You'll see a drop-down menu. -
Click Freeze Panes. It's next to Arrange All and Split/Hide towards the right side of the toolbar. -
Click Unfreeze Panes. This will unfreeze all the cells that you have frozen on the screen.
Expert Q&A
Tips
You Might Also Like
References
- ↑ https://support.office.com/en-us/article/freeze-panes-to-lock-the-first-row-or-column-in-excel-for-mac-b8eb717e-9d3e-4354-8c02-d779a4b404b2
- ↑ https://support.office.com/en-us/article/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
- ↑ https://support.office.com/en-us/article/freeze-panes-to-lock-the-first-row-or-column-in-excel-for-mac-b8eb717e-9d3e-4354-8c02-d779a4b404b2
- ↑ https://support.office.com/en-us/article/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
About This Article
1. Open your project in Excel.
2. Select cell to the right of the column you want to freeze.
3. Click View.
4. Click Freeze Panes.
5. Click Freeze Panes.
Is this article up to date?
