Navigate using Your Keyboard in Excel Workbooks
by Avantix Learning Team | Updated January 7, 2020
Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows)
Keyboard shortcuts can save you a lot of time in most programs. Also, some people can’t use a mouse due to mobility issues or they are working on a laptop and depend on their keyboard to interact with their programs. In Excel (for Windows), you can save a lot of time with these 5 navigation shortcuts.
Recommended article: 10 Timesaving Selection Shortcuts in Microsoft Excel Worksheets
1. Go home
This is probably the most useful shortcut for most people. Ctrl + Home will move you to the top left cell below the frozen titles – usually cell A1.
2. Go to a specific cell
Press Ctrl + G and the Go To dialog box appears. Type the cell reference in the reference area and press Enter to go to that cell.
3. Move from sheet to sheet
Press Ctrl + Page Up or Ctrl + Page Down to move from sheet to sheet in the current workbook.
4. Move by data area
This is one of our favourite shortcuts. Ctrl + an arrow key moves the current selected cell by data area.
Let’s say you have selected the top left cell in a data range. If you press Ctrl + right arrow, the selection will move to the last cell with data in it on the right. If you press Ctrl + down arrow, the selection will move to the last cell with data in it at the bottom. If you continue pressing Ctrl + an arrow key, Excel will keep moving to the next area with data in it.
5. Move to a named cell or range
Let’s say you have a cell on a sheet that you want to “jump to” quickly. You can name cells specifically for that purpose. In the following example, imagine you have a cell you wish to “jump to” – Toronto in this case.
- Select the top left cell within the Toronto data.
- Press Ctrl + F3. The Name dialog box appears.
- Press N for New.
- Enter a name (such as Toronto). Names can’t have spaces. Excel will suggest the current cell as an absolute reference and the current sheet.
- Press Enter.
- Press Ctrl + G. Any named cells or ranges will appear in the dialog box. Tab to the named cell or range (such as Toronto) you wish to “jump to” and press Enter.
Did you find this article helpful? If you would like to receive new articles, join our email list.
Recommended Microsoft Excel training
Our instructor-led classroom training courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some courses may also be delivered at an alternate downtown Toronto location). Contact us to arrange custom training at your office on a date that’s convenient for you.
To request this page in an alternate format, contact us.
Copyright 2019 Avantix® Learning Inc.
YOU MAY ALSO LIKE
There are many different shortcuts for selecting elements in Microsoft Excel tables. You can use shortcuts to select an entire table, an entire row, an entire column or ranges in tables.
You can use keyboard shortcuts to increase or decrease decimal places. Press Alt to access the Ribbon …
You can easily show or hide formulas in a number of ways in Microsoft Excel. You can use a keyboard shortcut, click a button and even use a formula to show formulas …
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | email@example.com