How do I go about finding and removing labels in formulas?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. Since labels in formulas are no longer supported in 2007, how do I go
about finding and removing them? Also, as I understand it, Named Ranges are
supported in 2007 so they are ok to leave in. Is this correct?
 
Chuck M said:
Hi. Since labels in formulas are no longer supported in 2007, how do I go
about finding and removing them? Also, as I understand it, Named Ranges
are supported in 2007 so they are ok to leave in. Is this correct?
Click to expand...

Defined name functionality hasn't changed. Labels were never defined names.

Excel 2007 automatically converts labels in formulas to their corresponding
ranges when opening .XLS files. You shouldn't need to convert labels
yourself.
 
Back
Top