WonderHowTo Microsoft Office. * Add a simple header or footer. * Use AutoText to quickly insert common header and footer information. How To: Explore bigger grids in Microsoft Excel: Mac 2008 Start using Microsoft Word: Mac 2008. You can use the Picture feature of the Header/Footer toolbar in Excel 2011 for Mac to insert a picture as a watermark. In an electronic environment, you create a watermark by formatting text and pictures to appear only faintly and then putting them into the background.
Excel users have, for years, asked if there is a way to place graphics in headers or footers. Various methods have been devised to do just that, as discussed in other ExcelTips. Users of Excel 2002 and Excel 2003 may be glad to know that it is even easier to add graphics to headers or footers. In fact, Microsoft added a direct capability to place graphics in headers or footers.
Just follow these steps:. Choose Page Setup from the File menu.
Excel displays the Page Setup dialog box. Make sure the Header/Footer tab is selected. (See Figure 1.) Figure 1. The Header/Footer tab of the Page Setup dialog box.
Click on the Custom Header or Custom Footer button, depending on which one you want to change. Excel displays either the Header or Footer dialog box. (See Figure 2.) Figure 2. The Footer dialog box. Select the section of the header or footer (left, center, or right) in which you want your graphic to appear. Click on the Insert Picture button. It is the second button from the right.
Excel displays the Insert Picture dialog box. Use the controls in the dialog box to locate and select the graphic you want in the header or footer. Click on Insert. Excel places the graphic at the designated spot in the header or footer, displaying the code &Picture where the graphic will appear. Make other changes to the header or footer, as desired. Click on the OK button to close the Header or Footer dialog box.
Click on OK to close the Page Setup dialog box.
Page Layout View is a 'working' view introduced in Excel 2007. It is a great tool to become familiar with. When you combine this 'View' with the commands on the Page Layout Tab of the Ribbon, you can quickly create custom headers and footers for your printed worksheets. For example, you might want to include your company logo on each page along with the current date and the number of pages in your report. Watch as I demonstrate how to do this qucikly and efficiently. I invite you to visit my website - www.thecompanyrocks.com - to view all of my videos and examine all of the resources that I offer you.
Sincerely, Danny Rocks The Company Rocks.