You can stay in Page Layout view if you would like to continue editing your excel document like that, or you can click the Normal button to return to the standard view. Now Excel displays the workbook name or the file path if you chose to insert the file path instead. You can do this by clicking the View tab at the top of the window, then clicking the Page Layout button in the Workbook Views group. You will either need to go to Print Preview from the Print menu, or you will need to change the view. If you are in Normal view then you won’t see information on the current worksheet that has been added to the header or footer. If your school or organization has specific requirements about including a filename in the header or footer, then it’s likely that they will have specific requirements for the section of the header or footer where it’s added as well. If you add the filename to the left section, for example, then that information appears at the left side of the footer or header. These are:Įach of these sections corresponds to a segment of the header or footer on the page. When you click the Custom Header button or the Custom Footer button on the Page Setup window you will be presented with three sections. There are also options to format text or format the picture that you have added to the header. Some of the other items that you can add to the header in Excel include: The steps outlined in our guide above show you how to format your spreadsheet header using the Page Setup dialog box. More Information on How to Add the Filename to the Header in Excel 2013 You can then click the OK button when you have finished adding information to the header or footer. This will add the & tags to that section. Click the Custom Footer or Custom Header button.Click the Header/Footer tab at the top of the Page Setup window.If you choose this option then it will add the current file location to the chosen section as well. One of the other buttons in the header elements group or the footer elements group is called File path. If you need to add more than just the file name to the footer dialog box or the header dialog box, then you might want to use some of the other header and footer tools as well. How to Add the File Path to Header or Footer from the Page Setup Dialog Box Once you click the OK button to apply the change the file name will be added to the footer on each page of the printed spreadsheet. You should now see the & text in the selected section of the footer. Click inside the desired footer section.While our guide above focuses specifically on how to insert the filename into the header of your Excel spreadsheet, it’s possible that you might need to place that information in the footer instead.įortunately, this process is nearly identical. How to Add Filename to Footer in Excel 2013 Our guide continues below with additional information on adding objects to the header or footer in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |