Adding headers and footers in Excel is a useful way to include essential information like titles, page numbers, or file paths on every page when you print your worksheet. Here's how to do it:

1. Switch to Page Layout View:

There are two main approaches to add headers and footers.

* Method 1: Go to the Insert tab. In the Text group, click the Header & Footer button. This will switch your worksheet to Page Layout view, which is specifically designed for working with headers and footers. You'll see the headers and footers sections appear at the top and bottom of your worksheet with dotted lines.

* Method 2: You can also access Page Layout view directly. Go to the View tab and click Page Layout. This achieves the same result as method 1.

2. Add Text or Use Presets:

* Manual Entry: Click directly inside the header or footer section where you want to add text. Type the information you want to display, such as your report title or company name. You can format the text using the formatting options available on the ribbon.

* Presets: The Design tab appears when you enter Page Layout view. This tab offers a variety of pre-built headers and footers you can insert with a single click. Click the Header or Footer button on the Design tab, and choose the desired preset from the dropdown menu. These presets include things like page numbers, date, file path, and sheet name.

3. Insert Page Numbers and Other Elements:

The Design tab also provides buttons for inserting specific elements commonly used in headers and footers. You can click buttons to include:

* Picture: Insert an image into your header or footer.
* Date: Insert the current date, which will automatically update whenever you open or print the workbook.
* Time: Insert the current time, which will also update dynamically.
* Page Number: Insert page numbers, which will automatically adjust based on the total number of pages when you print.
* Sheet Name: Insert the name of the current worksheet.
* File Path: Insert the location of your saved workbook file.

4. Customize Sections (Optional):

The header and footer sections are further divided into left, center, and right sections. You can add different content to each section. Click on a specific section to enter text or use buttons to insert elements there.

5. Return to Normal View (Optional):

Once you've finished editing your headers and footers, you can switch back to the normal worksheet view for data entry and editing. Click the View tab again and select Normal or simply double-click anywhere on the worksheet outside the header and footer areas.

Tips:

* Remember, headers and footers appear only in Page Layout view and when you print your worksheet. They are not visible in the normal worksheet view.
* You can set different headers and footers for the first page (often containing a title page) compared to the rest of the sheets in your workbook. Explore the options under Different First Page on the Design tab.
* To remove headers or footers entirely, right-click on any header or footer section and choose Remove Header or Remove Footer.