How to use keyboard to navigate in the spreadsheet

Excel 365 2016 2013 2010 2007
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 select Edit -> Go To...). Type the cell address you want to go to into the Reference box, and then click the OK button:

go_to in Excel 2003

The Go To... feature keeps a list of cells that you have recently moved to using 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, C25) into the Name box at the left end of the Formula bar and press Enter.

name box in Excel 2003

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.

Adding and removing page breaks

Adding and removing page breaks

On printing worksheet you might not be satisfied with the current pagination, so you might need to insert or remove manual page break.
Protect Excel spreadsheet options

Protect Excel spreadsheet options

To protect your spreadsheet, Excel proposes the following options:
Changing moving direction of the cell pointer after entering data

Changing moving direction of the cell pointer after entering data

Excel automatically moves the cell pointer to the next cell down when you press the Enter key after entering data into a cell, but you can change this behaviour to move it up, down, left, right and even stay on.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more