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
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)
