See all How-To Articles

Excel – Go To Cell, Row, or Column Shortcuts

In this tutorial, you will learn how to go to a specific cell, column or row using keyboard shortcuts.

 

jump to a row go to 3

 

Move to a Cell With Go To

In Excel, you can easily move from one selected cell to another using the Go To option. Say you have cell A1 selected and want to move to and select cell C3.

1. Select a cell (e.g., A1), and in the Ribbon, go to Home > Find & Select > Go To (or use the keyboard shortcuts CTRL + G or F5).

 

jump to a cell go to

 

2. In the Go To window, (1) enter the cell you want to move to (e.g., C3) in the Reference box and (2) click OK.

 

jump to a cell go to 2

 

As a result, you moved from cell A1 to cell C3, which is now selected.

 

jump to a cell go to 3

 

Move to a Row With Go To

Just as with a cell, you can also move to and select an entire row using the Go To functionality. This time, say you want to move from cell A1 and select Row 3. To achieve this, follow Step 1 from the previous section.

In the Go To window, (1) enter the row you want to move to in the format row:row (e.g., 3:3) in the Reference box, and (2) click OK.

 

jump to a row go to

 

You will have moved from cell A1 to Row 3, which is now entirely selected.

 

jump to a row go to 2

 

Move to a Column with Go To

Moving to a specific column follows exactly the same path.

In the Go To window, (1) enter the row you want to move to in the format column:column (e.g., D:D) in the Reference box, and (2) click OK.

 

goto column

 

You will have moved from your current cell to Column D which will be entirely selected.

Move to a Cell on a Different Sheet

To move to a cell on a different sheet, you need to type the sheet name into the Go To window.

In the Go To window, (1) enter the row you want to move to in the format sheetname!cell (e.g. Sheet3!A5) in the Reference box, and (2) click OK.

goto different sheet

You will then move to the specified cell in the specified sheet.

NOTE: the sheet name has to have an exclamation mark after it to indicate that it is a sheet. (!)

Move to a Range Name or Table with Go To

You can also use the Go To Window to move to any range names or tables that have been created in your workbook.

In the Go To window, (1) click on the range name or table in the Reference box, and (2) click OK.

goto table

Your range name or table will be selected.

goto table selected

Move to a Cell With the Name Box

You can also move to a cell using the name box. The name box is a box that is positioned to the left of the formula bar and shows the name of a selected range.

1. To move from A1 to C3, first select cell A1.

2. Then in the name box, type C3 and press Enter.

 

jump to a cell name box

 

The result is the same as with the Go To option, and cell C3 is selected.

Move to a Row or Column With the Name Box

Just like in the previous section, you can move to a specific row with the name box.

1. To move from cell A1, and select entire Row 3, select A1.

2. Then in the name box, type 3:3 to move to row 3, or D:D to move to column D and press Enter.

 

jump to a row name box

 

Again, the entire Row 3 or Column D will be selected.

Move to a Range name or Table with the Name Box

To move to a range name or table using the Name box, type in the range name or table name into the name box and then press Enter.

goto name box

The entire range name or table will be selected.

Moving aroung the Worksheet with the Home and Arrow keys

The first cell in a worksheet is always cell A1.  To move there quickly using they keyboard, press Ctrl+Home.

To move to the last occupied cell in a worksheet, press Ctrl+End.

To move to the first cell in the currently selected row, press Home.

Moving to the first cell of a column is a bit more complicated!   Press Ctrl+Up Arrow or End, Up Arrow to move up to the last cell used in a column above your currently selected position.  You can then press Ctrl + Up Arrow OR End, Up Arrow to move up to the last used cell in the range of cells you have moved to.  You can continue pressing Ctrl+Up Arrow (or End, Up Arrow) until you move to the top of your column.

You can also use the other arrows keys to move around the worksheet.

Ctrl + Right Arrow (or End, Right Arrow)  will move you to the last cell that is populated in the current row or, if no more cells are populated after your currently selected cell,  it will move you to the last cell in the row completely.

Ctrl + Left Arrow (or End, Left Arrow) will move you to the first cell that is populated in the current row, or if all the cells are populated before you current position, it will move you to column 1 in the current row.

Ctrl + Down Arrow (or End, Down Arrow) will move you to the last cell that is populated in the current column beloe your current position, or if all the cells are populated above your current position, it will move you down the last cell in the worksheet.

Ctrl+Up Arrow (or End, Up Arrow) will move you up to the last cell that is populated in the current column if you are below it, or if all the cells above your current position are populated, it will move you up to Row 1.

NOTE: You must not hold the END key down as you do the Ctrl key – you press first the End key, and then the Arrow key).

Moving between Formulas with Direct Precedents

You can use Ctrl+] or Ctrl+[ to move between formulas that are linked to each other.

For example:

Say you have a worksheet that has a sum formula such as the example below.

 

goto select sum

 

Click on the cell that contains the formula and then press Ctrl+[ on the keyboard.

goto selected precedent

All the cells that are referenced in the formula will be selected.

 

If the formula just refers to one cell, Ctrl + [ will move to the specific cell referenced in the formula.

1. Click on the cell that contains the formula

2. Press Ctrl+[ to move to the cell referenced in the formula.

goto selected cell

 

Press Ctrl+] on the keyboard to move to the cell which has a formula which refers to your selected cell.

 

goto table select dependent

Moving Around a Workbook with Hyperlinks

You can create hyperlinks within a workbook to move around the workbook.

Click in the cell where you wish the hyperlink to go.

goto create hyperlink 1

Press Ctrl+K on the keyboard and select the reference for the hyperlink within the workbook.  Click OK.

goto create hyperlink 2

 

The hyperlink will be created.

goto create hyperlink 3

 

Click on the hyperlink to go to the selected reference.

Move to a Row in Google Sheets

Google Sheets doesn’t have the Go To functionality, but you can use the name box to Move to a cell or row. It works exactly the same way as in Excel.  You can also use the Control, Home, End  and Arrow keys to move around your worksheet.