Excel Header Setup Tutorial

Excel Header Setup Tutorial:

To set the header step 1: Click on the menu bar "View" menu, select the Drop-down menu "header and Footer" Item (or click the menu bar "file → page settings" or select "file → print preview → settings").

Set Header Step 2: Eject the Page Setup dialog box and select the header and footer item. (quickly open the combination key: "Hold Alt+v, then click H" or "Hold alt+f, then click U" can also open).

To set the header step 3: Click the down arrow following the "header" item, eject the Drop-down menu, see all the formatting of the header, select the appropriate click, and click OK. For example, we select the "page 1th, total page" format and then determine.

To set the header step 4: At this point, we click on the menu bar "Print Preview" (or in the File menu → select print preview), fast key combination: "Alt+f, then click V".

To set the header step 5: To set the "footer" method is the same as the method of setting the header, click "Footer" in step 3rd to select the appropriate format, and then determine, preview the effect of the following figure.