Excel Go To Special Shortcut: How to Select Cells Fast

In Excel for Microsoft 365 on Windows, press Ctrl+G or F5 to open Go To, choose Special, select a cell type, and click OK. You can also open it from Home > Find & Select > Go To Special; there is no single default keyboard shortcut that jumps directly to the Go To Special dialog.

What Go To Special Does

Go To Special selects cells on a worksheet that match a condition, rather than searching for a word or value. For example, it can select blank cells in a chosen range, every formula cell, only formula cells that return errors, or visible cells in a filtered list. After Excel makes the selection, you can inspect, format, copy, or edit those cells as a group.

This is useful when a sheet is large enough that scrolling and clicking individual cells would be slow or error-prone. It is also a selection tool, not an automatic cleanup command: choosing Blanks highlights the matching empty cells, but it does not fill or delete them. What happens next depends on the action you take.

The dialog is part of the desktop Excel application. Excel for the web does not offer the full Go To Special dialog in the same way, so open the workbook in desktop Excel when you need these selection options.

Open the Dialog on Windows and Mac

On Windows, either shortcut opens the regular Go To dialog. From there, click Special to see the selection criteria. The ribbon route is useful if you do not remember the shortcut, while the keyboard route is faster once it becomes familiar.

Optionally select the range where you want Excel to look.
Press Ctrl+G or F5.
In the Go To dialog, select Special.
Choose a category, set any available sub-options, and select OK.

In Excel for Mac, Control+G opens Go To; you can also use F5 on keyboards where the function key is available as an F-key. Depending on the Mac keyboard settings, you may need to hold Fn with F5. Then choose Special in the dialog. The ribbon layout and menu labels can differ slightly between platforms and versions, but the Go To dialog is the key step.

Control Which Cells Excel Searches

Selection scope matters. If you first highlight a range, Go To Special applies the chosen condition within that range. This is usually the safest approach for tasks such as finding missing entries in a table. If only one cell is active, Excel generally searches the worksheet for matching cells, which may produce a much larger selection than expected.

For example, to find missing entries in a small list, select only the list’s data cells, open Go To Special, and choose Blanks. Selecting the entire worksheet or an entire column can capture many empty cells beyond the records you meant to check. Before making a bulk change, look at the highlighted selection and confirm it covers only the intended area.

Some options have their own scope. Current region selects a contiguous block of data around the active cell, stopping at blank rows or columns. Current array selects an array-formula range when the active cell belongs to one. These are different from choosing a range manually, and the selection depends on how the sheet is laid out.

Important Selection Options and Examples

The Go To Special dialog includes several useful categories. The exact options available can depend on the workbook and Excel version, but common choices include:

Blanks: selects empty cells in the search scope. It is useful for spotting gaps or filling missing values, but it does not treat a formula that displays an empty string as a truly blank cell.
Constants: selects cells containing entered values rather than formulas. You can narrow the selection to numbers, text, logical values, or errors using the checkboxes.
Formulas: selects formula cells. Its checkboxes let you filter by the kind of result a formula returns, such as numbers, text, logical values, or errors.
Visible cells only: excludes rows or columns hidden by filters or manual hiding. This is especially useful before copying a filtered list.
Conditional formats and Data validation: select cells with those features, which can help you review where formatting rules or input restrictions have been applied.
Row differences and Column differences: compare cells with the active cell in the selected area and select entries that differ along the relevant direction.
Precedents and Dependents: trace cells that feed into a formula or are calculated from a selected cell, helping you inspect a workbook’s relationships.
Last cell and Objects: jump to the last cell Excel considers used on the sheet, or select objects such as shapes and charts.

Consider a worksheet with formulas in D2:D100 and a few formula errors. Select D2:D100, open Go To Special, choose Formulas, and leave only the Errors result type checked. Excel selects formulas in that range whose results are errors; it does not select every error-looking text value typed directly into a cell. For entered error constants, use Constants and its Errors checkbox instead.

Practical Uses for Blanks and Visible Cells

Finding blank cells is a common reason to use the command. Suppose a table has occasional missing department codes. Select just the code cells, choose Blanks, and review the highlighted positions. If it is appropriate to fill every selected blank with the same value, type the value once and press Ctrl+Enter on Windows. Excel enters it into all cells in the current selection. Check the scope carefully first: this action can overwrite the intended meaning of missing data if blanks are legitimate.

A blank cell and a formula returning an empty string are not the same thing. A cell containing a formula such as =IF(A2="","",A2) has a formula even when the displayed result looks empty. Go To Special’s Blanks option will not select that formula cell as an empty cell. Use Formulas if you want to select formula cells, or use a suitable filter or formula-based check when you need to identify cells by their displayed result.

Visible cells only solves a different problem. When you filter a table, hidden rows are still part of the worksheet. Copying a selected range can include hidden data depending on the selection and action. To copy only what is showing, select the range, open Go To Special, choose Visible cells only, and then copy. On Windows, the shortcut Alt+; selects visible cells only in a selection; the dialog route makes the same idea discoverable without memorizing another shortcut.

How It Compares with Find and Go To

Find looks for content, such as a word, number, or formula text. Go To takes you to a specified cell reference or named range. Go To Special selects cells based on properties such as being blank, containing a formula, or being visible. These tools are related because they are grouped around navigation and selection, but they solve different tasks.

For instance, to locate a cell containing the word Pending, use Find. To jump straight to cell G250, use Go To and enter G250. To select every blank cell in a selected input range, use Go To Special. Knowing the distinction prevents a common false start: entering a cell type or condition in the ordinary Go To box will not make it behave like the Special dialog.

Common Problems and Safe Work Habits

If Excel selects far more cells than expected, cancel the next action and check whether you selected a range first. A single active cell can leave the search scope broad. If a blank-finding task seems to miss cells that look empty, check whether those cells contain formulas, spaces, or other content. A cell with a space is not blank, and a formula displaying an empty result is still a formula.

Go To Special changes the selection, not the workbook’s values by itself. However, a subsequent command such as typing, deleting, formatting, or pasting can affect every selected cell. Before applying a bulk edit, verify the selection in the worksheet and consider saving a copy when working with important data. Be particularly cautious with merged cells, protected sheets, and array formulas: they can limit what Excel lets you select or change, and editing only part of a structured formula range may be disallowed.

If an option is unavailable or the result differs from what you expect, confirm that you are using desktop Excel and that the intended cells are in the active sheet and selected range. Some Go To Special choices depend on the active cell or on the presence of the relevant feature, such as data validation or conditional formatting. The command identifies matching cells; it does not explain why a rule or formula was applied, so inspect the selected cells and their settings afterward.

Frequently Asked Questions

What is the keyboard shortcut for Go To Special in Excel?
There is no single default shortcut that opens Go To Special directly in Excel for Windows. Press Ctrl+G or F5, choose Special, and then select the type of cells you want.

Can I select blank cells in Excel with a shortcut?
Yes. Select the relevant range, press Ctrl+G or F5, choose Special, select Blanks, and click OK. Selecting the range first helps prevent Excel from searching more of the worksheet than you intended.

How do I select visible cells only in Excel?
Select the range and choose Home > Find & Select > Go To Special > Visible cells only. On Windows, Alt+; is a keyboard shortcut for selecting visible cells in the current selection.

Why does Go To Special not select a cell that looks blank?
The cell may contain a space, another value that is hard to see, or a formula that displays an empty string. Go To Special’s Blanks option selects genuinely empty cells, not every cell whose displayed result appears empty.

Does Go To Special work in Excel for the web?
The full desktop Go To Special dialog is not available in Excel for the web in the same way. Open the workbook in the desktop app to use the complete set of Go To Special options.

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.