Add a background picture to a worksheet that is printable and semi-transparent.
Tags:How to Add a Background Picture to an Excel Worksh,Excel Lesson,excel tutorial,Excel Worksheet,excel,MrExcel,spreadsheets
Grab video code:
Hey, alright, I hate to even do this when I was aware was it Wednesday, because it was hard to find an excel 2003, I don’t think anyone could ever find that. I have a question today from Nada. Nada says, “hey when we use a page layout and background utility to apply background it automatically gets tiled” and he says, “ that is not what I’m wanting, I just want to put a nice background back there behind a certain range and not having it tiled”, and you would think that this would be really easy to do, but if we try and to insert picture, I cannot find anyway to make that picture be transparent, I’ve right clicked, I’ve searched everywhere and I just can’t find it, and I know that I’ve done an excel 2003 and when I went back to excel 2003 I figured out where it was, turns out that I had a different trick back in excel 2003, I would insert not a picture, but a shape. So I’ll insert a shape here and I’ll actually what I’m going to do, I’m going to drop it right on top of the pictures though I know it’s the right size. So insert a shape and make it be exactly the same size as that picture. Now watch this, here’s what we’re going to do, we’re going to right click, say format, shape and I’m going to change the fill to a picture or texture fill. And I’ll insert from file and I’ll choose an exact same picture. Now that I’ve inserted the picture I finally have access to the transparency setting, so kick that up to 73 or so. I also want to get rid of the line style, to no lines, that way I don’t have a boarder around the picture, click close and right click and choose cut on the original picture and now put our new picture up here and so it’s nice little background; and now we can now go in and enter any numbers we want to enter and we are good to go. Alright so there is the very difficult trick for getting a nice picture watermark, and it’s not tiled behind your cells. The advantage of this by the way is that it does print or as the background, page layout background, let’s try that real quick see if it’s changed at all, so insert page layout background, and then if we go into, let’s put some data here, go into print preview; the background that you do in page setup is only for display, it’s not for printing, so this is actually a good way to get the picture there even when you print.
All right, so thanks for stopping by. See you next time, for another net cast from Mr. Excel.