HELP?! Excel gurus????
Thread Starter
PassionFord Post Whore!!
Joined: Jun 2003
Posts: 4,313
Likes: 0
From: Milton Keynes
HELP?! Excel gurus????
Been too long since I did an Excel training course and I cant remember if its possible to water stamp mark a document created in Excel?
I know you can in Word, but does anyone know if its possible in excel, and if so how to do it.
All I want is EXAMPLE water marked across the page.
I know you can in Word, but does anyone know if its possible in excel, and if so how to do it.
All I want is EXAMPLE water marked across the page.
I often create information in Microsoft Excel 2002 that needs to be used before it is complete. I would like to overlay a message such as "INCOMPLETE" in large text across an entire page. Of course, the text needs to be a kind where the information behind it is still visible.
The feature you want is usually called a watermark. According to Excel's Help, "Watermarks are not available in Excel. If you want to display a graphic on every printed page (perhaps to indicate that the information is confidential), you can insert it in a header or footer."
However, you really can create something very much like a watermark, especially if your worksheet is just one printed page. First, choose View | Page Break Preview; Excel will show the page breaks. Click on the WordArt button in the Drawing toolbar at the bottom of the Excel window. (If you don't see this toolbar, right-click in the toolbar area at the top and select Drawing from the list that appears). Select the top left option in the list of predefined WordArt styles—the simple outlined text. Choose the font you want, type INCOMPLETE and click on OK. Now move, size, and turn the WordArt so it's placed just as you want it within the boundaries of the first page.
The watermark you've just created obscures the numbers in the worksheet. To fix this, right-click on the word and choose "Format WordArt." Set the Fill Color to a pastel and set the transparency fairly high—we used pale blue at 75 percent transparency. If you like, change the Line Color as well, then click on OK.
If your spreadsheet is a single page, you're done. If not, right-click on the watermark, choose Copy from the pop-up menu, and paste a copy of it for each additional page, as indicated by the page-break lines. You'll find it easier to match the placement from page to page if all columns are the same width.
The feature you want is usually called a watermark. According to Excel's Help, "Watermarks are not available in Excel. If you want to display a graphic on every printed page (perhaps to indicate that the information is confidential), you can insert it in a header or footer."
However, you really can create something very much like a watermark, especially if your worksheet is just one printed page. First, choose View | Page Break Preview; Excel will show the page breaks. Click on the WordArt button in the Drawing toolbar at the bottom of the Excel window. (If you don't see this toolbar, right-click in the toolbar area at the top and select Drawing from the list that appears). Select the top left option in the list of predefined WordArt styles—the simple outlined text. Choose the font you want, type INCOMPLETE and click on OK. Now move, size, and turn the WordArt so it's placed just as you want it within the boundaries of the first page.
The watermark you've just created obscures the numbers in the worksheet. To fix this, right-click on the word and choose "Format WordArt." Set the Fill Color to a pastel and set the transparency fairly high—we used pale blue at 75 percent transparency. If you like, change the Line Color as well, then click on OK.
If your spreadsheet is a single page, you're done. If not, right-click on the watermark, choose Copy from the pop-up menu, and paste a copy of it for each additional page, as indicated by the page-break lines. You'll find it easier to match the placement from page to page if all columns are the same width.
No1 Blower.
Joined: Jul 2004
Posts: 6,738
Likes: 0
From: Milton Keynes
Originally Posted by Mike Rainbird
If you know how to do it in word, just print off the spread sheet and then put back in printer and reprint off the "EXAMPLE" water mark in word over the top.... 
.
.This is what I do...
Thread Starter
PassionFord Post Whore!!
Joined: Jun 2003
Posts: 4,313
Likes: 0
From: Milton Keynes
Originally Posted by ballin
I often create information in Microsoft Excel 2002 that needs to be used before it is complete. I would like to overlay a message such as "INCOMPLETE" in large text across an entire page. Of course, the text needs to be a kind where the information behind it is still visible.
The feature you want is usually called a watermark. According to Excel's Help, "Watermarks are not available in Excel. If you want to display a graphic on every printed page (perhaps to indicate that the information is confidential), you can insert it in a header or footer."
However, you really can create something very much like a watermark, especially if your worksheet is just one printed page. First, choose View | Page Break Preview; Excel will show the page breaks. Click on the WordArt button in the Drawing toolbar at the bottom of the Excel window. (If you don't see this toolbar, right-click in the toolbar area at the top and select Drawing from the list that appears). Select the top left option in the list of predefined WordArt styles—the simple outlined text. Choose the font you want, type INCOMPLETE and click on OK. Now move, size, and turn the WordArt so it's placed just as you want it within the boundaries of the first page.
The watermark you've just created obscures the numbers in the worksheet. To fix this, right-click on the word and choose "Format WordArt." Set the Fill Color to a pastel and set the transparency fairly high—we used pale blue at 75 percent transparency. If you like, change the Line Color as well, then click on OK.
If your spreadsheet is a single page, you're done. If not, right-click on the watermark, choose Copy from the pop-up menu, and paste a copy of it for each additional page, as indicated by the page-break lines. You'll find it easier to match the placement from page to page if all columns are the same width.
The feature you want is usually called a watermark. According to Excel's Help, "Watermarks are not available in Excel. If you want to display a graphic on every printed page (perhaps to indicate that the information is confidential), you can insert it in a header or footer."
However, you really can create something very much like a watermark, especially if your worksheet is just one printed page. First, choose View | Page Break Preview; Excel will show the page breaks. Click on the WordArt button in the Drawing toolbar at the bottom of the Excel window. (If you don't see this toolbar, right-click in the toolbar area at the top and select Drawing from the list that appears). Select the top left option in the list of predefined WordArt styles—the simple outlined text. Choose the font you want, type INCOMPLETE and click on OK. Now move, size, and turn the WordArt so it's placed just as you want it within the boundaries of the first page.
The watermark you've just created obscures the numbers in the worksheet. To fix this, right-click on the word and choose "Format WordArt." Set the Fill Color to a pastel and set the transparency fairly high—we used pale blue at 75 percent transparency. If you like, change the Line Color as well, then click on OK.
If your spreadsheet is a single page, you're done. If not, right-click on the watermark, choose Copy from the pop-up menu, and paste a copy of it for each additional page, as indicated by the page-break lines. You'll find it easier to match the placement from page to page if all columns are the same width.
Perfecto!
Exactly what I needed, thank you muchly
Thread
Thread Starter
Forum
Replies
Last Post
nicodinho
Ford Non RS / XR / ST parts for sale.
6
Oct 7, 2015 12:56 PM