Paste as Picture Excel 2007

Alan C

Active Member
Joined
Feb 19, 2002
Messages
264
When making a presentation, I sometimes like to paste a theme picture over the data. In Excel 2002/03 the transparency feature allowed me to make the picture transparent enough to read the data. With Excel 2007, the transparency feature doesn't seem to work. I've used many combinations in the format picture toolbox and have not been able to achieve the good results I did in previous versions of Excel. Is this a known issue and does anyone have a solution? Thanks in advance,

Alan
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

MorganO

Active Member
Joined
Nov 21, 2006
Messages
483
I have recreated your dilemma on my end, but have found a work around. Instead of inserting a picture, insert a rectangular shape and then choose Shape Fill | Textures | More Textures.

In the 'Format Picture' dialog choose Insert from: File, choose your picture, then adjust the transperancy below. Then set the shapes line format to No Outline.

Hope this helps.

Owen
 

Watch MrExcel Video

Forum statistics

Threads
1,122,567
Messages
5,596,906
Members
414,110
Latest member
docops

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top