Microsoft Office Tutorials and References
In Depth Information
Adding images to worksheets
If you want to generate a repeating image in the background of a worksheet to form a tiled
pattern behind your worksheet’s data, you can display the Page Layout tab, and then in the
Page Setup group, click Background. In the Insert Pictures dialog box, click Browse to open
the Sheet Background dialog box, navigate to the folder that contains the image you want
to serve as the background for your worksheet, click the image, and click OK.
TIP To remove a background image from a worksheet, display the Page Layout tab, and
then in the Page Setup group, click Delete Background.
To achieve a watermark-type effect that has words displayed behind the worksheet data,
save the watermark information as an image, and then use the image as the sheet
background; you could also insert the image in the header or footer, and then resize or scale it
to position the watermark information where you want it.
In this exercise, you’ll add an image to an existing worksheet, change its location on the
worksheet, reduce the size of the image, and then set another image as a repeating
background for the worksheet.
SET UP You need the CallCenter workbook and the phone and texture images located
in the Chapter04 practice file folder to complete this exercise. Open the workbook, and
then follow the steps.
On the Insert tab, in the Illustrations group, click Pictures to open the Insert Picture
Navigate to the Chapter04 practice file folder, and then double-click the phone
image file to add the image to your worksheet.
On the Format tool tab, in the Adjust group, click Remove Background to have Excel
attempt to separate the image’s foreground from its background.
Drag the handles at the upper-left and lower-right corners of the outline until the
entire phone, including the cord, is within the frame.