If you’ve ever worked with an enormous Excel spreadsheet, you’ll know just how daunting all those rows and columns can be. Once you’re over 10 or 15 different values and labels, it can get pretty difficult to hang onto any info you’ve gleaned from these early cells. Fortunately, there’s a simple way to lock those little rectangular boxes of information.
The name of the game is “freezing,” and the execution is about as surface-level as the word. You use Microsoft Excel's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.
Here's our step-by-step guide to teach you how to start freezing today!
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.
Step 2: Then select the View tab from the ribbon menu at the top of the screen.
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.
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.
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.
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.
Step 4: To unfreeze your frozen columns, just click on the View tab, and select Freeze Panes > Unfreeze Panes. Note that if you want to add a column to Excel, it will be frozen if added within a group of already frozen columns.
You can also freeze Excel rows and columns with keyboard shortcuts. Here’s a small list of the most popular commands:
Step 1: Freeze both rows and columns: Press Alt+W+F+F, with each key tap taking place after the last. Once you’ve selected a cell in Excel, this command freezes the rows and columns before the highlighted cell.
Step 2: Freeze the top row: Press Alt+W+F+R. Regardless of the cell that’s selected, this command will always freeze the first row in your spreadsheet.
Step 3: Freeze the first column: Press Alt+W+F+C. Regardless of the cell that’s selected, this command will always freeze the first (leftmost) column in your spreadsheet.
Similar to Excel, Google’s own spreadsheet software has freeze-unfreeze options for you to mess around with. Here’s how to access these settings:
Step 1: Open a new spreadsheet in Google Sheets.
Step 2: Choose the row or column you’d like to freeze or unfreeze. Then, click View > Freeze at the top of the page.
Step 3: Now just select how many rows or columns you’d like to freeze. To unfreeze, click View > Freeze > No rows or No columns.
If you think this method sounds easier, you might think about converting your Excel file to use Google Sheets instead.
While Apple’s first-party spreadsheet software doesn’t actually have the same kind of freeze-unfreeze capabilities as Excel or Google Sheets, you can still freeze header rows, header columns, or both. Here’s how:
Step 1: Open a Numbers spreadsheet and click any area of the table. Then, click Table at the top of the page.
Step 2: Choose Freeze Header Rows, Freeze Header Columns, or both. You can also select Header Rows and Header Columns to choose how many rows or columns to freeze.
While you might have saved a lot of scrolling through your Excel spreadsheet, it's a good idea to protect important data from accidental altering. Learn how to lock cells in Microsoft Excel and maintain the integrity of your data.
Editors' Note: Article was checked on March 1, 2023, and confirmed that the steps and information included are still accurate.
Did you think hitting delete on your AI chatbot conversation actually makes it disappear? Georgia Tech researchers just proved that's not entirely true. They have built a forensic tool called ORISA that can dig deleted conversations from your phone and even rebuild them into a working chatbot session you can keep talking to.
How can ORISA bring deleted AI conversations back?
Touchscreen laptops have been around for years. You can get them in all sizes and shapes. Just not from Apple. For years, the Cupertino giant has treated the idea of a touchscreen MacBook the way I treat a meeting that could have been an email: with open contempt. However, Wednesday looks like the day the company could finally change its mind.
The latest Apple invite puts the “Pro and Tell” showcase in Los Angeles at 10 a.m. PT (1 p.m. ET) on October 28, 2026. Instead of a regular live-streamed keynote, it is an invitation-only, hands-on event for a handful of press and creators (similar to what the company did for the MacBook Neo earlier this year).
Two residents of Chicago have filed a lawsuit in the US over claims that robots run by Coco Robotics and Serve Robotics captured their facial and hand measurements without consent, bringing renewed attention to the food delivery robots. The cases raise a troubling question: If a robot delivers food to your door, can it also be gathering sensitive information about you?
According to a report by The Associated Press, the proposed class-action lawsuits were filed in Cook County on Oct. 9 and allege violations of Illinois’ Biometric Information Privacy Act. The complaints claim that the robots’ cameras and LiDAR sensors captured information on customers’ faces and hands as they approached the machines to pick up their orders. Both have denied the allegations.