All 24 Shortcuts for Excel 2003 (win/en)  [edit]

Table of Contents:

  1. Basic
  2. Common
  3. Advanced
  4. Unusual

minimize Hide all  maximize Show all

minusplus1. Basic
Ctrl+x Cut selected text
Ctrl+c Copy selected text
Ctrl+v Paste selected text
Ctrl+z Undo
Ctrl+y Redo
Ctrl+f Find
Ctrl+p Print
F2 Edit a cell

▲ up

minusplus2. Common
Ctrl+1 Displays the Format Cell dialog box
Ctrl+Shift+~ Remove cell format
Ctrl+Enter Enter same contents to multiple cells
Alt+Enter Wrap texts in a cell
Ctrl+Shift+Enter Enter a matrix into a cell or multiple cells
F3 Create a list of names in the worksheet
Ctrl+F3 Define a new name
Ctrl+Shift+F3 Create muliple names for a table
Ctrl+; Enter date directly
Ctrl+Shift+; Enter time directly
F9 Update changes in all open workbooks
Shift+F9 Update changes in active worksheet

▲ up

minusplus3. Advanced
Alt+F11 Open VBA editor
F5 Run(execute) a procedure in the VBA window

▲ up

minusplus4. Unusual
Ctrl+Alt+Tab Insert a tab to a cell
Shift+F3 Insert a function

▲ up


Uploaded by johnny8088, updated on 6/13/2012 by johnny8088