Microsoft Office Tutorials and References
In Depth Information
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.