#N/A In Cells
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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|