Page 24 - Excel Data Analysis

02 537547 Ch01.qxd 3/4/03 11:45 AM Page 10

EXCEL DATA ANALYSIS

CREATE LABEL RANGES

ou can automatically have Excel use the column or rows contain the corresponding data values, you must
row labels as the range names for your worksheet. select both the labels and the data values. When you
Y This eliminates time required to manually create a activate this option, Excel creates a separate range name for
range for each column or row of data in your worksheet. each label within the range of selected cells.
Excel creates names based upon the labels in the top row, If you have labels in the top row and the left column, and
bottom row, left column, or right column within the range you select the top row option, Excel only creates range
of cells. For example, if your worksheet contains various names for the top row. If you want to create range names
office expenses for an entire year, you can create named for both the top row and left column, you must select both
ranges of monthly expenses. If the month names are in the options in the Create Names dialog box.
left column, Excel creates the range name from the left
column labels. Although Excel uses your worksheet labels to create the
range names, only the selected cells become a part of the
In the Create Names dialog box you must first select the corresponding range. For example, if column C contains
range of cells containing both the labels and the cells for telephone expenses, but you only selected a range of cells
the named ranges. For example, if your top row contains that contained rows 1 through 12, Excel does not create a
the column names for the worksheet, and the remaining
range for any values beyond row 12.

CREATE LABEL RANGES

⁄ Select the range of cells Note: See the section "Select a ¤ Click Insert ➪ Name ➪
containing labels. Range of Cells" for more information Create.
on selecting a range.

10