finding all constants

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

Excel 2007
OS Vista Business

How can I find all the constants (numbers) only in a spreadsheet?
GOTO special only find constants including labels.

Will Fleenor
 
Goto Special lets you select the type of constant. The check boxes below
"Formulas" apply to "Constants" when it is selected.

--
Jim
| Excel 2007
| OS Vista Business
|
| How can I find all the constants (numbers) only in a spreadsheet?
| GOTO special only find constants including labels.
|
| Will Fleenor
 
Won't that find only numbers that are generate by formulas as opposed to
simple numerical entries (which is what I think the OP wants)?

Rick
 
Sorry, I misread your post... you did not say select "Formula"; rather, you
said to select Numbers **under** the Formula list **after** selecting
Constants.

Rick
 
Back
Top