Internet Fixes Weekly Microsoft Office Newsletter

June 11, 2004Keeping you up-to-date every week!
 
Use shortcut keys to work more efficiently in the Word 2000 Outline view!
The buttons on the Outlining toolbar are designed to help you draft an outline or reorganize your document in Word's Outline view. (You can activate Outline view by choosing View | Outline from the menu bar.) However, when you're drafting an outline from scratch or making extensive revisions, switching back and forth between the keyboard and the mouse can quickly become bothersome. Instead, you can keep your fingers on the keyboard using Word's collection of outlining shortcut keys:

Promote a paragraph: [Alt][Shift][Left Arrow] or
[Shift][Tab]
Demote a paragraph: [Alt][Shift][Right Arrow] or [Tab]
Demote to body text: [Ctrl][Shift]N
(not applicable in Word 2001)

Move selected paragraphs up: [Alt][Shift][Up Arrow]
Move selected paragraphs down: [Alt][Shift][Down Arrow]

Expand text under a heading: [Alt][Shift][+]
Collapse text under a heading: [Alt][Shift][_]
Expand or collapse all text or headings: [Alt][Shift]A
Show all headings with the Heading 1 style: [Alt][Shift]1
Show all headings up to Heading (#): [Alt][Shift](#)

Toggle display between first line of body text and all
body text: [Alt][Shift]L

Hide or display character formatting: [/] (numeric keypad)

Insert a tab character: [Ctrl][Tab]

(Note: To use these shortcut keys in Word 2001, use the
[control] key instead of the [Alt] key.)
Entering Excel 2000 Formulas!
Excel has no special requirements when it comes to entering formulas. The one always necessary item is the equal sign (=). All formulas must begin with an equal sign.

Although Excel will display all formulas in uppercase in the Formula Bar, Excel doesn't care about the case at all. When you enter formulas, you can save yourself some trouble by just entering them in lowercase.

All formulas (sum, average, etc.) place data cells in parentheses. For example

=sum (a1:a5)

works, but

=sum a1:a5

won't work.
Load a specific form when an Access database opens (97-2000-2002)!
When you finish creating an application, chances are that a particular form will receive the majority of the attention from users. If so, you can set up Access to automatically launch the form when the database is opened. To do so, choose Tools | Startup from the menu bar while the database is open. Then, choose the form from the Display Form/Page dropdown list (just Display Form in Access 97). Finally, click OK.

This technique can be used to launch a form that acts as a splash screen or to open a switchboard form that acts as a user interface to your database objects.
Interesting Facts
 
Things to Note
 
Visit The Quick Over View of My Remote Service.
  
 
http://www.internetfixes.com/question.htm

Hit Counter