How to use keyboard to navigate in the spreadsheet

Excel 2016 2013 2010 2007 2003
To move around the worksheet with your keyboard, use the key combinations:

Up one cell - Up-arrow key

Down one cell - Down-arrow key

Right one cell - Right-arrow key

Left one cell - Left-arrow key

Up one screen - Page Up

Down one screen - Page Down

Leftmost cell in a row (column A) - Home

Lower-right corner of the data area - Ctrl+End

Cell A1 - Ctrl+Home

Last occupied cell to the right of a row - End+right-arrow key

You can also quickly go to a specific cell address in a worksheet using the Go To... feature.

Press Ctrl+G or on the Home tab, in the Editing group, click Find & Select:

Find & Select in Excel 365

Then click Go To...:

Go To in Excel 365

In the Go To dialog box, type the cell address you want to go to into the Reference box, and then click the OK button:

Go to in Excel 365

The Go To... feature keeps a list of cells that you have recently moved to use the Go To... feature. To quickly move to a particular cell in the Go To... list, double-click that cell address.

To move even faster than Go To..., to a specific cell on a worksheet, type the cell's address (the column letter and row number; for example, G18) into the Name box at the left end of the Formula bar and press Enter:

Name box in Excel 365

See also this tip in French: Comment utiliser les raccourcis clavier pour naviguer dans la feuille de calcul.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

Working with spreadsheets

Working with spreadsheets

This tip describes shortcut keys that can be useful for adding, deleting, moving, or coping spreadsheets. See also how to change the color for worksheet tabs, making the spreadsheet very hidden.
Modify cell data

Modify cell data

To enter a value in the cell, activate it by selecting with the mouse or moving the cursor into the cell using the navigation keys, enter the value or type the text, and press the Enter key or one of the navigation arrow keys. See how to change the direction of the cursor after pressing the Enter key.
Move entire column or entire row in Excel

Move entire column or entire row in Excel

Sometimes you need to reorder columns or rows in Excel. If your data does not contain formulas, the procedure does not seem complicated – copy/paste works well for the plain data cells. However, when you try to move data with formulas, you may run into problems.