Quick
tips everyone should know
about Word & Excel
|
 |
 |
Word versions - Excel versions below
1. Hot spots on the screen:
Double-click the top half of the ruler with your pointer will give you
Page Setup dialog box
Double-click the word Page in the status bar at bottom left will give
you the GoTo dialog box (F5)
Double-click the small square box under the triangles on the ruler
marking the left margin you get the Paragraph dialog
2. To select a toolbar quickly right click any button
on the toolbar will give you a menu to select your toolbars
In fundamental classes this is how most participants hide there toolbar.
They accidentally hit the right mouse button and turn off the standard toolbar.
3. Remember you do not need file manager to copy move
delete or print a file in word 6.0 use the File: Find File:
In the Find File dialog window click the Command button to find all of
these. Remember if you have not used this feature before you will get Search Dialog first
(do a search) then you get the Find File dialog. In 7.0 you just right click the file to
do the above.
4. If you are editing a large document a good hot key
to remember is Shift - F5 this key returns to the last edit in the document. So after you
complete all of your new modifications press Shift - F5 and you return to each spot in
your document where you have made a modifications.
5. Remember F4 is repeat in Word, if I make a word bold
then double click another word I press F4 it's bold. This works for anything. Styles,
paragraph settings anything.
6. F12 is Save As...... For the keyboards
7. For the time you show the Format Painter the Short
cut keys for that is Ctrl-Shift-C to copy Ctrl-Shift-V to Paste
8. Centering a table is not in any of the books we
teach so here is how to do it. Remember when you first create a table it is from margin to
margin, so this is after you autoformat it or reduced the width of the columns.
After you select the table (highlight);
Select: Table: Cell Height and Width
Make sure the tab Row is select and select Center option at the bottom
of dialog
Click OK
9. For the more advanced users who want to control the
table completely you can tell the to put a frame around the table then you can put the
table anywhere you like.
Select: Insert: Frame
Answer Yes
10. How do I put a border around my document?
Select: View: Header and Footer
Click on the Drawing toolbar button (top right - Standard toolbar)
Click on the rectangle button (to turn on the tool)
How on the document - Press and hold - and draw a border around the
page.
1. To SELECTS a table. (a group of
cells with numbers and labels in them) press: Ctrl - Asterisk (on the ten key
pad) or Ctrl - Shift - Asterisk (the upper case 8 for you Touch typist.
For the above: The active cell needs to be in the group of
numbers, labels that make a table. A good file in
the fundamental book to show this is 4list.xls
2. To move quickly in your table. If you are at the top
of table - Double-click the bottom border of the active cell (with standard pointer) it
will move you to the bottom. If there are no blanks. This works in all 4 directions. If
you add the Shift Key when you double-click it will highlight as it goes. Great for
selecting the headers when not all are showing on the screen.
3. F2 to edit
4. F5 for GoTo and the name box as a go to.
5. F11 to make a chart. I usually tell them it is 9:29
I've got a 9:30 meeting and I forgot to make a chart so highlight the area on your
spreadsheet with your numbers and labels, hit F11, instant chart and you walk into the meeting saying
something like, " I worked hard on this chart - all morning"
6. Ctrl + ; = date
7. Ctrl + ' = copy from cell above
8. Right Mouse click is power
Excel versions
1. The AutoFill can do more: Right drag the AutoFill
handle to get a menu, (more selections)
2. Select some labels (most participants type the same
labels to build a spreadsheet) then:
Select: Tools: Options: Custom List:
Click the Import button at bottom right and you have a list you can
duplicate with the AutoFill handle anytime. Just type any one of the words that was in the
list and drag the AutoFill handle.
3. Sorting is hard sometimes when you have a group of
items that you want in a certain order but not the standard way.
example: High Medium Low
If you sort as they are you will get - High Low Medium
I want High Medium Low - so I can ship out all of my High priorities
first, etc.
GoTo Tools: Options: Custom List:
In the text box Type:
High [enter]
Medium [enter]
Low [enter]
click on the Add button on the right
click OK
Now select the column that has the high medium and low listed (if you do
it in class you will need to create it)
GoTo Data: Sort:
Click Options button
Click the down arrow for First Key sort order
Select High Medium Low from the list
Click OK
Click OK
Now your list is in the correct order by all the Highest first Mediums
second, Lows last.
And as you have probable guessed by now you can do months without using
a 1 for Jan a 2 for Feb as I use to do in Lotus.
4. Another Big question in class is how can I see two
different sheet at the same time that are in the same workbook.
Select Window: New Window
Select Window: Arrange: Title (I like Title myself)
5. To move to sheets very fast: Right click the
navigation buttons at the bottom left corner of the workbook.
Select the sheet you want to GoTo or More sheets.... if the one you want
is not showing.
Then double click it.
| 
