This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 11,903 times.
Learn more...
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.
Steps
-
1Open 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]
-
2Select 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
-
3Click View. You'll see this either in the editing ribbon above the document space or at the top of your screen.
-
4Click Freeze Panes. A menu will dropdown.[2]
-
5Click Freeze Panes. This will freeze the panes in the columns next to what you have selected.[3]
- Unfreeze columns by going to View > Freeze Panes > Unfreeze Panes.
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
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.
