What Scrapbook Can Do in Office 2011 for Mac
Recoloring Pictures with Formatting Tools in Office 2011 for Mac
How to Select Worksheet Cells in Excel for Mac 2011

Excel 2011 for Mac: Working with Headers and Footers in Workbooks

Formatting headers and footers in Excel 2011 for Mac adds a distinctive appearance to your printed worksheets. You can also easily include important date and time information. You can work with headers and footers in Page Layout view by choosing View→Page Layout or clicking the Page Layout button in the Layout tab of the Office 2011 for Mac Ribbon.

Entering a header or footer on your Excel 2011 for Mac worksheet

Follow these steps to add a header or footer:

  1. Move the cursor over the white space near the top of a page to add or format a header. Similarly, you can move the cursor over the white space near the bottom of a page to add or format a footer.

    A prompt appears, telling you to double-click if you want to add a header (or footer).

  2. Double-click in the white space.

    Headers and footers are divided into three distinct regions. You’re in the left, right, or center region, depending on where you double-click.

  3. Type your header or footer in the text provided.

  4. Click the Close button or press Esc on your keyboard to exit the Header/Footer dialog.

Formatting your headers and footers in Excel 2011 for Mac

When you're entering or editing a header or footer, you can use the Header and Footer toolbar buttons to make things fancy.

image2.jpg image3.jpg

You can combine codes with text. For example, use Insert Page Number and Insert Number of Pages with additional text like this: Page &[Page] of &[Pages] to print “Page # of #”.

If you prefer the retro look of the old Header/Footer pane from previous versions of Excel, you can still access it by choosing File→Page Setup and then clicking the Header/Footer tab; you can also choose View→Header and Footer.

blog comments powered by Disqus
Navigating Toolbars in Office 2011 for Mac
Opening Files in Office 2011 for Mac
Office 2011 for Mac: Sharing Your PowerPoint Presentation
Office 2011 for Mac: Using the Custom Lists Feature in Excel
How to Perfect Excel Charts in Office 2011 for Mac

Inside Dummies.com