Add Graphics To Excel Headers

BY STANLEY ZAROWIN

Q. I just loaded Office XP and I expect great things from it—such as being able to easily add a graphic in an Excel 2000 header, which always has been more complicated than unscrambling the books of a crooked business. Has XP made it any easier to load a graphic in an Excel header?

A. It’s much easier. Here’s how: With the Excel worksheet open, go to the File menu and click on Page Setup . When the dialog box opens, select the Header/Footer tab and select whether you want a Custom Header or Footer (see screenshot).

Then decide whether you want it in the center of the page or on the left or right (see screenshot).

Now click on the Insert Pictur e button (the second button from the right) and a dialog box will open that helps you select the graphic. Once it’s located, click on Insert and the words code &[Picture] will appear in the center section where the graphic will be. Click on OK and OK again. To view the page with the header, return to the worksheet and under File , click on Print Preview (see screenshot).

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.