| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#N/A In Cells
On 8/5/2014 at 2:31:52 PM Claus Busch wrote:
Hi, Am Tue, 5 Aug 2014 18:45:39 +0000 (UTC) schrieb tb: 1) Start = Find & Select = Go to Special = Formulas = Errors 2) Press Shift+Down Arrow in found dialog (?) 3) Close dialog 4) Tab through the highlighted cells I don't get a found dialog anywhere when following the above-mentioned instructions, so I am stuck at step 2. try Start = Find & Select = Find = What: #N/A = Options = Look At: Values But you can also edit your formulas with my first suggestion. You only have to press F2 to edit. Regards Claus B. Thanks Claus and Gord. -- tb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells | Excel Programming | |||
Hybrid Mode
