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.
Step 3: Click the Freeze Panes button.
Step 4: Select the Freeze Top Row option.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.