MS
Office 97/2000/2002
(XP)/2003
|
 |
 |
Access
97/2000/2002/2003
When you have the Database Windows open.
Select any object (table, query, form, report)
Copy it and then right click in an open spot in the Database Window and
Paste.
Now you have a copy of the item and can modify it rather than building from
scratch. Don't reinvent the wheel.
Word 97/2000/2002(XP)/2003
1. If you are a really fast typist you might like this.
When you want a word to be bold, just put an asterisk in front of the word and after it.
Like this: *Word*
Word 97/2000/2002/2003 will change the word from normal text to Bold.
2. If you use _word_ your word will be italic. So the Underline works for this.
3. Just check out the graphic features in Word 97/2000/2002/2003, MS really did a great job on them.
Forget about putting a frame on all of the clipart/pictures. (You don't need them any
more.)
4. Want to make a table just by typing?
+------+------+------+
If you type the above in Word97/2000/2002/2003 you will get a one row three column table when you
press [ENTER].
5. I love this one (I guess because I teach and need examples quick),
on your document
type: =Rand()
This will give you:
The quick brown fox jumps over the lazy dog. The quick brown fox jumps over
the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over
the lazy dog. The quick brown fox jumps over the lazy dog.
Three paragraphs of this so who needs to type!
6. Want to see all of the available styles? Hold down the Shift key and
click the down arrow for styles.
7. AutoComplete: This will complete all of the following for you.
· The current date
· A day of the week
· A month other than the current one
· Your name and company name
· AutoText entries
8. In Word 97/2000/2002/2003, you can merge any adjacent cells --vertically or
horizontally. Select cells on a row or column, then Right click and select Merge
Cells.
Excel 97/2000/2002/2003
1. 65 thousand rows, somebody tell me we are joking.
2. Undo up to the last 16 actions for mistake-free worksheets. YES YES YES!
3. Yes to All option when closing multiple files When you quit
Microsoft Excel 97/2000/2002/2003 with multiple files open, you can choose to save all the files before
exiting, instead of being prompted to close each open file. A popular request from our
customers.
4. I love this one.
Better drag-and-drop editing. Select a range of cells.
Drag the border of a range of cells (this is how we move
cells)
Drag down to the status bar where you have another workbook
open.
The workbook will open when you get over the button on the
status bar.
Once it opens place the cells where you want them.
or hold down ALT to drag the range to a sheet tab in
the same workbook. When you drag a range with the right mouse button, a shortcut menu with
copy and paste options (a lot of menu items) is displayed.
5. Data validation You can specify the type of data allowed in a cell,
such as text, whole numbers, or dates, and the range of valid data, such as numbers less
than an amount you specify or values from a list you supply.
With data validation, you can display custom input and error messages when a user selects
a cell with restrictions or enters invalid data into a cell.
How to get rid of the little items. They do get on your nerves after a while.
Use the Search feature on the Start button menu of the Task Bar
and select For File or Folder... , to locate the little actors.
Type: *.act
in the Name & Location text box.
When you find the file(s), they are normally in the MS Office\Office\Actors
subdiretory.
Rename the files using something like .OLD as the extention on the end of the file.
Now you will never see them again.
In Office 2000, 2002 (XP) and 2003 you can right click the Office Assistant, select
Options (from the shortcut menu), and uncheck the "Use the Office
Assistant".
| 
