As you know, Excel will allow you to format the appearance of shapes you place in a worksheet. Once you open the Format Shape dialog box, you can make many changes – colors, lines, fills, fonts, and other attributes of the shape.
One of my very favorite formatting features is placing a picture within a shape in my worksheet.
Follow the steps below to learn how:
- Create a shape in your worksheet as you normally would.
- Right-click your shape to display a menu.
- Select Format Shape from the menu to display the task pane at the right side of your worksheet.
- Expand the Fill option by clicking the small triangle to the left of the option.
- Click Picture or Texture Fill. The options in the task pane change to reflect your choice and the name of the task pane changes from Format Shape to Format Picture.
- Now use the buttons under the Insert Picture From heading (File, Clipboard, and Online) to select where Excel should look for the picture you want to use.
- Use the controls Excel offers you to locate and select the picture you want to use in the shape.
- Close the Format Picture task pane.
I am certain there will be many uses to be found for this feature!