Excel 2007 Keyboard Shortcuts

VIEWS: 4,709 PAGES: 3

More Info
									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
F2
      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
F4
      command or action.                                                            window.

       Displays Go To                                                           Restores window
F5
        dialogue box.                                                                 size.

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


      Displays Spelling                                                          Performs Move
F7
        dialogue box.                                                               function.

                                                             Add a non-
      Turns extend mode    Opens Macro                     adjacent cell or      Performs Size
F8
          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
                                                                               worksheet.
              current range.        Basic editor.

            Displays the Save
   F12
            As dialogue box.

              Removes cell
 DELETE     contents but leaves
                formatting.

            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
                                                                                                                                        worksheet.
            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.
                                                                                                                                        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.
                                                                                                                                        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
                                                                        Excel 2007
                                                                    Keyboard Shortcuts
                                                                                                                                                   +Ctrl + Alt + Shift
   Key        Stand-Alone              + Alt         +Alt + Shift        + Shift               + Ctrl          + Ctrl-Alt      Ctrl + Shift

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

                                                                                                                            Extends selection
                                                                                           Moves to the                         to the last
                                                                    Extends selection
           Move one cell up.                                                              bottom of the                    populated cell in
                                                                     by one cell up.
                                                                                            current data.                    the same row or
                                                                                                                                column up.

                                                                                                                            Extends selection
                                                                                                                                to the last
             Move one cell        Opens a selected                  Extends selection Moves to the top
                                                                                                                           populated cell in
                down.             drop-down menu.                   by one cell down. of the current data.
                                                                                                                             the same row or
                                                                                                                              column down.

            In a dialogue box,
               performs the
                                                                                          Selects an entire
               action for the      Displays the                      Selects an entire                                       Selects the entire
SPACE BAR                                                                                   column in a
              selected button.     control menu.                    row in a workbook.                                          worksheet.
                                                                                             worksheet.
            Selects or clears a
                 checkbox.
            Moves one cell to
                                                                                          Switches to the                     Switches to the
               the right in a                                         Moves to the
  TAB                                                                                      next tab in a                     previous tab in a
                 worksheet.                                           previous cell.
                                                                                           dialogue box.                       dialogue box.




                                                                            Page 3 of 3
                                           Page 3 of 3
								
To top