| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When selecting cells in Excel 07 why doesn't it highlight? | Excel Discussion (Misc queries) | |||
| Selecting cells lock up Excel application | Excel Discussion (Misc queries) | |||
| How do I get Excel 2004 Mac to insert cells vis keyboard shortcuts | Excel Discussion (Misc queries) | |||
| applying borders to cells using keyboard shortcuts in excel | Excel Discussion (Misc queries) | |||
| The cursor on my Excel spreadsheet is not selecting cells. | Excel Discussion (Misc queries) | |||
Hybrid Mode
