Shortcuts for Go To Special

Excel provides a dedicated dialog box to access special groups of cells, called “Go To Special”.

There you’ll find a large list of options.

So, let’s go through these options.

In cases where there is a dedicated shortcut, I’ll use that.

Otherwise, I’ll use the Go To Special dialog.

you’ve got the option to form example select all formulas that return a text result.

it’s possible for you to deselect with escape.

There are two dedicated shortcuts for selecting differences in rows and columns.