Reserved Names

Excel uses local names of its own to keep track of information. These local names are considered reserved and, if you use them for your own references, may cause problems.

Highlight an area on a sheet and select, from the Excel menu, File, Print Area, Set Print Area.

As shown in Figure 7.7, a Print_Area listing is in the range name field. Deselect the area and look again in the range name field. The name is still there; select it and the print area previously set is now highlighted. If you save, close, and re-open the workbook, Print_Area is still set to the same range. Print_Area is a name reserved by Excel for its own use.

Figure 7.7

Excel creates its own names.

Ï]

h Edit ¡few Insert Format Tools

X:',) Wfidow yelp

0 0

Post a comment