Insert | Name | Label

[Frederick Chow]

Hi all,

What is the use of the Inser | Name Label command? I have searched through
help but it is not really helpful. Thanks a lot.

Frederick Chow
Hong Kong

 

[Marcelo]

hi, you can use it as a reference on formulas eg.

you set the name JunProfit to the cell b10 where you have the June profit,
so you can use it on the formulas eg. =JunPrift/b1.

you also could set a name for a group of cells (range).

HTH
regards from Brazil
Marcelo


"Frederick Chow" escreveu:

 

[swatsp0p]

In Excel HELP, search for "About labels and names in formulas" fo
further information.

Note: By default, Excel does not recognize labels in formulas. To us
labels in formulas, click Options on the Tools menu, and then click th
Calculation tab. Under Workbook options, select the Accept labels i
formulas check box.

Labels are similar to Names, but different. Labels can only be used o
the sheet in which they appear, names can be on any sheet in th
workbook.

HTH

Bruc