How to Make Text Over Images With Microsoft Excel

Clip Art and Pictures
1. 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.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.
2. 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.'
3. Click the 'Set Transparent Color' button on the picture toolbar.
4. Click the color on your image you wish to make transparent. Only the text behind the color you choose will be transparent.
5. 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.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
6. 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.
7. Right-click the image and choose 'Format AutoShape.'
8. 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.