Excel 2007 Keyboard Shortcuts

Document Sample
Excel 2007 Keyboard Shortcuts Powered By Docstoc
					                                                              Excel 2007
                                                          Keyboard Shortcuts
                                                                                                                                       +Ctrl + Alt + Shift
Key      Stand-Alone           + Alt       +Alt + Shift        + Shift               + Ctrl            + Ctrl-Alt       Ctrl + Shift
                                           Inserts New                          Displays or Hides
F1          Help           Inserts Chart
                                            Worksheet                                Ribbon
      Edits active cell;
       moves cursor to
         end of cell
           contents.                                      Adds or edits cell     Displays Print
      When cell editing                                      comment.               Preview
        is off, moves
      insertion point to
        Formula Bar.
       Displays Paste                                      Displays Insert
F3     Name dialogue                                      Function dialogue
             box.                                                box.

         Repeats last                                                           Closes workbook
      command or action.                                                            window.

       Displays Go To                                                           Restores window
        dialogue box.                                                                 size.

      Switches between                                    Switches between
          worksheet,                                       worksheet, Zoom     Switches to next
      Ribbon, task pane                                   controls, task pane workbook window.
      and Zoom controls.                                     and Ribbon.

      Displays Spelling                                                          Performs Move
        dialogue box.                                                               function.

                                                             Add a non-
      Turns extend mode    Opens Macro                     adjacent cell or      Performs Size
          off or on.       dialogue box.                      range to a           command.
                                                          selection of cells.

                                                                                                      Calculates all                        Re-checks
        Calculates all                                                        Minimizes a             worksheets in                         dependent
                                                           Calculates the
F9      worksheets in                                                       workbook window         open workbooks,                       formulas and
                                                          active worksheet.
       open workbooks.                                                         to an icon.           even if formulas                   calculates all cells
                                                                                                    have not changed.                  in open workbooks.

                                                                  Page 1 of 3
                                                                               Excel 2007
                                                                           Keyboard Shortcuts
                                                                                                                                                           +Ctrl + Alt + Shift
   Key         Stand-Alone               + Alt            +Alt + Shift          + Shift               + Ctrl           + Ctrl-Alt      Ctrl + Shift

                                                        Displays menu or                          Maximizes or
            Turns key tips on                                                Displays the
   F10                                                   message for a                             restores the
                 or off.                                                    shortcut menu.
                                                           Smart Tag.                           workbook window.

            Creates a chart of        Opens the
                                                                             Inserts a new
   F11       the data in the       Microsoft Visual
              current range.        Basic editor.

            Displays the Save
            As dialogue box.

              Removes cell
 DELETE     contents but leaves

            With Scroll Lock
             on, moves to the
             cell in the lower                                                                   Moves to the last
                                                                                                                                    Extends selection
              right corner of                                                                   cell in a worksheet.
                                                                                                                                    of cells to the last
  END             window.                                                                       In the formula bar,
                                                                                                                                     used cell in the
             When a menu is                                                                      moves to the end
            visible, selects the                                                                     of the text.
            last command on
                 that menu.

                                                                                                                                    Selects the current
                                   Moves one screen                                                Moves to the
            Moves one screen                                                                                                           sheet and the
 PAGE UP                            to the left in a                                            previous sheet in a
            up in a worksheet.                                                                                                      previous sheet in a
                                      worksheet                                                     workbook.

                                                                                                                                    Selects the current
            Moves one screen       Moves one screen                                             Moves to the next
                                                                                                                                    sheet and the next
PAGE DOWN     down in a             to the right in a                                              sheet in a
                                                                                                                                        sheet in a
              worksheet.               worksheet.                                                 workbook.

                                                                                                                                    Extends selection
                                                                           Extends selection    Moves to the edge                       to the last
           Move one cell left.                                            by one cell to the   of the current data                 populated cell in
                                                                                 left.               to the left.                    the same row or
                                                                                                                                    column to the left.

                                                                                   Page 2 of 3
Description: An easy-to-read matrix of keyboard shortcuts that will encourage more efficient use of Excel 2007.
This document is also part of a package Financial Models Bundle 7 Documents Included