Headers and footers are displayed only on printed pages, in Print Preview and Page Layout view. Microsoft Excel provides a handful of predefined headers and footers to choose from, as well as allows creating your own ones. Generally, headers and footers contain basic information about the spreadsheet such as page number, current date, workbook name, file path, etc. To make your printed Excel documents look more stylish and professional, you can include a header or footer on each page of your worksheet. You can also use the Page Setup dialog box if you want to insert headers or footers for more than one worksheet at a time.ĭo you want to know how to make a header in Excel? Or are you wondering how to add the footer page 1 to the current worksheet? This tutorial will teach you how to quickly insert one of the predefined headers and footers and how to create a custom one with your own text and graphics. You might need to consider entering the past date into the worksheet in a cell located at the top of the page.

Here you have five categories, these categories show the deferent design of adding a number to the deferent position of your page. Watch the video below to learn more about headers and footers in Word. The trick to doing this is to select all of the sheets at once. ※ Download: ?dl&keyword=header+and+footer+in+excel+2016&source=

Here you can easily set the Header & Footer at ease.įigure 3: Header/Footer in Page Setup dialog boxAdding a header and footer to the worksheet.

Select the Header/Footer tab at the top.

Then you will get into the Page Setup dialog box.

Click File drop down menu under Menus tab.

The third method is to get Header & Footer command in page setup dialog box:

Method C: Header & Footer in File Menu of Microsoft Excel 2010 if you have Classic Menu Just click the View drop down menu under Menus tab, and then you will view the Header & Footer item as soon as possible.įigure 2: Header & Footer in Excel 2010's View Menu Method B: Header & Footer in View Menu if you have Classic Menu Please click to know more information and free download Classic Menu for Office suites and programs. In Microsoft Excel 2007, you can view the Header & Footer item at the bottom of Insert Menu drop down list.

Then you will view the Header & Footer item.įigure 1: Header & Footer in Excel 2010's Insert Menu.If you have installed Classic Menu for Office, there are three methods to get Header & Footer feature in old views: Method A: Header & Footer in Insert Menu if you have Classic Menu It will help you use Excel 2007/2010/2013’s features in the old view of Excel 2003. Classic Menu for Office Home and BusinessĮasily get Header & Footer if you have Classic Menu for OfficeĬlassic Menu for Office restores classic style menus and toolbars into Office 2007, 2010, 2013, 2016, 2019 and 365 Ribbon user interface.Classic Menu for Office 2007 Applications.

Add footer in excel 2016