Excel Shortcuts - Selecting all cells with the same content
 

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

Excel Shortcuts - Selecting all cells with the same content
 

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

Mike

"G-man" wrote:

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

Excel Shortcuts - Selecting all cells with the same content
 

If those would be the only errors then select the row and F5SpecialFormulas.
Uncheck all but errors and OK.

To find the specific error #N/A you can use EditFind

What: #N/A

Checkmark "Values" in "Look in" dialog.


Gord Dibben MS Excel MVP

On Thu, 10 Jan 2008 09:05:00 -0800, G-man
wrote:

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