Skip to main content

How to freeze rows and columns in Excel

Excel spreadsheets can quickly get unruly and hard to navigate and scroll through, especially if there are a lot of rows and columns involved. But there are ways to take charge of the situation and make them easier to read.

Here's how to freeze a row in Excel in just a few clicks, so they stick with you while you scroll.

Difficulty

Easy

Duration

5 minutes

What You Need

  • Microsoft Excel

  • A PC

How to freeze a row in Excel

Step 1: Pick out the row or rows you want to freeze. These will be the rows that will stay with you as you scroll through the spreadsheet. Select the row immediately below the row you want to freeze. So if you want to freeze rows 1-3, you need to select row 4.

how to freeze row in excel select screenshot
screenshot

Step 2: Then select the View tab from the ribbon menu at the top of the screen. Then click on Freeze Panes.

Step 3: From the drop-down menu that appears, select Freeze Panes.

Alternatively, if all you want to do is freeze the top row of your spreadsheet, you don't have to select any rows beforehand. You can just click on the View tab and then Freeze Panes > Freeze Top Row.

how to freeze row in excel panes drop down menu screenshot
screenshot

Step 4: To unfreeze your frozen rows: Go to the View tab again, select Freeze Panes, and then choose Unfreeze Panes from the drop-down menu.

how to freeze row in excel unfreeze panes option screenshot
screenshot

How to freeze a column in Excel

Step 1: Pick the columns you want to freeze. Then select the column that is immediately to the right of the column or columns you want to freeze. For example, if you need to freeze columns A, B, and C: You should select column D.

how to freeze row in excel columns screenshot view tab and panes
screenshot

Step 2: Then select the View tab from the ribbon menu at the top of the screen. Then choose Freeze Panes.

Step 3: From the drop down menu that appears, select Freeze Panes.

Alternatively, if all you want to do is freeze the first column of your spreadsheet, you can just click on the View tab, and then select Freeze Panes > Freeze First Column.

how to freeze row in excel panes drop down menu screenshot
screenshot

Step 4: To unfreeze your frozen columns, just click on the View tab, and select Freeze Panes > Unfreeze Panes.

how to freeze row in excel unfreeze panes option screenshot
screenshot

Editors' Note: Article was checked on March 1, 2023, and confirmed that the steps and information included are still accurate.

Editors' Recommendations

Anita George
Anita has been a technology reporter since 2013 and currently writes for the Computing section at Digital Trends. She began…
How to use ChatGPT to write Excel formulas
A laptop opened to the ChatGPT website.

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data and computation needs, there's a new option that can help you write up that formula in just a few steps.

That option is ChatGPT, the buzzy, new AI chatbot from artificial intelligence company OpenAI. And among everything else ChatGPT can do, it can also write Excel formulas. In this guide, we'll show you how to use it to get the Excel formulas you need. Let's get started.

Read more
How to make a graph in Excel
A person looking at bar charts on a PC.

If you use Excel regularly for studying or work that requires a spreadsheet to be filled with data-driven information, then you know it can be quite difficult and time-consuming to decipher -- even more so for those who are not familiar with analytical-based data.

Whether spreadsheets are complicated or not, the fact remains that graphs help break down your data into an easier to understand format, enhancing the general readability of your Excel spreadsheet.

Read more
How to convert Excel files to Google Sheets
A MacBook on a table using Google Sheets.

Google Sheets is a versatile tool that can pick up and run with any existing spreadsheets from applications like Microsoft Excel. You can even convert existing Excel spreadsheets to Google Sheet documents. Whether you're looking to continue working in Sheets or want the improved ease of collaboration and sharing that Sheets offers for that particular spreadsheet, here's how to convert Excel files to Google Sheets in just a few steps.

Read more