To select all cells in a worksheet that use conditional formatting, use Control + G, Alt S + Tįinally, you can select all cells that use data validation with Control + G, Alt S + V On a Mac, this shortcut is command + shift + Z When you have hidden rows or columns, use Alt + to select visible cells only. To select cells that are different from values in a first row, use control + shift + | To select cells that are different from values in a first column, use control +

There are two dedicated shortcuts for selecting differences in rows and columns. This will select all objects that float above the grid. To select all objects on a worksheet, use Control + G, Alt S + B If you're working with a multi-cell array formula, you can select other formulas in the array with Control + /. To select all cells in the current region, use Control + A, or Command + A on a Mac. Keep in mind that you can often restrict the scope of select special commands, by selecting a smaller group of cells first. This will select all blank cells inside the work area of the current sheet. You can select all precedents to a formula using Control + Shift + When working with formulas, you can select direct precedents of a formula using Ctrl+ [ You can form example select all formulas that return a text result.

With both formulas and constants, there are options you can enable or disable by typing a letter. To select all formulas, use Control + G, Alt S + F To select only cells that contain constants, use Control + G, Alt S + O To select all cells that contain comments, use the dedicated shortcut Control + Shift + O Otherwise, I'll use the Go To Special dialog. In cases where there is a dedicated shortcut, I'll use that. There you'll find a large list of options.Īs with the Paste Special dialog, on Windows you can use the underlined letters to select different options.

To access this dialog with the keyboard, type Control + G, then click the Special button (or use Alt + S) on Windows. In this video, we'll take a look at some shortcuts for selecting 'special cells'.Įxcel provides a dedicated dialog box to access special groups of cells, called 'Go To Special'.

Select all shortcut mac