Download Article
Learn how to freeze Excel panes going horizontal or vertical
Download Article
This wikiHow will show you how to freeze panes in Excel to show horizontal and vertical rows and columns at the same time. When you freeze a column or a row, it will stay visible when you're scrolling through that worksheet.
Things You Should Know
- To start, you need to select a cell to the right of the column and below the row you want to freeze.
- You can freeze panes by going to the View tab on the ribbon and selecting the Freeze Panes button.
- This method works on Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007 for Windows and Mac.
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 and below the row you want to freeze. The frozen columns will remain visible when you scroll through the worksheet.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 . This will freeze the panes in the columns next to what you have selected. [3] X Research source
- Unfreeze columns by going to View > Freeze Panes > Unfreeze Panes .
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
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!
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://www.sussex.ac.uk/its/help/faq?faqid=760
- ↑ https://support.office.com/en-us/article/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
About This Article
Article Summary
X
1. Open your project in Excel.
2. Select a cell to the right of the column and below the row 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 23,782 times.
Advertisement