[ramadevi]

Sir/mam,
Would u explain the label & apply suboptions in name option in insert menu in msexcel.

[ScottGem]

From Excel Help:

Specifying labels When you select cells in labeled ranges to create formulas, Microsoft Excel can insert the labels in place of the cell references in your formulas. Using labels can make it easier to see how a formula is constructed. You can use the Label Ranges dialog box (Insert menu, Name submenu, Label command) to specify the ranges that contain column and row labels on your worksheet.
----------------------------------
If you define names for cell references after creating one or more formulas that use those cell references, you can update those cell references to names.

1. Do one of the following:
   • To update only certain formulas on a worksheet, select the cells that contain those formulas.
   • To update all the formulas on the worksheet, select a blank cell.
2. On the
   1. Do one of the following:
      • To update only certain formulas on a worksheet, select the cells that contain those formulas.
      • To update all the formulas on the worksheet, select a blank cell.
   2. On the Insert menu, point to Name, and then click Apply.
   3. In the Apply names box, click one or more names.
   menu, point to [bbcode][/bbcode], and then click Apply.
3. In the Apply names box, click one or more names.

[ramadevi]

Sir

Would you the label&apply suboptions in name option in insert menu in msexcel with an example as I have not got clear with your answer.

[ScottGem]

Label allows you to use the label in an adjacent cell to name the cell. For example, If you have the text Firstname in Cell A1 You can use it to name the Cell B1 so you can refer to B1 as Firstname.

Apply, replaces cell references in formulas with their names. For example: If you have put the formula:

B1 + " " + B2

In Cell B3 to display the full name, then named B1 and B2 Firstname and Lastname, when you use Apply, the formula in B3 changes to:

Firstname + " " + Lastname