Whatever you put in your worksheet header will automatically print out on every page, and this includes images in the header. Once you’ve created your watermark image the next step is to add the watermark to your worksheet header. Save your watermark image as either a PNG or GIF file, making sure the background is transparent Step 2 – Add water mark in Excel Worksheet Header.Use the Crop button to get rid of extra space from your image.Paste the copied WordArt object into Paint.Open MS Paint (or your drawing program of choice).Copy your WordArt to the Windows clipboard (e.g.Create your desired WordArt object in Excel (see instructions above for how to create and resize your WordArt).Here are my steps for using WordArt to create a transparent PNG or GIF image that you can use as a watermark. Refer to my instructions at the beginning of this article on how to create WordArt in Excel 2010, and watch my video on Youtube to watch what I do in Paint. For simplicity I like to use a WordArt image created straight in Excel, and paste this into Paint but it doesn’t have to be text so you could use any image you want. In a drawing program, such as Microsoft Paint, create a picture that you want to use as a watermark. Step 1 – Create your water mark Image in Excel (or a drawing program) As these instructions are longer than the first method above, I suggest you watch my Youtube video below. I created a quick tutorial video lasting 2 minutes 44 seconds, to show step-by-step how to add a watermark image to many pages at once. How to add a water mark Image to the Worksheet Header in Excel This is faster than option 1, and in my opinion also more reliable. With this option you get the same watermark image automatically repeated in all pages on your worksheet. This requires you to paste and reposition your image to fit where you want it to go on every single page – quite a labor intensive task.Īdd a watermark image to the worksheet header. Here are two options for adding a water mark in Excel that prints out on many pages.įollow the instructions above for adding a watermark to the first page, then copy the watermark image to every other page. Adding watermarks to many pages in Excel 2010
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |