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.

  1. Select the top left cell within the Toronto data.
  2. Press Ctrl + F3. The Name dialog box appears.
  3. Press N for New.
  4. 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.
  5. Press Enter.
  6. 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.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

Recommended Microsoft Excel training

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft Excel: Introduction to VBA (Visual Basic for Applications)

VIEW MORE COURSES >

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

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Summary
5 Great Microsoft Excel Navigation Shortcuts
Article Name
5 Great Microsoft Excel Navigation Shortcuts
Description
Use these 5 great shortcuts to navigate quickly and save lots of time in your Excel workbooks.
Author
Publisher Name
Avantix Learning Inc.

Pin It on Pinterest

Share This