Page 211 - Excel Workbook for Dummies

21_798452 ch15.qxp 3/13/06 7:41 PM Page 194
194 Part III: Working with Graphics
Excel inserts the selected photo complete with sizing and rotation handles, while
at the same time displaying the Picture toolbar.
10. Move the photo so that its left edge is flush with the left edge of column B and its
top edge is flush with the top of row 5; resize the graphic so that its right edge is
flush with the right edge of column F and its bottom edge is flush with the
bottom of row 19.
11. Use the More Contrast button to increase the contrast in this photo.
12. Click the Line Style button and then select 2 ⁄4 pt on its drop-down menu to put a
1
border around the picture.
13. Click the Format Picture button on the Picture toolbar to open the Format
Picture dialog box and then select the Don’t Move or Size with Cells option
button on the Properties tab before you select OK.
14. Click cell H5 to position the cell cursor in this cell, and then import the Hudson
Lane Interior.jpg file into the worksheet, sizing it so that it covers the cell range
H5:L19, and formatting it to match the photo of the house exterior to its left.
15. Click cell A1 in the 905 Hudson Ln worksheet and then click the Print Preview
button to open this sheet in the Print Preview window.
16. Click the Setup button and then select the Landscape and Fit to 1 Page(s) Wide
by 1 Tall option buttons on the Page tab.
17. Click the Header/Footer tab and then select the Custom Header button.
18. Click the Right Section and then click the Insert Picture button (the one second-
to-the-last on the right).
19. Double-click the thumbnail of the momtrdmk.gif file with the Mind Over Media,
Inc. logo.
Excel inserts an &[Picture] code in the Right section.
20. Click the Format Picture button (the very last one) and enter 75% in the Height
text box in the Scale section of the Size tab in the Format Picture dialog box
before you select OK.
21. Select 905 Hudson Ln, Page 1 in the Footer drop-down list box.
22. Select OK to close the Header dialog box and OK again to close the Page Setup
dialog box.
The Print Preview window now displays Page 1 of the report in landscape mode
with both the entire exterior and interior photos together on the page, the Mind
Over Media, Inc. logo in the upper-right top margin, and the sheet name centered
and the page number right-aligned in the bottom margin.
23. Check your 905 Hudson Ln worksheet against the one shown in Solved15-3.xls in
your Chapter 15 folder. When everything checks out, proceed to step 24.
24. Click the Close button to exit Print Preview and then select cell A1 of the Home
Sales 2006 worksheet and save the workbook in a new file named Solved15-3-
mine.xls in your Chapter 15 folder in the My Practice Spreadsheets folder before
you close the file.

Drawing and adding graphic shapes

The Drawing toolbar enables you to manually draw straight lines, lines with arrowheads
(simply referred to as arrows), rectangular and square shapes, and oval and circular
shapes. To draw any of these shapes, click the appropriate button and drag the thin,
black cross pointer to draw its outline. When drawing a line or arrow, Excel draws the