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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named range labels in formulas 1
Removing labels and names in formulas 3
What does Insert>Name>Label & Insert>Name>Paste do? 2
Excel 2007 conversion - this file contains labels in formulas 6
How do I use a worksheet label to create a formula in Excel 2007? 2
labels in formulas 1
Data Labels Disappearing 0
How do I print mailing labels from an Excel file? 5

Back
Top