Skip to content
Home How To How to Freeze Rows and Columns in Excel: A Step-by-Step Guide

How to Freeze Rows and Columns in Excel: A Step-by-Step Guide

How to Freeze Rows and Columns in Excel: A Step-by-Step Guide
If you’ve ever navigated a sprawling Excel spreadsheet, you understand how overwhelming extensive rows and columns can be. Once you surpass ten or fifteen different data points and labels, it can become quite challenging to recall the details from those initial cells. Thankfully, there’s a straightforward technique to keep those essential pieces of information visible.

The crucial concept here is “freezing,” and the process is as uncomplicated as it sounds. Utilizing Microsoft Excel’s built-in feature, you can freeze specific rows and columns (typically headers), ensuring that these cells remain visible as you scroll through the spreadsheet.

Now, let’s dive into a step-by-step guide on how to freeze rows and columns in Excel!

How to Freeze a Row in Excel

Step 1: Identify the row or rows you wish to freeze. These rows will remain visible as you scroll. Select the row right beneath the last row you want to freeze. For instance, if you want to freeze the first three rows, select row four.

Digital Trends

Step 2: Navigate to the View tab in the ribbon menu at the top of the screen.

Step 3: Click on Freeze Panes from the drop-down menu.

If you only want to freeze the top row of your spreadsheet, you can skip the row selection step entirely. Just click the View tab, followed by Freeze Panes > Freeze Top Row.

Screenshot of the Excel Freeze Panes drop-down menu.
Digital Trends

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

Screenshot showing the option to unfreeze panes in Excel.
Digital Trends

How to Freeze a Column in Excel

Step 1: Choose the column or columns you want to freeze. Then select the column immediately to the right of those you wish to freeze. For instance, to freeze columns A, B, and C, select column D.

Screenshot illustrating column selection and access to the View tab in Excel.
Digital Trends

Step 2: Click on the View tab located in the ribbon menu at the top.

Step 3: Choose Freeze Panes from the drop-down options.

If your goal is merely to freeze the first column of your spreadsheet, click the View tab, and select Freeze Panes > Freeze First Column.

Excel Freeze Panes drop-down menu options screenshot.
Digital Trends

Step 4: To unfreeze your columns, go back to the View tab, and select Freeze Panes > Unfreeze Panes. Remember, if you add a column amidst frozen columns, it will also be frozen.

Excel unfreeze panes option screenshot.
Digital Trends

Freezing Rows and Columns with Keyboard Shortcuts

Step 1: To freeze both rows and columns: Press Alt+W+F+F. This command freezes the rows and columns located before the chosen cell.

Step 2: To freeze only the top row: Press Alt+W+F+R. This command will freeze the first row regardless of which cell is currently selected.

Step 3: To freeze the first column: Press Alt+W+F+C. This will freeze the leftmost column no matter which cell is selected.

Google Sheets displayed on a MacBook Air.

Digital Trends

How to Freeze Rows and Columns in Google Sheets

Similar to Excel, Google Sheets offers options to freeze and unfreeze rows and columns. Here’s how to use these features:

Step 1: Open a new spreadsheet in Google Sheets.

Step 2: Choose the row or column you want to freeze or unfreeze. Click on View > Freeze at the top of the page.

Step 3: Select the number of rows or columns you wish to freeze. To unfreeze, click View > Freeze > No rows or No columns.

If this method seems simpler, consider converting your Excel file to Google Sheets.

How to Freeze Rows and Columns in MacOS Numbers

Apple’s spreadsheet software, Numbers, doesn’t offer the same freeze-unfreeze functionality as Excel or Google Sheets. However, you can still freeze header rows, header columns, or both. Here’s how:

Step 1: Open a Numbers spreadsheet and click anywhere within the table. Then click Table at the top of the page.

Step 2: Select Freeze Header Rows, Freeze Header Columns, or both. You can also specify how many rows or columns to freeze by selecting Header Rows and Header Columns.

While you’ve streamlined your scrolling in Excel, it’s crucial to safeguard important data from accidental changes. Learn how to lock cells in Microsoft Excel to keep your data secure.

  • Rebecca Fraser

    Rebecca covers all aspects of Mac and PC technology, including PC gaming and peripherals, at Digital Phablet. Over the previous ten years, she built multiple desktop PCs for gaming and content production, despite her educational background in prosthetics and model-making. Playing video and tabletop games, occasionally broadcasting to everyone's dismay, she enjoys dabbling in digital art and 3D printing.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.