Page 248 - Excel Data Analysis
P. 248

13 537547 AppA.qxd  3/4/03  11:58 AM  Page 234







                    APPENDIXAPPENDIX






                  EXCEL KEYBOARD SHORTCUTS



                  DATA ENTRY SHORTCUTS



                      SHORTCUT                    RESULT
                      Enter                       Completes the cell entry and moves to the next cell.
                      Alt + Enter                 Starts a new line within the same cell.
                      Shift + Enter               Completes the cell entry and moves up to the cell above.
                      Tab                         Completes the cell entry and moves to next cell on the right.
                      Shift + Tab                 Completes the cell entry and moves to the next cell on the left.
                      Esc                         Cancels the cell entry and restores original cell contents.
                      Ctrl + D                    Fills the active cell with the contents of the cell above it.
                      Ctrl + R                    Fills the active cell with the contents of the cell to the left of it.
                      Ctrl + F3                   Displays the Define Name dialog box.
                      Ctrl + K                    Displays the Insert Hyperlink dialog box.
                      F2                          Edits the active cell by placing the insertion point at the end of the cell contents.


                  EDITING SHORTCUTS



                      SHORTCUT                    RESULT
                      Ctrl + C                    Copies the selection.
                      Ctrl + X                    Cuts the selection.
                      Ctrl +V                     Pastes the selection.
                      Backspace                   Deletes entire contents of a cell, or character on the left of the insertion point if
                                                  you are editing the cell contents.
                      Delete                      Deletes entire contents of a cell, or character on the right of the insertion point if
                                                  you are editing the cell contents.
                      Ctrl + Delete               Deletes text from the insertion point to the end of the cell contents.
                      Ctrl + Z                    Undoes an action.
                      Ctrl + Y                    Repeats an action (Redo).
                      F4                          Repeats an action (same as Ctrl + Y).
                      Ctrl + -                    Deletes the selection.
                      Ctrl + Shift + +            Inserts blank cells.



                   234
                   234
   243   244   245   246   247   248   249   250   251   252   253