Excel Shortcuts - Selecting all cells with the same content

  • Thread starter Thread starter G-man
  • Start date Start date
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
 
The built in Goto's can be accessed by tapping F5 and clicking Special.
Selecting errors should do what you want.

Mike
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting all cells with content using a variable 3
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Shortcut keys for copying data down 29,000+ cells 2
shortcut-> deleting entire row (not just the data) 5
Keyboard shortcut to select a column? 7
VBA to select all cells with content 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
CSV->Excel Data Problem 1

Back
Top