Did you know you could navigate through Excel Spreadsheets using your keyboard only? There are plenty of keyboard shortcuts to use in MS Excel; today we focus on moving between cells.
You would think moving between cells is easy using arrow keys; yes it is but sometimes it does not work. Today, learn how to do it if it happens to you.
Navigating through Excel like a pro becomes easier and easier the more you use shortcut keys. We already shared with you some of them, like Command, Shift, Arrow combinations. Check this article if you don’t know how to use these keys!
Moving cell to cell in Excel – Going right
If arrow keys are not working, press Tab to go to the next cell horizontally.
Moving between cells in Excel – Going left
If you want to select the previous cell, horizontally, press Shift+Tab (in this order or simultaneously).
Moving cell to cell in Excel – Going down
Going to the next cell, vertically in Excel, can be done by pressing the arrow key down or by simply pressing Enter.
Moving between cells in Excel – Going up
Press Shift then Enter (or both keys simultaneously) to move to the cell above the one you selected.
Next time arrow keys don’t work, you know what to do!
Sign up today to our MS Excel Spreadsheet Course and receive a free spreadsheet cheat sheet!
