When you create an envelope that contains a lengthy delivery address, Word automatically wraps any delivery address lines that exceed a certain width. The point at which the delivery address wraps is tied to the frame width and left indent settings that Word applies to the Envelope Address style each time you create a new envelope.  

Most people think that to avoid this problem in the future, you should be able to permanently modify the Envelope Address style's frame and indent settings to extend the default wrapping point. However, Word's Envelope Address style doesn't work like other styles. Its direct correlation with Word's envelope automation features causes the style to automatically reset itself each time you create a new envelope. You can work around this automation by editing the envelope's frame size and indentation before you print it by choosing Tools/Envelopes And Labels from the menu bar.

Using the tools on the Envelopes tab, create and format your envelope size and address information. When you've finished, click Add To Document. Next, click on the envelope's delivery address to reveal its frame border, and then double-click on the frame border to open the Frame dialog box. In the Size panel, change the Width setting to Auto, and then click OK.  Next, with the frame still selected, choose Format | Paragraph from the menu bar. On the Indents And Spacing property sheet's Indentation panel, modify the Left setting as appropriate, and then click OK.

Word 2000 stores an envelope's delivery address in a text box, not in a frame. To make similar adjustments in Word 2000, double-click on the delivery address' text box border, and then click on the Size tab. Change the Height setting in the Size And Rotate panel as appropriate, and then click on the Text Box tab. Change the Left setting in the Internal Margin as appropriate, and then click OK.

You can now print the envelope. To save your frame width and indent revisions for use in the future, just choose File/Save As from the menu bar to save the envelope as a template. Type a meaningful name for the envelope template in the File Name text box, and then choose Document Template (*.dot) from the Files Of Type dropdown list. When you've finished, click Save. Now you can create new envelopes based on your template by selecting File | New from the menu bar.

To make your documents easier to store, route and locate, Word is equipped to automatically save hidden information within your document, such as authors and editors' names, routing slips and email headers. This information is called Metadata.If you want to send other people your documents without sharing this personal information, you can configure Word to remove it during the save process.

Choose Tools/Options from the menu bar to open the Options dialog box, and then click on the Security tab. In the Privacy Options panel, select the Remove Personal Information From This File On Save check box, and then click OK. Each time you save a document, this setting removes its file properties (i.e., the contents of the Author, Manager, Company and Last Saved By fields located in the Properties dialog box). In addition, names associated with tracked changes, comments and versions are changed to "Author," and routing slips and email headers, if any, are removed. This setting remains in effect for all documents until you disable it again.

There are many techniques that you can use to draw attention to titles, headings and similar text items. For instance, you can apply heading styles to them, center them on the page, increase their font sizes, apply bold or italic formatting, or indent the text that appears beneath them.

A less known but equally effective technique is to apply a negative indent, also known as an outdent, to important text so that it overlaps the left page margin. This gives other text the appearance of being indented, although in reality it' is aligned with the left page margin.

To apply a negative indent, place the insertion point in the paragraph you'd like to outdent, and then choose Format/Paragraph from the menu bar to open the Paragraph dialog box. Click on the Indents And Spacing tab if it isn't already active. In the Indentation panel, use the Left option's bottom scroll button to change the setting to a negative number, such as -0.5". The Preview window displays the effect that the new setting will have on your text. When you've finished, click OK. You can also achieve this effect simply by dragging the Left Indent marker, located on the ruler, to the left of the Left Margin marker.

To print correctly, outdented text must be positioned within the document's printable area, which is determined by your printer.

If you frequently find yourself copying, cutting and pasting items in your Word documents, you may find that using Word's shortcut keys is more ergonomic than using its Cut, Copy and Paste buttons located in the Standard toolbar.

Word's default shortcut key for the Paste command is [Ctrl]-V. However, if you prefer shortcut keys, you can improve the pasting process by configuring Word to use the [Insert] key to paste objects.

To do so, select Tools/Options from the menu bar and then click on the Edit tab. Select the Use INS Key For Paste check box and then click OK. The next time you want to paste an item from the Clipboard in your Word document, simply press [Insert]. Keep in mind that this feature pastes only the item most recently added to the Clipboard.

When you need to print a multi-page document, you can use half as much paper by printing on both sides of each page. Duplex printers make this job easy, but not everyone is fortunate enough to have access to one. However, you can achieve the effects of duplex printing with a standard printer simply by printing your document in two passes.

As all printers behave differently, you may need to make some modifications to the procedures described below. Determining the ideal settings and paper feed positions for your printer will require some trial and error; you are recommended to experiment with a three-page document to determine which combinations produce the desired results. In addition, keep in mind that your printer driver may offer a manual duplex feature you can use instead of Word's printing options. See your printer manual for details.

In Word 2002, you can print on both sides of the page using the new Manual Duplex feature. Open the document you want to print, then choose File/Print. Select the Manual Duplex check box, and then click OK. Word prints the document's odd pages; when it's finished, it prompts you to remove the printout and place it back in the input bin (i.e., the printer's feed tray). Position the stack in the feed tray so it will print on the blank side of each page, then initiate the second pass by clicking OK.

If the fronts and backs of your printout don't match up, access the Print dialog box and then click the Options button. Clear the Front Of The Sheet check box, select the Back Of The Sheet check box, and then click OK to return to the Print dialog box.

In Word 2000, Open the document you want to print, then choose File/Print. To print the first pass, select Odd Pages from the Print dropdown list, and then click OK. To print the second pass, remove the printout and place it back in the printer's feed tray, being careful to position the stack so it will print on the blank side of each page. Choose File/Print, select Even Pages from the Print dropdown list, and then click OK.

If the fronts and backs of your printout don't match up, you may need to reverse the print order for one or both passes. To do so, access the Print dialog box and then click the Options button. Select the Reverse Print Order check box, and then click OK to return to the Print dialog box.

It easy to create a table of contents in Word that maps to your document's styles. This is called the TOC. Usually, You will want create a TOC for the content throughout your entire document. However, sometimes you may wish to limit a TOC to refer to just part of a document. To do this, you can use a bookmark to indicate which portion of your document you want to reference.

First, select the portion of your document you want to reference in a TOC, and choose Insert/Bookmark. Enter a one-word name for the bookmarked selection in the Bookmark Name text box, and click Add.

Next, place the insertion point where you want the table of contents to appear, and choose Insert/Index And Tables. For Word XP, chose Insert/Reference/Index And Tables. Click on the Table Of Contents tab and use the available options to configure your table of contents. When finished, click OK.

To reference just the bookmarked portion of the TOC, select the table of contents, and press [Shift][F9] to reveal the TOC's field code. It will look like this: 

{ TOC \o "1-3" \n \h \z \u }. 

Position the insertion point on the left side of the field code's closing brace (}), and type "\b BookmarkName" (without quotes) where BookmarkName is the name of the bookmark you created earlier. 

Your field code should now look something like this: 

{ TOC \o "1-3" \n \h \z \u \b MyTOC }. 

When you've finished, press [F9] to update the field. If Word asks what you'd like to update, choose the Update Entire Table option, and then click OK. Your table of contents should now reference only the information you bookmarked.

An alternative to using Word’s main menus is to use the right-click method to display shortcut menus. There are hotspots in different parts of Word’s screen displays.

For example, to access the Paragraph dialog box, double-click on any indent marker located on Word's ruler.

If you double-click in the empty space to the left of the ruler indent markers or in the empty space to the right of the ruler indent markers, Word displays the Page Setup dialog box.

If you have set tabs, just double-click on a tab marker on the ruler and Word opens the Tabs dialog box.

If you want to jump to another page of your document, try double-clicking on the page or section number located on the status bar at the bottom left of your screen. This action opens the Go To dialog box.

MS EXCEL TIPS

You can change the format of such a cell easily by selecting the cell with the hyperlink. Use the arrow keys rather than the mouse so that you do not activate the hyperlink. Press [Ctrl]U to remove the underline.

The CEILING function takes the form:

CEILING (number, significance)

CEILING always rounds away from zero. However, the function rounds in multiples of whatever value is specified by the significance argument.

To illustrate how this function can solve our existing problem, assume that the number of wine bottles ordered is stored in cell C2. To calculate the cost based on the required minimum that must be purchased, you would determine the number of complete boxes being ordered using the following formula:

=CEILING(C2,12)

If the value in C2 is 50, the CEILING function rounds the value 50 up to 60. If you change the value in cell C2 to 61, you'll see the required length that must be purchased jumps to the next multiple, 72. If you specify a value that already is a multiple of 12, no rounding change is made to the value.

Note that the value used for the significance argument can also be a decimal value. For example, you can round up to .5 multiples with a formula like so:

=CEILING(123.3,.5)

One restriction to keep in mind is that both the number the function is evaluating and the significance argument must be of the same sign. That is, assuming neither argument is zero, both arguments must be positive or both must be negative.

However, by default, users can still see the formula contained in a protected cell by selecting the cell and looking in the Formula Bar. If you want to prevent users from reading your formulas, you can hide them so that they do not appear in the Formula Bar.

To do so, you need to format the formulas as hidden before applying your worksheet protection. First, select the cells you want to hide from the Formula Bar. Next, choose Format/Cells from the menu bar. Click on the Protection tab and select the Hidden check box.

To do so, open the workbook you want to add the timestamp to and press [Alt][F11] to open the Visual Basic Editor (VBE). Next, double-click on ThisWorkbook in the Project Explorer. Select Workbook from the Object dropdown list and then select BeforeSave from the Procedure dropdown list.