How to Keep Column Headings Visible in Excel 2010
When you want to keep the top row visible in Excel 2010, it is because you are having difficulty determining which column a piece of data belongs to as you scroll down to the higher row numbers. By locking the top row to the top of the spreadsheet, or freezing the top row to the top of the spreadsheet, you can scroll down through the document while keeping the first row visible at the top of the spreadsheet. This method of floating your top row will help to reduce confusion as you scroll through your spreadsheet and prevent a lot of scrolling up or down. Begin the process of keeping the top row visible in Excel 2010 by double-clicking the Excel file that you want to open. Additionally, you could launch Excel 2010, click the File tab at the top-left corner of the window, click Open, then browse to the file you want to modify. Click the View tab at the top of the window, then click the Freeze Panes drop-down menu in the Window section of the ribbon at the top of the window. Click the Freeze Top Row option to ensure that the top row remains static at the top of the spreadsheet window.
You might notice that there are a couple of other options on the Freeze Panes drop-down menu that might be helpful in other situations. The Freeze First Column option, for example, would keep the leftmost column visible while you scrolled through columns further to the right of your spreadsheet. The Unfreeze panes option will remove any of the locked row or column settings that you have previously defined. If you no longer want to display the row or column headings on your spreadsheet (these are the letters and numbers at the top and left of the spreadsheet, respectively) then you can remove the check mark in the Headings box in the Show section of the ribbon at the top of the View menu. 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. Read his full bio here.
