Question

how do you set a header and footer for your worksheet ​

Answer 1

Answer:

You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, and the name of your file. You can create your own, or use many built-in headers and footers.

Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. 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. For other sheet types, such as chart sheets, or charts, you can insert headers and footers only by using the Page Setup dialog box.

Add or change headers or footers in Page Layout view::

• Click the worksheet where you want to add or change headers or footers.

• On the Insert tab, in the Text group, click Header & Footer.Excel displays the worksheet in Page Layout view.

• To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer).

• Type the new header or footer text.

♠Hope this may help you ♠