Saturday, 22 September 2012

MicroSoft Excel KeyBoard ShortCuts

BASIC FILE OPERATIONS:
Keyboard Shortcut                             Action Performs

Ctrl + N                                               Open new workbook

Ctrl + O                                               Open existing workbook

Ctrl + W                                              Close active workbook

F12                                                     Save as … different name, location, file
Type

Alt + F4                                               Close Excel

F1                                                       Open help menu


UNDO, RESTORE OR REPEAT ACTIONS:

Keyboard Shortcut                             Action Performs


Ctrl + Z                                                Undo last action

Ctrl + Y                                                Restore undo action

F4                                                       Repeat last action


INSERT, DELETE & COPY CELLS:
Keyboard Shortcut                                        Action Performs


Ctrl + C                                                           Copy selection to clipboard

Ctrl + X                                                           Cut selection to clipboard

Ctrl + V                                                           Paste last selection which cut/copied to clipboard

Delete                                                             Clear contents of current selection
                                                                        (Leave formatting in place)

Ctrl + -                                                            Open Delete Cells dialog box

Ctrl + + (plus)                                                  Open Insert Cells dialog box

Ctrl + ' (apostrophe)                                          Copy contents of cell above into active
Cell; formulas are an exact copy

Ctrl + R                                                           Copy contents of cell to the left into
Active cell; formulas are an exact copy

Shift + F10                                                      Open shortcut - contextual menu;
Use up & down arrow key + enter to make selection


EDIT DATA:
Keyboard Shortcut                                         Action Performs
F2                                                                   Begin editing active cell;
                                                                        Insertion point is at end of cell contents

Home                                                              While in edit mode, move insertion point
to beginning of cell contents

End                                                                 While in edit mode, move insertion point
to end of cell contents

Ctrl + ->                                                          While in edit mode, move insertion point
One word to the right

Ctrl + <-                                                          While in edit mode, move insertion point
One word to the left

Backspace                                                    While in edit mode, delete character to left of insertion point

Delete                                                             While in edit mode, delete character to
Right of insertion point

Ctrl + Delete                                                  While in edit mode, delete all characters
From insertion point to end of cell contents   

F7                                                               Begin Spell Check

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts