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

Chapter 9. Entering Information > Naming Ranges of Cells

Naming Ranges of Cells

Assigning a name to a range of cells makes the range easier to refer to. For example, you could give the name "2000" to a column of numbers for the year 2000 and refer to it in a formula by that name: SUM(2000) instead of SUM(D3:D14). You can use the column head or row head as the name, or assign any name you like to a subset of a column or row, a group of cells that covers more than one column or row, or a nonadjacent group of cells.

To name a range of cells:

1.
Select the range of cells (Figure 9.12).

Figure 9.12. Select a range of cells.


2.
In the name box at the left end of the formula bar, type the name you want to use (Figure 9.13).

Figure 9.13. Type a name for the range in the na,e box.


3.
Press or .


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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