Question

Which are two ways to add headers and footers in an Excel 2016 document?

Answer 1

To add headers and footers in Excel 2016, you can use the Page Layout tab's 'Print Titles' button or insert them directly from the 'Header & Footer' option in the Insert tab. Both methods offer customization options for a professional look.

Step-by-step explanation:

There are two common ways to add headers and footers in an Excel 2016 document:

1. Via the Page Layout tab: Go to the 'Page Layout' tab on the Ribbon, click on the 'Print Titles' button in the Page Setup group, and then select the 'Header/Footer' tab in the dialog box that appears. Here you can choose from presets or create custom headers and footers.
2. Using the 'Insert' tab: Click on 'Header & Footer' in the Text group. This will switch Excel to Page Layout View, where you can type directly into the header or footer sections that appear at the top or bottom of the worksheet.

Both methods will allow you to add specific elements like page numbers, date, file name, and sheet name to your document's headers and footers, which can be quite useful for organizing and identifying printed materials. Remember to navigate through the 'Design' tab under 'Header & Footer Tools' for additional formatting options and to apply them to different sections of your document.