Thread: Excel Shortcuts - Selecting all cells with the same content
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote