How to Freeze the Top Row in Excel 2013

A very common way to set up a spreadsheet in Excel is to use the top row for column headings. It helps to keep the information organized, while also making it simple to find information. But large spreadsheets that contain column headings can suffer as you scroll down the spreadsheet, as the top rows of information will be pushed off the screen. If your spreadsheet has some neighboring columns that contain similar types of information it can get very confusing to determine which column is which. Fortunately you can take advantage of a setting in Excel 2013 that lets you freeze the top row of the spreadsheet so that it remains visible as you scroll down the page.


Keep Top Row Visible While Scrolling in Excel 2013

This is a very simple adjustment that you can make in Excel that can greatly improve your accuracy, while also helping to eliminate a lot of frustration. The setting will also carry over if you email the file to someone else, ensuring that they will benefit from its’ usefulness as well.


Step 1: Open your spreadsheet in Excel 2013.


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

click the view tab



Step 3: Click the Freeze Panes button.

click the freeze panes button



Step 4: Select the Freeze Top Row option.

how to freeze the top row in excel 2013



As you can see from the image below, this will keep row 1 at the top of the spreadsheet, even as you scroll down the page.

example of frozen top row



Do you have a Netflix or Hulu subscription that you want to watch easily on your TV? The Roku 3 is the simplest solution to this problem, and can be purchased for a very low price. Click here to learn more.

You can also set up your spreadsheet so that the top row prints on every page. Read this article to learn how.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides