Printer Friendly
The Free Library
14,588,558 articles and books
Member login
User name  
Password 
 
Join us Forgot password?

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.
COPYRIGHT 2004 American Institute of CPA's
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2004, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion

Title:

Comment:



 

Article Details
Printer friendly Cite/link Email Feedback
Title Annotation:Technology Q&A
Author:Zarowin, Stanley
Publication:Journal of Accountancy
Date:Aug 1, 2004
Words:321
Previous Article:Link a Word document to Excel data.(Technology Q&A)
Next Article:Keep words together on a single line.(Technology Q&A)



Related Articles
Technology Q & A.
Digimarc and Printing Industries of America Partner to Make Digimarc MediaBridge Technology Available to Commercial Printing Market.
Intergraf and Digimarc Team Up to Connect Conference Materials to Online Event Information.
Digimarc Receives 25th Patent; Newest Patent Covers Techniques for Embedding Digital Watermarks Into Video and Audio Content.
DigiTreal to License Digimarc Technology in South Korea; Digimarc Signs Licensing Deal and Makes Investment in South Korean Digital Watermarking...
Technology Q&A.
The Watermark Group Selects MailNOW Software to Drive Print-On-Demand and Grow Direct Mail Services.
Technology Q&A.
Digimarc Announces Digimarc Mobile Client Software for World's Top Camera Phone Platforms.
Digimarc Mobile E-Commerce Pilot Debuts at Popular Tokyo-Based ''Maid in Japan'' Cafe; Cafe in Akihabara District to Pilot Digital Watermarking...

Terms of use | Copyright © 2009 Farlex, Inc. | Feedback | For webmasters | Submit articles