How to Add a Watermark Behind an Excel Spreadsheet

How to Add a Watermark behind an Excel Spreadsheet

Hey, welcome back to the Mr. Excel Net cast, I’m Bill Jellen and today’s question send in by Jacqueline from Springfield Missouri. Sounds like it should be an easy thing, how do you put a Watermark Behind your Spreadsheet?

Unfortunately it is not easy at all. Well you know 2007 they made it easy to come back here to page layout tab, choose background and then you can choose a picture and that becomes the background for the Spreadsheet and well that’s fine except for what happens is it doesn’t print. So you have something and it doesn’t print that’s not going to work at all. And here’s what Microsoft says to do. Microsoft says we want to add that to the header and so I’m going to down here to page layout view or I can see the header and we’ll go up to the header and in the header I’m going to insert a picture. So choose a logo one, click insert and when we click out of it here then you see that the logo becomes embedded behind the spreadsheet and this is kind of cool you’re pretty good answer, we can see more pages and now I add data to page two or to page three and that’s the logo in so that’s nice because it’s automatic we don’t have to worry about it if I add data on here or here then we get that logo.

Now you’ll notice that the logo is always appearing near the top so nice solution to that is that we’re going to come in and use either a paint or Photoshop if you have it or something to add some wide space to the top of the logo. It’s a little bit of a experimentation as you transfigure out how much wide space to add. I’ll cup to your header I have and I took my logo and I did logo too here and you’ll see that it kind of move it down a little bit. You’ll have to do some experimentation there to get it down into the seminar of the page where you want it.

The other way to go and this is probably a good way if you have just a single section of data like this and you want to add a background behind that. This is the trick that I used all the time. Are you insert and then go to shapes and I’m going to draw a rectangle, I’ going to hold down the Alt key to make sure that rectangle exactly fills the cells. Cover up the data instead we got to shape the picture and we’ll choose the picture and we’ll choose the picture, click insert, still covering up the cells now. Here’s the important thing, we’re going to format cells control one and here on the fill tab there is a new setting. This is there in 2003 that controls the transparency, I’ll check that out.

So now we can still see our data of the pictures back there as a watermark. Let’s get rid of the lines or under line color, no line quit close and now we have a simple watermark behind our data. Now if I add more pages I may now have to keep adding that picture so it’s not as can be now into this method but I have a lot more control over the transparency and the size and shape of that watermark there so.

Well in Jacqueline for sending in that great question it sound a really easy and not easy at all. Well Thank you for stopping by. Well see you next time for another net cast.


Transcription by: Scribe4you Transcription Services