Application Keyboard Shortcuts

cable.gif (2986 bytes)

MS-Word 97

Task

Keyboard Shortcut

Center, left align or right align a paragraph Ctrl+E, Ctrl+L or Ctrl+R
Undo the last edit Ctrl+Z
Undo more than one edit Ctrl+Z repeatedly
Update a field F9
Insert a footnote or an endnote Alt+Ctrl+F or Alt+Ctrl+E
Increase or decrease the size of selected text Ctrl+] or Ctrl+[ (close or open bracket)
Turn selected text into superscript or subscript text Ctrl++ or Ctrl+=
Turn selected text into hidden text Ctrl+Shift+H
See hidden text Click on the Show/Hide ( ) button
Go the beginning or end of a document Ctrl+Home or Ctrl+End
Go to the beginning or end of aline Home or End
Select an entire table Click on the table and press Alt+5 on numeric keypad (Number Lock must be off)
Display paragraph marks, tab characters, spaces Click on the Show/Hide button
Apply the Normal style to a selected paragraph Ctl+Shift+N
Change the case of selected text Press Shift+F3 until the text is capitalized the way you want
Repeat the last search Shift+F4
Select the entire document Ctrl+A
Copy all selected data Ctrl+C
Cut selected data and place on the Clipboard Ctrl+X
Paste Clipboard data into the current document Ctrl+V
Switch to bold Ctrl+B
Switch to italic Ctrl+I
Create a new document Ctrl+N
Save the current document Ctrl+S
Launch Visual Basic editor Alt+F11
Insert registered sign Alt+Ctrl+R
Insert trademark symbol Alt+Ctrl+T
Insert copyright symbol Alt+Ctrl+C
Go to the top of the document Alt+Ctl+Y
Go into Print Preview mode Alt+Ctrl+I
Apply outline format Alt+Ctrl+O
Go into page layout mode Alt+Ctrl+P
Open a second window Alt+Ctrl+S
Launch AutoFormat Alt+Ctrl+K
List a number field Alt+Ctrl+L
Go back within the document Alt+Ctrl+Z
Insert a comment Alt+Ctrl+M
Insert an ellipsis (…) Alt+Ctrl+. (period)
Toggle in/out of revision mode Ctrl+Shift+E
Toggle italic text Ctrl+Shift+I
Toggle underline text Ctrl+Shift+U
Toggle bold text Ctrl+Shift+B
Select a text size Ctrl+Shift+P
Select a text style Ctrl+Shift+S
Select a text font Ctrl+Shift+Z
Decrease text point size Ctrl+Shift+<
Increase a text point size Ctrl+Shift+>
Close a document window Ctrl+F4
Close Word 97 Alt+F4

 MS-Excel 97

Task

Keyboard Shortcut

Repeat last action Ctrl+Y or F4
Fill down Ctrl+D
Fill right Ctrl+R
Create names from row and column labels Ctrl+Shift+F3
Display AutoComplete list Alt+Down Arrow
Apply outline border Ctrl+Shift+&
Open file Ctrl+O
Print Ctrl+P
Save Ctrl+S
Undo last action Ctrl+Z
Display Function Wizard Shift+F3
Insert blank cell Ctr;+Shift++ (plus sign)
Delete cell selection Ctrl+- (minus sign)
Edit cell note Shift+F2
Move down one screen Page down
Move up one screen Page Up
Move right one screen Alt+Page Down
Move left one screen Alt+Page Up
Move to next workbook sheet Ctrl+Page Down
Move to previous workbook sheet Ctrl+Page Up
Move up through a selection Shift+Enter
Move right through a selection Tab
Move left through a selection Shift+Tab
Format selected element Ctrl+1
Check Spelling F7
Calculate all sheets in all open workbooks F9 or Ctrl+= (equal sign)
Calculate active sheet Shift+F9
Insert AutoSum Formula Alt+= (equal sign)
Insert new chart F11
Insert new worksheet Shift+F11
Apply percentage format Ctrl+Shift+%
Apply two-decimal-place format Ctl+Shift+!
Format as currency Ctrl+Shift+$
Hide rows Ctrl+9
Unhide rows Ctrl+Shift+( (open paren)
Hide columns Ctrl+0 (zero)
Unhide columns Ctrl+Shift+) (close paren)
Move previous workbook window Ctrl+Shift+F6
Move a window Ctrl+F7
Resize a window Ctrl+F8
Minimize workbook Ctrl+F9
Copy entry from the cell above active cell Ctrl+’ (apostrophe)
Enter a formula as an array formula Ctrl+Shift+Enter
Fill selected cell range with same entry Ctrl+enter
Enter date Ctrl+; (semi-colon)
Enter time Ctrl+Shift+: (colon)
Enter a hyperlink Ctrl+K
Copy a value from the cell above active cell Ctrl+Shift+" (quotation mark)
Apply date format with day, month and year Ctrl+Shift+#
Apply time format with hour and minute or Am or PM Ctrl+Shift+@
Remove all borders Ctrl+Shift+_ (underline)

MS-Excel 2000

Task Keyboard Shortcut
Select the current column CTRL+SPACEBAR

Select the current row

SHIFT+SPACEBAR
Move to the beginning of the worksheet CTRL+HOME
Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottommost used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1 CTRL+END
Paste a function into a formula SHIFT+F3
When you enter a formula, display the Formula Palette after you type a function name CTRL+A
Select all (when you are not entering or editing a formula) CTRL+A
Alternate between displaying cell values and displaying cell formulas CTRL+` (single left quotation mark)
Calculate all sheets in all open workbooks F9
Calculate the active worksheet SHIFT+F9
Create a chart that uses the current range F11 or ALT+F1
Enter the date CTRL+; (semicolon)
Enter the time CTRL+: (colon)
Fill the selected cell range with the current entry CTRL+ENTER
Display the Go To dialog box F5
Display the Format Cells dialog box CTRL+1
Copy CTRL+C
Paste CTRL+V
Undo CTRL+Z
Save CTRL+S
Print CTRL+P
 

FrontPage 2000

Task Keyboard Shortcut
Create a hyperlink CTRL+K
Display HTML tags CTRL+/
Create an AutoThumbnail of the selected picture CTRL+T
Preview a page in a Web browser CTRL+SHIFT+B
Display the Microsoft Script Editor SHIFT+ALT+F11
Create a new page CTRL+N
Bold CTRL+B
Italic CTRL+I
Underline CTRL+U
Copy CTRL+C
Paste CTRL+V
Undo CTRL+Z
Save CTRL+S
Print CTRL+P
Open CTRL+O

Home Page Back to M.I.S.


Last modified: October 31, 2005
Yannis Grammatis