Excel Shortcuts - Selecting all cells with the same content

G

G-man

What is the short cut to select all cells that have the same value.

For instance in a specific row select all cells that have a value of N/A#

Thanks
 
M

Mike H

The built in Goto's can be accessed by tapping F5 and clicking Special.
Selecting errors should do what you want.

Mike
 
G

Gord Dibben

If those would be the only errors then select the row and F5>Special>Formulas.
Uncheck all but errors and OK.

To find the specific error #N/A you can use Edit>Find

What: #N/A

Checkmark "Values" in "Look in" dialog.


Gord Dibben MS Excel MVP
 
Top