Internet Fixes Weekly Office XP Newsletter

April 30, 2004Keeping you up-to-date every week!
Include an equation in a Microsoft Word 2002 document!
You can easily take the equation as shown and modify the formatting of the numbers to get what you want. First highlight the 1 and choose Font from the Format menu. Check Subscript and click OK. Repeat this step for the first 2; for the second 2, check Superscript instead. The result looks like this:

F=GM1M2/G2

But you can get a much more attractive result using the Equation Editor. When you click the Equation Editor button in the Field dialog, some Word 2002 installations erroneously report that the feature is not installed. To get around this, select Object from the Insert menu, choose Microsoft Equation 3.0, and click on OK. This should bring up the Equation Editor.

To start, type F= in the editor. Now click on the Fraction and radical templates button in the floating Equation toolbar. Keep an eye on the status bar as you move the mouse for a text explanation of each button. In this case, you want the Full-size vertical fraction template.

Click on the top portion of the fraction and type GM. Then click the Subscript and superscript templates button and click on Subscript. Type the 1, then right-arrow to get out of the subscript template. Type the second M and add its subscript 2.

Click on the bottom part of the equation, click the Greek characters (uppercase) button, and choose gamma (G). Then assign it a superscript 2 in the same way you created the subscripts.

Keyboard shortcuts can make the process a lot easier, though you'll have to do some digging to find the ones you need. Here's how you can create our equation in the Equation Editor using shortcut keys.

1. Type F=, then press Ctrl-F (for fraction).

2. Type GM, press Ctrl-L (for a subscript), then type 1.

3. Press the Right Arrow to move out of subscript mode and type M. Press Ctrl-L and type 2.

4. Hit the Tab key twice to move to the denominator.

5. Press Ctrl-G for Greek characters and then Shift-G for the gamma.

6. Press Ctrl-H (for a superscript), type 2, and you're done.

  Visit Our Windows XP Database Full Of Tips!

Restore the last saved version of a form or report in Access 2002!

Starting with Access 2002, you can finally undo multiple actions when working with a form or report in Design view. Access 2002 lets you undo the last 20 changes, whereas prior versions could only undo the most recent change. Even if you're using an older version of Access, there is a way to undo all changes that have been made to a form or report since the object was last saved. To do so, choose File | Revert from the menu bar. Note that this also restores any associated VBA code to its original state. 

 

While the Revert command may be convenient when you want to undo unwanted changes in one fell swoop, use it judiciously. Once you execute the Revert command, all of your changes are lost -- you can't selectively recover changes. Essentially, the result is the same as closing the object without saving and then reopening it.

Easily add more information to your Excel 2002 chart data labels!
Prior to Excel 2002, the data label associated with a chart data point could show only one data element at a time. For instance, you could display the exact value that the data point represented, or the percentage of the total that it represented, but not both. If you wanted to show additional information about a data point, such as the series name, you had to manually add a label and enter the appropriate value -- which of course had to manually be changed if the chart's underlying data changed.

Excel 2002 simplifies matters by allowing you to mix and match label elements as needed. In addition, the number of options available to you has increased (some options only apply to certain chart types). Your available choices now are:

- Series Name
- Category Name
- Value
- Percentage
- Bubble Size

To configure data labels, select your chart and choose Chart | Chart Options from the menu bar. Then, click on the Data Labels tab. Select the appropriate check boxes in the Label Contains panel and click OK.

Interesting Facts
Things to Note
Your hard disk will crash. Count on it. 

It happens to everyone eventually. And when it does you will be glad you have a backup copy of all your data. 

You do have an up-to-date backup, don't you? 

You don't? Never fear. Here are the simple ways you can use one of our Batch files to backup your data for you. Just Click Here!

 

WE DEPEND ON YOUR DONATIONS

 

Have questions about Office XP.  Just Click Here And Tell Us About Them!

 

Hit Counter

  
http://www.internetfixes.com/question.htm