• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Working with Ranges > Creating Range Names from Worksheet Labels

Creating Range Names from Worksheet Labels

You can also create range names using the column and row labels that you have created for your worksheet. The row labels are used to create a range name for each row of cells, and the column labels are used to create a range name for each column of cells. Follow these steps:

  1. Select the worksheet, including the column and row labels.

  2. Select the Insert menu, point at Name, and then select Create. The Create Names dialog box appears (see Figure 11.3).

  3. Click in the check boxes that define the position of the row and column labels in the worksheet.

    Figure 11.3. Use the Create Names dialog box to create range names for the cells in the worksheet.

  4. After specifying the location of the row and column labels, click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint