This article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. 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 58,079 times.
Learn more...
This How.com.vn 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]
- 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]
Expert Q&A
Tips
- Unfreeze columns by going to View > Unfreeze Panes.Thanks
References
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?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.