Internet Fixes Weekly Office XP Newsletter

 May 14, 2004Keeping you up-to-date every week!
Create and print a booklet in Word XP!
Word XP makes it easy to create and print a booklet. With just a few clicks of the mouse, Word does the page layout for you; you just have to give Word the number of pages and add the text and graphics.

Follow these steps to create an eight-page booklet that reads from left to right:

Open a blank Word document, click File | Page Setup, and click the Margins tab.
In the Multiple Pages drop-down list, choose Book Fold. Word will change the document layout to landscape mode and the page size to 8 1/2 inches by 5 1/2 inches.
In the Sheets Per Booklet drop-down list, select 8.
Change the inside and outside margins of each booklet page as desired, set the gutter size to accommodate the booklet binding, and click OK.

Enter text, graphics, headers, and footers. When completed, follow these steps to print the booklet:

1. Select File | Print.
2. Set your printer for printing on both sides of the paper. For nonduplex printers, select the Manual Duplex check box. For duplex printers, click the Properties button and choose the proper settings for your printer.
3. Click Print.

Nonduplex printers will print the front side of each sheet in your booklet and then prompt you to reinsert those sheets to print on the back of each.

  Visit Our Windows XP Database Full Of Tips!

Check for numbers stored in a text format in Excel XP!
 Excel can't perform calculations on cell values formatted as text, such as number values that you've imported as text from other databases into Excel. Excel 2002 includes a feature that alerts you to these cells and optionally converts them to numbers.

To activate this feature, follow these steps:

1. Go to Tools | Options.
2. On the Error Checking tab, select the Enable Background Error Checking and Number Stored As Text check boxes, and click OK.

Now, when Excel finds a number in a cell formatted as text, it will place a green error indicator in the upper left corner of the cell. To convert cells to a number format, select the cell, click the Error Checking Options button displayed to the left of it, and select Convert To Number.
Remove the underline from a text hyperlink in PowerPoint 2002!
By default, when you assign a hyperlink to existing text on slide, the text appears during your presentation with the underline format. Often this is a good way to differentiate it from normal text, but sometimes the slide's design or the manner in which you wish to give the presentation benefits from a concealed hyperlink. And if you've ever tried to highlight the text on the slide and then reformat it, you know that this method won't get rid of the underline.

But there is a way to rid your hyperlinked text of the underline format. First, remove the existing hyperlink by simply selecting the text on the slide, right-click on it and choose Hyperlink | Remove Hyperlink from the shortcut menu. Since there's no longer a hyperlink assigned to the text, the underline format disappears. Next, select the text box (rather than the text within the text box), press [Ctrl]K or right-click on it and choose Hyperlink from the shortcut menu to display the Insert Hyperlink dialog box. Then simply add the desired hyperlink as you normally would and click OK. Now, when you view your slide show, your text won't be underlined, yet when you click anywhere in the text box, you'll be brought to the destination you assigned to the text box in the Insert Hyperlink dialog box.
Interesting Facts
  
Hit Counter