Excel Shortcut to Go to a Cell: F5, Ctrl+G, and More

In Excel for Microsoft 365 on Windows, press F5 or Ctrl+G to open the Go To dialog, type a cell reference such as D250, and press Enter to jump there. You can also click the Name Box to the left of the formula bar, type the reference, and press Enter.

These options are useful when a worksheet is too large to reach a cell by scrolling. Go To can take you to a cell, range, or named location, while other shortcuts help you move through a sheet by its data, its used area, or its tabs.

Use F5 or Ctrl+G to jump directly

For a specific destination, the Go To dialog is often the quickest choice. Press either shortcut, enter the reference in the Reference box, and confirm. Excel makes the destination active and scrolls it into view. For example, entering H1200 takes you to column H, row 1200, without requiring a long series of scrolls.

Press F5 or Ctrl+G.
Type a cell reference, such as B6 or H1200, in the Reference box.
Press Enter or select OK.

The dialog may show a list of previously used references. Selecting one and confirming returns to that location. This is handy when you are moving back and forth between a few distant parts of a workbook. If you only need to go somewhere once, just type the new address rather than searching the list.

Go To selects the destination; it does not edit its contents. To change a value after jumping, start typing or press F2 to edit the active cell. Press Esc if you opened the dialog by mistake and want to close it without moving.

What a cell reference means

A standard cell reference combines a column letter and a row number. A1 is at the intersection of column A and row 1; XFD1048576 is the last cell in a modern Excel worksheet. You do not need to include dollar signs when navigating to a cell. References such as $B$6 are also accepted, but the dollar signs matter primarily when copying formulas, not when deciding where to go.

You can enter a range as well as one cell. For example, typing B2:D12 selects that rectangular block. Excel makes the first cell of the selected range, B2 in this example, the active cell; the rest of the range remains selected. You can then apply formatting or copy the selection. References such as C:C select a whole column, and 5:5 selects a whole row.

To specify a sheet, include its name and an exclamation mark. For example, enter Summary!B7 to go to B7 on a sheet named Summary. If the sheet name contains spaces, enclose it in apostrophes: ‘Quarter 2’!D8. The sheet must be in the current workbook for this ordinary reference to work. This notation is the same kind of sheet-qualified reference used in formulas.

Use the Name Box as another route

The Name Box sits at the left end of the formula bar and normally displays the address of the active cell, such as A1. Click inside it, replace the displayed address with a destination, and press Enter. This takes you to the reference without opening a dialog, so it can be convenient when the mouse is already in use.

The Name Box also works with ranges and defined names. If a workbook has a defined name such as Sales_Total, typing that name into the box and pressing Enter selects the location or range associated with it. Defined names are useful for areas whose purpose is clearer than an address, but they must already exist in the workbook. If Excel does not recognize a name, check its spelling and whether it is defined for the workbook or the current sheet.

Choose between the Name Box and Go To based on the task. The Name Box is always visible near the formula bar and is a straightforward place to enter one destination. Go To is useful when you prefer a keyboard-only workflow, want to reuse a recent destination, or need its Special options for selecting particular kinds of cells.

Other shortcuts for moving around a worksheet

Typing a full address is not always necessary. Excel has navigation shortcuts for moving to the edge of a data region or to the boundaries of the sheet. They are especially useful when you do not know the exact row number but can identify the data around you.

Ctrl+Home moves to the beginning of the worksheet, normally A1.
Ctrl+End moves to the last cell Excel considers used in the worksheet. That may be beyond the last cell containing visible data if formatting or previous edits extended the used area.
Ctrl+Arrow key moves to the edge of a data region in that direction. For example, from inside a continuous block of entries, Ctrl+Down moves to its lower edge.
Ctrl+Shift+Arrow key extends the selection as it moves, which is useful for selecting a continuous block.
Ctrl+Page Up and Ctrl+Page Down switch to the previous and next worksheet tab.

These shortcuts answer related but different needs. Ctrl+G is best when you know the destination address. Ctrl+Arrow is better when you want to explore a connected block of data. Ctrl+End is not a reliable way to find the last meaningful record in every workbook because formatting, deleted content, or edits can affect Excel’s used-cell boundary. If you need a particular record, use a known reference, a filter, or the Name Box instead.

Go To Special selects cells by type

The Go To dialog has a Special button that opens Go To Special. This is not just another way to jump to one address: it selects cells that meet a condition within the relevant worksheet area or current selection. To open it, press F5 or Ctrl+G, choose Special, select an option, and confirm.

Common uses include selecting all blank cells in a selected range, finding cells that contain formulas, or selecting visible cells only after filtering or hiding rows. For instance, selecting a table range first and then using Go To Special > Blanks limits the search for blanks to that selection. Without a carefully chosen selection, Excel may consider a much larger area than intended, so check what is selected before applying an action to the results.

Go To Special can also select constants, formulas, the current region, and the last cell, among other categories. The exact options can be useful for workbook cleanup, but selecting cells is not the same as fixing them. If you select blanks and type a value, pressing Ctrl+Enter fills all selected blank cells with that value; pressing Enter alone typically enters it in the active cell. Be deliberate before entering or deleting content across a multi-cell selection.

Windows, Mac, and Excel for the web

This guide uses Excel for Microsoft 365 on Windows. On a Mac, Control+G opens Go To, and F5 is also a Go To shortcut in Excel. Depending on the keyboard and macOS settings, you may need to press Fn+F5 to send the F5 key rather than a system function. The Name Box is also available in Mac Excel and offers a useful alternative if a function-key shortcut behaves differently.

In Excel for the web, the Name Box is a dependable way to enter a cell address directly. Keyboard behavior can vary with the browser and keyboard setup, so if F5 reloads the browser page instead of opening a Go To control, do not use it there; use the Name Box or the web app’s available Go To command. Browser shortcuts can take precedence over spreadsheet shortcuts, especially for function keys.

Some laptops require an Fn key for F5 even in desktop Excel. If F5 does not open Go To, try Ctrl+G or check whether the keyboard’s function-key mode is set to media controls. This is a keyboard-setting issue, not a different cell-reference format.

Common problems and quick fixes

If Excel does not go where expected, first confirm that the reference is valid and that you entered it in the right place. A mistyped column letter, row number, sheet name, or punctuation mark can prevent Excel from recognizing the destination. For sheet names with spaces, use apostrophes around the sheet name, as in ‘Quarter 2’!D8.

The shortcut does something else: Try the other shortcut, F5 or Ctrl+G. On a laptop, try Fn+F5; in a browser, avoid F5 if it refreshes the page.
The cell is selected but not obvious: Look at the Name Box to confirm the active address. If the sheet is zoomed out or the grid is large, the selection border can be easy to miss.
The destination is on another sheet: Include the sheet name and exclamation mark, such as Data!A200, or use the Name Box after switching tabs.
Ctrl+End goes too far: It points to Excel’s last used cell, which can include cells affected by old formatting. It does not necessarily identify the last row of your real dataset.

A common misconception is that Ctrl+F is the shortcut for going to a known cell. Ctrl+F opens Find, which searches for text or values; it is useful when you know what a cell contains but not where it is. For an address such as J450, use F5, Ctrl+G, or the Name Box instead.

Frequently Asked Questions

What is the shortcut to go to a cell in Excel?
In Excel for Windows, press F5 or Ctrl+G, enter the cell reference, and press Enter. You can also enter the reference in the Name Box.

How do I jump to a specific cell, such as A100?
Press F5 or Ctrl+G, type A100 in the Reference box, and press Enter. Alternatively, click the Name Box, type A100, and press Enter.

How do I go to a cell on another sheet?
In Go To, enter the sheet name, an exclamation mark, and the address, such as Summary!B7. Put apostrophes around a sheet name that contains spaces: ‘Quarter 2’!D8.

Can I select a range with Go To?
Yes. Enter a range such as B2:D12 to select it. The first cell in the range is the active cell, while the full range remains selected.

Why does Ctrl+End not go to my last row of data?
Ctrl+End moves to the last cell Excel treats as used, which may include cells with formatting or past edits. Use a known address or the Name Box when you need a specific destination.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.