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).

PODCAST

What’s next for potential CPA licensure changes

A new model proposed by NASBA and the AICPA is designed with an eye on the future for newly licensed CPAs. The AICPA's Carl Mayes, CPA, provides background on the project and a look ahead to 2020.

VIDEO

What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.