With the advent of user interface we are able to use mouse and other input devices. But when it comes to speed, efficiency and productivity keyboard is still EXCELlent above anything else i.e. K is for Keyboard like K is for King. While working in excel we often have to navigate like clicking ribbon, switching windows, opening and closing sheets, scrolling up and down. However, excel comes loaded with navigational shortcuts that can make accountant’s work super efficient.
We have hand picked 40+ navigational shortcuts for everyday excel users that they must not miss. We have arranged them in an order that will help you memorize equally fast. So here you go friends learn these shortcuts and become an excel navigator!
Pointers can do more than just pointing!
| Directional Keys |
Description |
| ArrowUP |
Moves one cell (row) up |
| ArrowDown |
Moves one cell (row) down |
| ArrowLeft |
Moves one cell (column) right |
| ArrowRIGHT |
Moves one cell (column) left |
| Ctrl+ArrowUP |
Moves to next region above |
| Ctrl+ArrowDOWN |
Moves to next region below |
| Ctrl+ArrowLEFT |
Moves to next region on left |
| Ctrl+ArrowRIGHT |
Moves to next region on right |
| ScrollLockON+ArrowUP |
Scrolls worksheet up |
| ScrollLockON+ArrowDOWN |
Scrolls worksheet down |
| ScrollLockON+ArrowRIGHT |
Scrolls worksheet right |
| ScrollLockON+ArrowLEFT |
Scrolls worksheet left |
.
Who knew function keys can function in excel?
| Function Keys |
Description |
| F6 |
Next pane on the workbook |
| Shift+F6 |
Previous pane on the workbook |
| Ctrl+F6 |
Next workbook (if open any) |
| Ctrl+Shift+F6 |
Previous workbook (if open any) |
| Alt+F6 |
Switch to VBA window (if open) |
| Ctrl+F9 |
Minimizes current workbook/window |
| Ctrl+F10 |
Maximizes selected workbook/window |
| Shift+F11 / Ctrl+N |
New worksheet / New workbook |
| Ctrl+F10 |
Maximizes selected workbook |
.
These keys are too good to ignore
| Tab / Backspace / Enter |
Description |
| Ctrl+Backspace |
Scrolls back to active cell on the worksheet |
| Ctrl+Tab |
Switch next window |
| Ctrl+Shift+Tab |
Switch previous window |
| Tab |
Moves one cell (column) right |
| Shift+Tab |
Moves one cell (column) left |
| Enter |
Moves one cell (row) down |
| Shift+Enter |
Moves one cell (row) up |
| Ctrl+Enter |
Completes editing without moving |
| Ctrl+End |
Moves to the bottom right row of last (last cell) of the
region on worksheet |
| Ctrl+Home |
Moves to the start of the worksheet (Cell A1) |
| Home |
Moves to the first cell of active row |
| Ctrl+. |
Cycles through corners of selected range |
.
Its not just about page!
| PageUP / PageDOWN |
Description |
| Alt+PageUP |
Moves one screen left |
| Alt+PageDOWN |
Moves one screen right |
| Ctrl+ PageUP |
Switch to next worksheet |
| Ctrl+PageDOWN |
Switch to previous worksheet |
| PageUP |
Moves one screen up |
| PageDOWN |
Moves one screen down |
.
The END -button!
| End Mode |
Description |
| End mode on > ArrowDOWN |
Moves to next filled cell below (end of region down) |
| End mode on > ArrowUP |
Moves to next filled cell above (end of region above) |
| End mode on > ArrowLEFT |
Moves to next filled cell on the left (end of region left) |
| End mode on> ArrowRIGHT |
Moves to next filled cell on the right (end of region right) |
