Excel Keyboard Shortcuts - PDF

							                                               Excel Keyboard Shortcuts
                                           Activity                                                         Shortcut Keys
  Cut                                                                                               CTRL+X

  Copy                                                                                              CTRL+C

  Paste                                                                                             CTRL+V

  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 bottom most used                                CTRL+END
  row (in the lower-right corner).

  Move one cell to the RIGHT.                                                                       TAB

  Move one cell to the LEFT.                                                                        SHIFT + TAB

  Move one cell or row DOWN.                                                                        ENTER

  Move one cell or row UP.                                                                          SHIFT + ENTER

  Move one cell in a specific direction.                                                            ARROW KEYS

  Paste a function into a formula                                                                   SHIFT+F3

  When you enter a formula, display the Formula Palette after you
                                                                                                    CTRL+A
  type a function name

  Select all (when you are not entering or editing a formula)                                       CTRL+A

  Create a chart that uses the current range                                                        F11 or ALT+F1

  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

  Undo                                                                                              CTRL+Z

  Save                                                                                              CTRL+S

  Print                                                                                             CTRL+P

  Open                                                                                              CTRL+O




Putting Excel to Work in the Library Fall 2004 - This material has been created by Sandy Lamoureux for the Infopeople Project
[infopeople.org], supported by the U.S. Institute of Museum and Library Services under the provisions of the Library Services and Technology
Act, administered in California by the State Librarian. Any use of this material should credit the author and funding source.