07/20/08

 

Useful Shortcut Keys in Excel 2000

Do you find that using the keyboard is sometimes quicker than using your mouse? Shortcut keys can help you bypass menus and carry out commands directly. You can use shortcut keys in many ways with Excel, from accessing commands and toolbar buttons to outlining and editing information. Shortcut keys are sometimes listed next to the command name on menus. For example, on the Edit menu, the Copy command shows the shortcut CTRL+C.

For a comprehensive list of shortcuts, ask the Office Assistant for help. In Excel 2000 or any of the other Office 2000 applications, press F1 to display the Assistant, and then type shortcut keys in the text box. Here are some of the most useful Excel shortcut keys:

Activity Shortcut Keys
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
Open CTRL+O

Additional Resources

For more information about keyboard shortcuts in Excel 2000, see the following:

In addition, you can download A List of Useful Office 2000 Shortcut Keys.

 

2001 Microsoft Corporation. All rights reserved. Terms of use. Disclaimer. Privacy Statement.

 

 

Created Date: 10/17/2001  Last Reviewed: 10/17/2001  Rev. Date: 

This site was last updated 06/11/06