Microsoft Office Tutorials and References
In Depth Information
Shortcuts for Creating Cell and Range Names
Figure 3-6: Using the Create Names from Selection dialog box to create names from the data in this table
may produce unexpected results.
Naming entire rows and columns
Sometimes it makes sense to name an entire row or column. Often, a worksheet is used to store
information that you enter over a period of time. The sheet in Figure 3-7 is an example of such a
worksheet. If you create a name for the data in column B, you need to modify the name’s
reference each day you add new data. The solution is to name the entire column.
Figure 3-7: This worksheet, which tracks daily sales, uses a named range that consists of an entire column.
For example, you might name column B as DailySales. If this range were on Sheet2, its reference
would appear like this:
To define a name for an entire column, select the column by clicking the column letter. Then, type
the name in the Name box and press Enter (or use the New Name dialog box to create the name).