Ctrl+G in Excel: Open Go To and Select Cells

How-to basics · Updated November 22, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+G to open the Go To dialog, type a cell reference or named range, and press Enter to jump to it. The dialog’s Special button can also select cells that meet conditions, such as blanks, formulas, or visible cells only.

What Ctrl+G Does in Excel

Ctrl+G is a navigation shortcut. It opens Go To, a dialog for moving the active cell to a specified location in the current workbook. You can enter a single cell, a range, or a defined name. Excel then moves the selection to that destination; it does not change the cell contents or apply formatting.

For example, entering D250 takes you to cell D250. Entering B3:F18 selects that rectangular range, with B3 as its active cell. This can be much quicker than scrolling through a long worksheet, especially when you already know the address you need. It is also useful when a workbook contains many worksheets or a large area of data.

Go To is not the same as Find. Find searches cell contents for text, numbers, or formulas; Go To navigates to an address or selects cells based on a structural condition. Ctrl+G can therefore help you reach a known place quickly, but it will not locate every cell containing a particular word.

How to Open and Use the Go To Dialog

On Windows, press Ctrl+G or F5 while Excel is active. Either shortcut opens the Go To dialog. The dialog contains a Reference box, a list of previously used destinations, and a Special button. To navigate, click the Reference box if necessary, enter the destination, and press Enter or click OK.

  1. Click a worksheet cell, so Excel has focus.
  2. Press Ctrl+G. If that shortcut is unavailable on your keyboard or is intercepted by another tool, try F5.
  3. Type the target, such as H420, or a range, such as A2:C40.
  4. Press Enter. Excel selects the destination and closes the dialog.

The Go To dialog remembers recent references during the session, which can make it convenient to move back and forth between a few areas. Choose one of the listed references and confirm to return there. This is a temporary navigation history, not a permanent bookmark system; for destinations you need repeatedly, a defined name or a hyperlink may be more appropriate.

You can also use the Name Box, the small field to the left of the formula bar that normally displays the active cell address. Type a cell reference or defined name there and press Enter. The Name Box is handy when you want to navigate without opening a dialog, while Ctrl+G is especially useful when you want Go To Special or prefer a keyboard-based workflow.

Cell References, Ranges, and Named Destinations

A reference can point to a single cell or a group of cells. For instance, C12 selects one cell, while C12:G28 selects a rectangular range. A reference can also specify a worksheet, as in Budget!B7. If the sheet name contains spaces or punctuation, enclose it in apostrophes, as in ‘Quarter 1’!B7. This is standard Excel worksheet-reference syntax.

Go To can navigate to a defined name as well. A name such as Sales_Total may refer to one cell or a range, depending on how it was created. Entering that name in the Reference box takes you to its destination. Names can be workbook-wide or limited to a particular worksheet, so if Excel does not recognize a name, check its spelling and scope in Formulas > Name Manager.

Absolute references with dollar signs, such as $C$12, still identify the same cell when entered in Go To. The dollar signs matter when formulas are copied, but they do not change the destination of a direct navigation. You can also select nonadjacent areas with a union reference in Excel, but entering each address individually through Go To is often clearer when you are unsure how a complex reference will be interpreted.

A reference must point to a valid location in the workbook. If you type a misspelled sheet name or an invalid address, Excel may display an error instead of navigating. When working in a different workbook than expected, confirm that the correct workbook and worksheet are active before using the shortcut.

Using Go To Special

Go To Special turns the dialog into a selection tool. Open Go To with Ctrl+G, click Special, choose a category, adjust any available options, and confirm. Excel selects cells that fit the chosen condition within the relevant worksheet or selected area. The exact scope depends on what was selected before opening the command, so first select a range if you want to limit the search to that range rather than the broader sheet.

Useful Go To Special choices include:

  • Blanks: selects blank cells in the applicable area, useful for finding gaps in a table or filling repeated values into empty cells.
  • Formulas: selects cells containing formulas. Options can narrow the selection to formulas returning particular types of values, such as numbers or text.
  • Constants: selects cells with entered values rather than formulas. Options can help target constants of particular types.
  • Visible cells only: excludes hidden rows and columns from the selection. This matters when copying from a filtered list because a normal selection can include hidden cells.
  • Current region: selects a connected block of data around the active cell, often bounded by blank rows or columns.
  • Last cell: moves the selection to the worksheet’s last cell that Excel considers used. This can reveal that formatting or old content extends farther than expected.

Other choices include cells with conditional formatting or data validation, objects, and cells with relationships to the active cell, such as precedents or dependents. These options can be useful for auditing a complicated sheet. For example, selecting formulas can help distinguish calculated results from values someone typed manually, while selecting data-validation cells can help locate areas where entry rules are applied.

Go To Special is not a filter and does not delete or repair anything by itself. It selects matching cells so you can inspect them or perform a later action. Before typing, clearing, or formatting after a large selection, check the highlighted area carefully. A command applied to a multi-cell selection can affect every selected cell.

Practical Examples

Suppose a worksheet has monthly figures in columns A through F and thousands of rows. If a report says the issue is in row 1842, press Ctrl+G, enter A1842, and press Enter. To inspect the whole row of relevant data, enter A1842:F1842 instead. This gets you to the record without repeatedly scrolling or dragging the vertical scrollbar.

For a small audit, select a particular data range first, then use Ctrl+G > Special > Blanks. Excel highlights the empty cells in that range. You can inspect the pattern before filling anything; blanks may represent missing data, but they can also be intentional. If you are copying filtered records, use Go To Special > Visible cells only before copying so hidden rows are excluded from the copied selection.

Another example is checking whether a worksheet contains unexpected formulas. Select the relevant table, open Go To Special, and choose Formulas. The resulting selection shows which cells calculate their values. Compare it with the intended layout before making edits. This can be more reliable than scanning the formula bar cell by cell, especially where the sheet mixes hard-coded assumptions and calculated results.

For a workbook with a named input area, enter its defined name in Go To instead of remembering the cell address. If the input section moves later, the name can continue to point to the intended location after it is updated. This is one reason named ranges are useful in larger workbooks: they make navigation and formulas easier to understand than a long list of unexplained coordinates.

Ctrl+G Compared with Find, the Name Box, and F5

Ctrl+G and F5 open the same Go To dialog in desktop Excel for Windows. They are alternative shortcuts, not separate commands. Use whichever is easier on your keyboard. On many keyboards F5 is also assigned to media or system functions, so you may need the Fn key depending on the device settings; Ctrl+G avoids that complication.

Ctrl+F opens Find, which searches worksheet content. Use it to look for a customer name, a label, or a number that you do not know the address of. Ctrl+H opens Replace, for finding content and optionally replacing it. Neither is a substitute for Go To when you already know a cell reference or want to select blanks, formulas, or visible cells.

The Name Box is a quick alternative for jumping directly to an address or named range, but it does not provide the Go To Special categories. The Navigation pane and worksheet tabs can help locate sheets or content in some workbooks, but they serve different purposes. A useful rule is: use Go To for known addresses and structural cell selections, Find for unknown content, and the Name Box for a fast direct jump.

Windows, Mac, and Excel for the Web

This guide focuses on Excel for Microsoft 365 on Windows. In desktop Excel for Mac, Control+G opens Go To; use the Control key, not Command, for this shortcut. The F5 key may behave differently depending on Mac keyboard settings, so Control+G is often the more dependable option. Ribbon labels or dialog details can vary slightly between Windows and Mac releases, but the underlying Go To and Go To Special concepts are similar.

Excel for the web runs inside a browser, where keyboard combinations can be affected by the browser or operating system. If Ctrl+G does not open the Excel command, use the Name Box to go directly to a cell or range, or use Excel’s ribbon search to locate the relevant navigation command. The desktop application generally offers the fullest keyboard and Go To Special workflow, so open the workbook in desktop Excel if a needed option is unavailable in the browser.

On any platform, check that the worksheet is active before pressing the shortcut. A selected object, an open editing field, or another application window can change what a key combination does. If you are typing inside a cell rather than navigating the worksheet, press Enter or Esc to leave cell-editing mode and try again.

Common Problems and How to Fix Them

If Ctrl+G appears to do nothing, first check that Excel has focus and that you are not editing a cell or typing in a dialog. Press Esc once to close an active edit or menu, click a worksheet cell, and try again. On a laptop, test F5 or use the Name Box as a workaround. Keyboard remapping utilities and remote desktop software can also intercept shortcuts.

If Excel reports that a reference is invalid, verify the sheet name, punctuation, and cell address. A worksheet name containing spaces needs apostrophes around it in a qualified reference. Also make sure you have not included explanatory text or an extra space in the Reference box. For a named range, check Formulas > Name Manager to confirm the name exists and refers to a valid cell or range.

If Go To Special selects more cells than expected, consider the selection that existed before you opened it. Some special selections operate on the current selection, while others may apply to a broader worksheet area. Cancel without making changes, select the intended range explicitly, and repeat the selection. Finally, remember that hidden cells are not necessarily blank, and a cell that looks empty may contain a formula returning an empty string. Go To Special’s Blanks option targets genuinely empty cells, not every cell that merely appears blank.

Frequently Asked Questions

What does Ctrl+G do in Excel?
It opens the Go To dialog, where you can enter a cell reference, range, or defined name. The dialog also provides Go To Special for selecting cells that meet conditions such as blanks or formulas.

Is Ctrl+G the same as F5 in Excel?
In desktop Excel for Windows, both shortcuts open the Go To dialog. F5 can require the Fn key on some keyboards, while Ctrl+G is usually a direct shortcut.

How do I select all blank cells in a range?
Select the range first, press Ctrl+G, choose Special, select Blanks, and confirm. Excel highlights genuinely empty cells in the applicable selection; inspect the result before entering or deleting data.

Why does Ctrl+G not work in Excel for the web?
A browser or operating system may intercept the combination, or Excel may not have focus. Try the Name Box for a direct jump, or use the desktop app for the full Go To Special workflow.

Does Ctrl+G search for text in a worksheet?
No. Use Ctrl+F to find text or values when you do not know their cell addresses. Ctrl+G navigates to known references and can select cells by special criteria.

Related

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.