In this tutorial, you will learn how to go to a specific cell, column or row using keyboard shortcuts.
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).
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.
As a result, you moved from cell A1 to cell C3, which is now selected.
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.
You will have moved from cell A1 to Row 3, which is now entirely selected.
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.
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.
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.
Your range name or table will be 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.
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.
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.
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.
Say you have a worksheet that has a sum formula such as the example below.
Click on the cell that contains the formula and then press Ctrl+[ on the keyboard.
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.
Press Ctrl+] on the keyboard to move to the cell which has a formula which refers to your selected cell.
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.
Press Ctrl+K on the keyboard and select the reference for the hyperlink within the workbook. Click OK.
The hyperlink will be created.
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.