How to Unfreeze the Top Row in Excel 2010

Making sure that you know what data you are looking at has always been a problem when reading a large spreadsheet in Excel. Identifying that information usually involves placing a heading at the top of the column, but that tactic loses a lot of its’ value when you scroll down and the heading disappears from view.

One way to combat this is by freezing the top row on the screen. That keeps the headings visible, even when scrolling would have removed them from view. But if a frozen top row is giving you problems, you can unfreeze it by following our tutorial.


Stop the Top Row From Remaining on the Screen in Excel 2010

This tutorial will assume that you are working with a spreadsheet where the top row is currently frozen. You will know that a row is frozen because the bottom border of the row will be bolded, as in the image below.

identifying a frozen top row


That row will also remain at the top of the spreadsheet, no matter how far you scroll down.


Step 1: Open your spreadsheet in excel 2010.


Step 2: Click the View tab at the top of the window.

click the view tab



Step 3: Click Freeze Panes in the Window section of the ribbon at the top of the window.

click the freeze panes button



Step 4: Click the Unfreeze Panes option.

how to unfreeze the top row in excel 2010



Having trouble printing your spreadsheet? A helpful tip is to learn how to fit all of your columns on one page in Excel 2010. This can make it a lot easier to read a printed spreadsheet, plus it can reduce the number of pages that you print. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.