Prepare a workpaper stamp.Q. With Sarbanes-Oxley pushing on us, we need to stamp every workpaper with a box that includes the following information: Prepared by and Date; Reviewed by and Date. Is there a simple way to attach such a stamp to every spreadsheet spreadsheet Computer software that allows the user to enter columns and rows of numbers in a ledgerlike format. Any cell of the ledger may contain either data or a formula that describes the value that should be inserted therein based on the values in other cells. or document? A. I expect you mean a stamp like this: Prepared Date: By: Reviewed Date: By: There are several ways to do it. In Word, you can use either the AutoText or Picture insert features, and in Excel, which lacks AutoText, use the Picture insert feature. Let's start with Word's AutoText. After creating the table, using Tools, Insert Table, load the stamp in AutoText by highlighting the stamp image, then either press Alt+F3 or click on Insert, AutoText, New, evoking the Create AutoText screen (see screenshot See screen shot. ) and name the insert and click on OK. Then, whenever you want to apply the stamp in Word, click on Insert, AutoText and click on the name you gave it and presto: Since Excel lacks Autoinsert, you have at least two options. The easiest requires that you have graphic-copying software, such as SnagIt (www.techsmith.com), to take a snapshot (1) A saved copy of memory including the contents of all memory bytes, hardware registers and status indicators. It is periodically taken in order to restore the system in the event of failure. (2) A saved copy of a file before it is updated. of the stamp and then store the image in some convenient folder In a graphical user interface (GUI), a simulated file folder that holds data, applications and other folders. Folders were introduced on the Xerox Star, then popularized on the Macintosh and later adapted to Windows and Unix. In Unix and Linux, as well as DOS and Windows 3. . Whenever you want to stamp a worksheet, click on Insert, Picture, From File and then click on the file where you stored the stamp image. If you don't have graphic-copying software, you can copy (Ctrl+C) the stamp image from a Word document and paste it (Ctrl+V) in the Excel worksheet. STANLEY ZAROWIN, a former JofA senior editor, is now 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