How to Make Text Over Images With Microsoft Excel

Images can make your Microsoft Excel spreadsheets more attractive. Backgrounds are often used to show a business logo or a template. Clip art and drawn images help illustrate points or draw attention to certain parts of your spreadsheet. To use images in your spreadsheet, you need to make the text appear over images. This allows users to read Excel data, while still seeing your images. Most images have transparency settings that allow you to view the text behind them.

Clip Art and Pictures

Step

Add a clip art image or picture to your spreadsheet. Go to “Insert” and choose “Picture.” Select “Clip Art,” “From File” or “From Scanner or Camera.” Select your image to insert it into the spreadsheet. Place the image in your desired location.

Step

Note that if you want to set transparency options on images from your computer, scanner or camera, they must be bitmap images. These images have a .bmp extension.

Step

Right-click the image and select “Show Picture Toolbar.” If the toolbar is already shown, you’ll only see an option to “Hide Picture Toolbar.”

Step

Click the “Set Transparent Color” button on the picture toolbar.

Step

Click the color on your image you wish to make transparent. Only the text behind the color you choose will be transparent.

Step

If transparency settings aren’t available or you need more than one color to be transparent, add a transparent text box over your image. Select “Text Box” from the Drawing toolbar. Go to “View” and select “Drawing” to view the toolbar. Draw a text box over your image. Type in your desired text.

Step

Right-click the text box and select “Format AutoShape.” Select “Colors and Lines.” Set the “Transparency” to 100 percent. Press “OK.” Your text will be visible over the image, but the text box itself will not be seen.

Drawing Images

Step

Draw an image on your spreadsheet. Drawn images are created using tools from the “Drawing” toolbar. Go to “View” and select “Drawing” to view drawing tools.

Step

Right-click the image and choose “Format AutoShape.”

Step

Select the “Color and Lines” tab. Locate the “Transparency” slider. Slide the transparency bar to at least 50 percent. You can also type the transparency in the box beside the slider. Press “OK” to set the transparency. If you need the object to be lighter or darker, repeat the process.