Teach Yourself VISUALLY Excel 2016 (Teach Yourself VISUALLY (Tech)) by Paul McFedries

Author:Paul McFedries [McFedries, Paul]
Language: eng
Format: azw3
ISBN: 9781119074717
Publisher: Wiley
Published: 2015-09-28T16:00:00+00:00

Click the View tab.

Click Page Layout ().

Excel switches to Page Layout view.

You can also click the Page Layout button ().

Click the Add header text.

Excel opens the header area for editing.

Excel adds the Header & Footer Tools tab.

Click the Design tab.

Type your text in the header.

If you want to include a predefined header item, click Header and then click the item.

Click a button in the Header & Footer Elements group to add that element to the header.

Excel inserts a code into the header, such as &[Date] for the Current Date element, as shown here.

Repeat steps 5 to 7 to build the header.

Click outside the header area.

Excel applies the header. When you are in Page Layout view, you see the current values for elements such as the date.

TIP

Can I have multiple headers in a workbook?

Yes. You can have a different header and footer on the first page, which is useful if you want to add a title or explanatory text to the first page. In the Design tab, select the Different First Page check box ( changes to ).

You can also have different headers and footers on the even and odd pages of the printout, such as showing the filename on the even pages and the page numbers on the odd pages. In the Design tab, select the Different Odd & Even Pages check box ( changes to ).

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.