Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert | Name | Label
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert | Name | Label
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: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert | Name | Label
In Excel HELP, search for "About labels and names in formulas" for further information. Note: By default, Excel does not recognize labels in formulas. To use labels in formulas, click Options on the Tools menu, and then click the Calculation tab. Under Workbook options, select the Accept labels in formulas check box. Labels are similar to Names, but different. Labels can only be used on the sheet in which they appear, names can be on any sheet in the workbook. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=555663 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
To add a label name on several sheets | Excel Worksheet Functions | |||
Identify Label €” More than one cell with label | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |