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.

Related Videos

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

How to use the new communities feature in Microsoft Teams
The Microsoft Teams Communities features is now available for Microsoft 365 Personal and Family.

Microsoft has announced a new communities feature for its free Microsoft Teams communication platform that is intended for personal use rather than exclusively for large businesses.

The communities feature is available for Microsoft 365 Personal and Family and Teams Essentials accounts and allows users to easily organize, share, communicate, and collaborate in a hybrid manner. The feature allows you to not only connect online directly, but also to prepare for in-person meetings.

Read more
How to block people on Snapchat
The Snapchat app store listing on a mobile device with a stylus resting on it.

Sometimes to maintain your peace on social media apps you need to block certain users from being able to contact you. On Snapchat, you might need to block a friend or just prevent strangers from contacting you at all. We can show you how to do both and how to unblock people if you change your mind later.

Let's take a look at how to block people on Snapchat.

Read more
How to post a Short on YouTube
Two mobile devices showing two people dancing in YouTube Shorts videos.

Shorts are short-form videos and they're basically YouTube's answer to TikTok. And similar to how you can create and post TikTok videos using the TikTok app, you can record, edit, and post Shorts directly from the YouTube mobile app.

And in this guide, we're going to show you how to do just that. Keep reading to learn how to post a Short on YouTube.

Read more