40+ Excel navigational shortcuts to make accounting job super efficient

0
2303

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)

LEAVE A REPLY