How to freeze 2 columns in Excel

Download Article Written by Darlene Antonelli, MA Last Updated: January 20, 2020 Download Article X This

How to freeze 2 columns in Excel

Download Article   Written by Darlene Antonelli, MA

Last Updated: January 20, 2020

Download Article X

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 40,638 times.

Learn more...

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

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] X Research source Go to source

2Select 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.

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 drop-down. You have options to freeze specific panes or freeze the first column and row.

5Click Freeze Panes. This will freeze the panes in the columns next to what you have selected.[2] X Research source Go to source

Tips

  • Unfreeze columns by going to View > Unfreeze Panes.

You Might Also Like

Google Sheets How to Insert Time in Cell Automatically

4 Easy Ways to Add the Time and Date Automatically in Sheets

How Do You Write an if then Formula in Excel

How to Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More

Add the Same Value to Multiple Cells in Excel

How toAdd the Same Value to Multiple Cells in Excel

Show the Max Value in an Excel Graph

How toShow the Max Value in an Excel Graph

Create a Form in a Spreadsheet

How toCreate a Form in a Spreadsheet

Add a Custom Field in Pivot Table

How to Add Custom Calculated Fields to Pivot Tables in Excel

Make a Google Spreadsheet

How toMake a Google Spreadsheet

Sort by Number on Google Sheets on PC or Mac

How toSort by Number on Google Sheets on PC or Mac

Add Two Cells Containing the Sum of Other Formulas in Excel

How toAdd Two Cells Containing the Sum of Other Formulas in Excel

Add Rows to a Pivot Table

How toAdd Rows to a Pivot Table

Change an Excel Sheet from Read Only

How toChange an Excel Sheet from Read Only

Graph Multiple Lines in Excel

How toGraph Multiple Lines in Excel

Make a Shared Spreadsheet

How toMake a Shared Spreadsheet

Use Google Spreadsheets

How toUse Google Spreadsheets

References

  1. 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
  2. https://support.office.com/en-us/article/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f

About This Article

Written by: Darlene Antonelli, MA wikiHow Technology Writer 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 40,638 times.   Co-authors:  2 Updated: January 20, 2020 Views:40,638 Categories: Spreadsheets Article SummaryX

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.
In other languagesEspañol:inmovilizar más de una columna en Excel Italiano:Bloccare Una o Più Colonne in Excel Deutsch:Mehr als eine Spalte in Excel fixieren Português:Congelar Mais de uma Coluna no Excel Français:geler plus d'une colonne dans Excel

  • Print
  • Send fan mail to authors Thanks to all authors for creating a page that has been read 40,638 times.

Is this article up to date? Yes No  Thanks for sharing feedback!  Read more articles like this one. Thanks for sharing feedback!  Read more articles like this one. We're sorry this article wasnt helpful. Here are some similar articles that might be more helpful to you. We're sorry this article wasnt helpful. Here are some similar articles that might be more helpful to you.

Video liên quan