| We
are very busy at Promethius and we're always looking for
ways to save time. Below are some shortcuts we've found
for the Microsoft Office 2003 Suite.
1. Quickly draw a line across the page in MS Word by
typing three consecutive hyphens and then pressing the
Enter key.
2. In Word or Excel, easily duplicate multi-step tasks
by creating macros – Go to the Tools:Macro:Record
New Macro. Give your macro a name, click the keyboard
button to assign a shortcut key to activate your macro,
click assign and then click "OK." From this
point until you choose Tools:Macro:Stop Recording, every
keystroke and mouse click you perform will be recorded
for future use. Activate your macro at any time by selecting
your chosen keystrokes
3. Compare documents side by side in Word. Open two documents.
Then, from the Window menu of one of them, select the
Compare Side By Side command.
4. In Excel, when printing charts use the Preview command
to see what they will look like in black and white. You
can preview images in black and white by going to File:Print,
clicking on the Preview button and then the Setup button,
selecting the Chart tab, and then checking the Black and
white box next to Print. The preview will now be in gray
scale, letting you determine if the contrast is sufficient
to distinguish the bars, lines, columns, and so on from
one another.
5. Create Custom Lists in Excel for those lists that
you use over and over. Simply go to the Tools:Options
menu and choose the Custom Lists tab. Choose New List
and type each item or name (one per line) and then click
the Add button. Once you've created the list, you can
type any of the list entries in any cell and then drag
the fill handle to fill the selected cells with the remainder
of the list entries.
6. In Excel, change the direction that the cell pointer
moves when pressing Enter. By default, the cell pointer
moves down when you press Enter after entering data into
a cell. Go to Tools:Options and go to the Edit tab. Check
the box next to Move selection after Enter if it isn't
already enabled, and choose the direction you want the
pointer to move in from the drop-down menu. When working
in a document, you can make the pointer move in the opposite
direction from the one you've chosen by holding down Shift
while you press Enter.
7. Sort by multiple columns in Outlook. Sorting by a
single column in Outlook is a simple matter of clicking
on the column head. Sorting by multiple columns, however,
is not so obvious. First, sort by the first criterion,
such as From, by clicking on the column head. Then hold
the Shift key down as you click on a second heading, such
as Received. Your messages will be sorted primarily by
sender, and all the messages from each sender will be
ordered chronologically. You can even add additional columns
to sort by. Outlook will sort your messages by each additional
criterion within the earlier criteria to give you a multicolumn
sort.
8. Temporarily turn off the navigation pane for extra
reading room in Outlook by using Alt-F1.
If you know of tips and tricks for commonly used programs
and you'd like to share with our readers, please send
them to support@promethius.com.
|
