Note that, when you return to the normal view, you will not be able to see the information contained in your header. Step 3: Click the Normal button in the Workbook Views section of the ribbon at the top of the window.
Step 2: Click the View tab at the top of the window.
HOW TO INSERT A HEADER IN EXCEL 2007 HOW TO
Step 1: Open the Excel 2010 spreadsheet for which you want to learn how to exit header and footer view.
But you can get out of header and footer view in Excel 2010 and return to the regular view if you need to continue editing the spreadsheet in the manner that you are more comfortable with. Therefore, remaining in header and footer view, or Print Layout view, can be inconvenient. In these instances, it is unnecessary to view the header on your screen while you are editing the spreadsheet data. How to Exit Header and Footer View in Excel 2010įor many Excel users the inclusion of a header or footer is purely for individuals that are reading a printed version of the spreadsheet. Insert filename in Header/Footer/Cell without extension by Kutools for Excel If you have Kutools for Excel’s installed, you can apply its Insert Workbook Information utility to insert worksheet name, workbook name, workbook path, user name, or current date and time into a cell, header, or footer easily. Fortunately it is a simple switch, and will get you back to the normal Excel view to which you are accustomed. While this might not be a problem for some people, there are others that will want to learn how to get out of header and footer view in Excel 2010. But after you go through the process of creating a header in Word 2010, your spreadsheet will remain in a view setting where you can see the header and footer.
One way to solve this problem can be found in this article about making a custom header in Excel 2010. Now, the Excel Options dialog box appears in the left-hand panel of the. Click on Options in the list present on the left-hand side to open the Excel Options dialog box. Select or Click on the File option in the home toolbar of the menu to open the drop-down list. This is further exacerbated if you print out the same report each week, which will effectively leave you with very similar copies of the same spreadsheet. Now, let’s check out how to turn off the row headers or headings in Excel. Looking to learn more about Microsoft Office and its features? Contact us today and see how we can help.One of the biggest problems people encounter when they are printing out a lot of similar Excel 2010 spreadsheets, or if they are working on a lot of them on their computer, is that they can be difficult to distinguish from one another. The next time you need to repeat text on a page to make information more organized and easier to digest, you can simply do so with Excel’s header and footer feature. Delete the information you want to remove.