Download Article
Download Article
This wikiHow will show you how to freeze panes to lock columns in Excel. When you freeze a column, it will stay visible when you're scrolling through that worksheet.
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] X Research source
-
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. You have options to freeze specific panes or freeze the first column and row.
-
Click Freeze Panes . This will freeze the panes in the columns next to what you have selected. [2] X Research source
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- Unfreeze columns by going to View > Unfreeze Panes .Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
Advertisement
References
About This Article
Article Summary
X
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
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 60,354 times.
Advertisement