As you scroll further down the page, however, it can be difficult to remember exactly which column contains which data. This can lead to mistakes, which can be problematic for your current task. Fortunately you can alleviate this problem by using the “Freeze Panes” utility, which will let you keep the top row visible at the top of the sheet as you scroll further down the page.
Keep the Top Row Visible at the Top of the Screen When You Scroll Down in Excel 2013
The steps in this section are going to lock the top row of your spreadsheet by keeping it visible as you navigate to lower row numbers. Step 1: Click the View tab at the top of the window.
Step 2: Click the Freeze Panes button in the View section of the ribbon, then click the Freeze Top Row button.
After you have performed this action to keep the top row visible at the top of your spreadsheet, there will be a faint black line below the top row, indicating that it is frozen in that location.
How to Stop the Top Row From Always Being Visible in Excel 2013
This section will show you how to undo this once you have finished editing your spreadsheet. Step 1: Click the View tab at the top of the window.
Step 4: Click the Freeze Panes button, then click the Unfreeze Panes option.
Do you need to get your spreadsheet ready for printing? Read our complete guide to Excel printing and learn about a few of the different options available that will result in a printed Excel file that is much easier to read. He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices. Read his full bio here.
