Print a watermark on a spreadsheet.Q. Is there a way to print a watermark watermark: see paper. See digital watermark. on a spreadsheet? I know I can add one in Word, but I can't seem to do it in Excel. A. Oddly, although Microsoft lets you print a watermark in Word, it offers no solution in Excel. However, there is a way to do it, and while it takes several steps, it's not too difficult. (To learn how to do it in Word, see the December 2003 Technology Q&A column, page 89.) Begin by opening the WordArt toolbar A row or column of on-screen buttons used to activate functions in the application. Many toolbars are customizable, letting you add and delete buttons as required. Toolbars may be fixed in position or may float, which means they can be dragged to a more convenient location in the in Excel (View, Toolbar, WordArt) and then click on the left-most icon (a right-leaning A) that reads Insert WordArt when you pass your cursor (1) The symbol used to point to some element on screen. On Windows, Mac and other graphics-based screens, it is also called a "pointer," and it changes shape as it is moved with the mouse into different areas of the application. over it. That opens a selection of styles in the WordArt Gallery. Pick a style and click on OK. Replace the word WordArt and type file text of your watermark--for example, DRAFT. Click on OK. If you want the word to be in another color or you want it to be somewhat transparent--that is, less color dense so the underlying data on the spreadsheet will show through--right-click directly inside that text and click on Format WordArt. The Format WordArt screen that appears defaults to the Colors and Lines tab and the color defaults to black. You can play with the various formatting options offered in the screen, but I would suggest the following: See Transparency to at least 70% and click on No Fill and then on OK. Finally, right-click anywhere in the watermark text, and from the shortcut (1) In Windows, a shortcut is an icon that points to a program or data file. Shortcuts can be placed on the desktop or stored in other folders, and double clicking a shortcut is the same as double clicking the original file. menu that appears, select Order and Send to Back. You now have a watermark, and you can adjust its size by clicking in it and with your mouse pulling on the corner boxes that appear. You also can move its location on the spreadsheet, again with your mouse. STANLEY ZAROWIN, a former JofA senior editor, now is a contributing editor A contributing editor is a magazine job title that varies in responsibilities. Most often, a contributing editor is a freelancer who has proven ability and readership draw. to the magazine. His e-mail address See Internet address. e-mail address - electronic mail address is zarowin@mindspring.com. |
|
||||||||||||||||

Printer friendly
Cite/link
Email
Feedback
Reader Opinion