Go To Special Shortcuts in Excel

The quickest way to open Excel’s Go To Special dialog is the keyboard shortcut Ctrl+G (or F5) followed by Alt+S. This opens the dialog where you can select special cells like blanks, formulas, or constants; you can also use the direct shortcut Ctrl+Shift+Space to select the current region around a cell.

What Is Go To Special?

Go To Special is a feature in Microsoft Excel that lets you select cells that meet specific criteria, such as blank cells, cells with formulas, cells with comments, or cells that are different from the active cell. Instead of manually scanning a large spreadsheet, you can use this tool to jump directly to the cells you need. It is especially useful for data cleaning, auditing, and formatting tasks.

How to Open Go To Special

There are several ways to open the Go To Special dialog:

Keyboard shortcut: Press Ctrl+G (or F5) to open the Go To dialog, then press Alt+S to select the Special button. This is the fastest method.
Ribbon: Go to the Home tab, click Find & Select in the Editing group, and choose Go To Special….
Direct shortcut: Press Ctrl+Shift+Space to select the current region (the contiguous block of data around the active cell). This is not the same as Go To Special but is often used for similar selection purposes.

Using Go To Special

Once the dialog is open, you can choose from a variety of options. The most commonly used ones include:

Blanks: Selects all empty cells in the selected range. This is handy for filling in missing data or deleting empty rows.
Constants: Selects cells that contain constant values (not formulas). You can further restrict by checking the boxes for numbers, text, logical values, or errors.
Formulas: Selects cells that contain formulas. You can choose to include numbers, text, logical values, or errors.
Comments: Selects cells that have comments attached.
Conditional formats: Selects cells that have conditional formatting applied.
Data validation: Selects cells that have data validation rules.
Last cell: Jumps to the last used cell on the worksheet (the intersection of the last row and column that contains data or formatting).

Shortcut Combinations for Specific Tasks

While the basic shortcut opens the dialog, you can combine it with other keys to quickly select specific types of cells without navigating the dialog each time. For example:

To select blank cells: Ctrl+G, Alt+S, K, Enter (K selects Blanks, Enter confirms).
To select cells with formulas: Ctrl+G, Alt+S, F, Enter.
To select constants: Ctrl+G, Alt+S, C, Enter.
To select the current region: Ctrl+Shift+Space (press twice to select the entire worksheet).

These sequences work in most versions of Excel for Windows. On a Mac, the shortcuts are slightly different: use Control+G or F5 to open Go To, then Control+S to open Special.

Common Use Cases and Examples

Go To Special is invaluable in real-world scenarios. Here are a few examples:

Filling blank cells: If you have a column with gaps, select the range, use Go To Special > Blanks, type a value (like 0 or a formula), and press Ctrl+Enter to fill all selected blanks at once.
Deleting blank rows: Select a column, choose Go To Special > Blanks, then right-click and delete entire rows.
Selecting formulas that return errors: Use Go To Special > Formulas, uncheck everything except Errors, and then review or fix them.
Copying only visible cells: If you have filtered data, use Go To Special > Visible cells only (or press Alt+;) to copy only what you see, not the hidden rows.

Limitations and Troubleshooting

Go To Special works on the current selection. If you don’t select a range first, it applies to the entire worksheet. However, there are a few limitations:

It does not work on multiple non-contiguous selections in older versions of Excel.
If you have a merged cell, the blank option may not select the hidden parts.
If you use Ctrl+Shift+Space and nothing happens, make sure the active cell is within a data range; otherwise it selects the entire sheet.

If the shortcut doesn’t work, check if your keyboard is set to a different language or if you have a laptop with a function (Fn) key that alters F5. Also, some add-ins may override shortcuts.

Frequently Asked Questions

What is the shortcut for Go To Special in Excel?

The most direct shortcut is Ctrl+G (or F5) to open the Go To dialog, then press Alt+S to open Go To Special. There is no single-key shortcut that directly opens Go To Special, but this two-step combination is fast.

How do I select blank cells in Excel quickly?

Select the range where you want to find blanks, press Ctrl+G, then Alt+S, then K (for Blanks), and press Enter. All blank cells in the range will be selected.

Why is Go To Special not working?

Ensure you have selected a range or a cell. If you have multiple sheets selected, Go To Special may be disabled. Also, check if your Excel version supports it (it does in all modern versions). If the shortcut doesn’t respond, try using the Ribbon method via Home > Find & Select.

Can I use Go To Special to select cells with conditional formatting?

Yes. In the Go To Special dialog, choose “Conditional formats” and then select either “Same” (to match the active cell’s formatting) or “All” (to select all cells with conditional formatting).

How do I select only visible cells in Excel?

Use the shortcut Alt+; (semicolon) to select only visible cells in the current selection. This is equivalent to Go To Special > Visible cells only.

Does Go To Special work in Google Sheets?

No, Go To Special is a Microsoft Excel feature. Google Sheets has a similar feature called “Find and replace” but it does not have the same selection options. In Google Sheets, you can use the “Filter” function or the “Select all” with filters to achieve similar results.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →