Adding Headers and Footers to Your Worksheets

Before distributing a worksheet for viewing on screen, on paper, or as a PDF file, you'll probably want to add headers, footers, or both to identify the pages. Excel gives each worksheet a separate header and footer, which you can fill with either preset text or custom text. Each header and footer area consists of a left section, a center section, and a right section, so you can easily add several different pieces of information.

You can add information to headers and footers either by using the Header/Footer tab of the Page Setup dialog box or by switching to Page Layout view and working directly in the header and footer areas. We'll start with the Page Setup dialog box, which is the easiest way ...

Get Learn Excel 2011 for Mac now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.