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
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,510
Messages
5,832,169
Members
430,114
Latest member
kefier

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