vert line

You can use the Range -> Labels menu options to set up named ranges quickly.

Insert Label Index displays a list of all labels and their range addresses in a column on the worksheet, starting in the current cell. This is useful if you frequently refer to the ranges that you have labeled.

Label Range To: Right, Left, Top, Bottom. These four commands let you specify the direction of your label range, depending on the label you specify before invoking one of the commands.

If you enter a name in a cell, you can assign it as a range label to any adjacent cell by using the Range Labels menu. For example, if you enter Sales into a cell and select Range/Labels/Label Range to Right the label Sales will now refer to the adjacent cell on the right. You can also choose Left, Top, or Bottom.

Delete All Labels removes all the labels from the worksheet.

See also

 

Also go to:

Index help

Contents help