MS Excel Shortcut Key's

Shortcut key              Description

End + Shift + End                 Extends the selection to the last cell in the current row*

End + Shift + Home              Extends the selection to last used cell on the worksheet

Alt + '                                      Displays the Style dialog box

Ctrl + Shift + ( ' or )              Applies the Time format "hh:mm" to the selection

Ctrl + Shift + (1 or !)             Applies the Comma separated format "#,##0.00" to the selection

Ctrl + Shift + (4 or $)            Applies the Currency format "£#,##0.00" to the selection

Ctrl + Shift + (5 or %)          Applies the Percentage format "0%" to the selection

Ctrl + Shift + (6 or ^)            Applies the Exponential format "#,##E+02" to the selection

Ctrl + Shift + (# or ~)            Applies the General format to the selection

Ctrl + (# or ~)                         Applies the Custom Date format "dd-mmm-yy" to the selection

Ctrl + Shift + (7 or &)           Applies the outline border to the selection

Ctrl + Shift + (- or _ )            Removes all the borders from the selection

Arrow Keys                           Moves to the next cell in that direction

Ctrl + Tab                              Moves to the next open workbook or window

Alt + Tab                                Moves to the next application open on your computer

Alt + Shift + Tab                   Moves to the previous application open on your computer

Enter                                      Moves to the cell directly below

Tab                                         Moves to the next cell on the right (or unprotected cell)

Home                                      Moves to the first column in the current row

End + Arrow Keys                Moves to the next non empty cell in that direction

End + Enter                           Moves to the last cell in the current row that is not blank

End + Home                           Moves to the last used cell on the active worksheet

End + Home                           Moves to the last used cell on the active worksheet

Shortcut key              Description

Page Down                             Moves to the next screen of rows down

Page Up                                  Moves to the previous screen of rows up

Shift + Enter                          Moves to the cell directly above (opposite direction to Enter)

Shift + Tab                             Moves to the cell directly to the left (opposite direction to Tab)

Alt + Page Down                   Moves you one screen of columns to the right

Alt + Page Up                        Moves you one screen of columns to the left

Ctrl + Home                           Moves to cell "A1" on the active sheet

Ctrl + End                              Moves to the last used cell on the active worksheet

Ctrl + Up Arrow                   Moves to the first row in the current region

Ctrl + Down Arrow              Moves to the last row in the current region

Ctrl + Left Arrow                 Moves to the first column in the current region

Ctrl + Right Arrow               Moves to the last column in the current region

Ctrl + Page Up                      Moves to the previous worksheet in the workbook

Ctrl + Page Down                 Moves to the next worksheet in the workbook

Ctrl + Shift + Tab                 Moves to the previous open workbook or window

Scroll Lock + Arrow Keys   Moves the workbook or window one cell the corresponding direction

Scroll Lock + End                 Moves to the last cell in the current window

Scroll Lock + Home              Moves to the first cell in the current window

Scroll Lock + Page Down     Moves you down one screen (current selection unchanged

Scroll Lock + Page Up          Moves you up one screen (current selection unchanged)

Enter                                      Moves from top to bottom within a selection

Tab                                         Moves from left to right within a selection