Handling the Data Range
After you've returned data to an external data range in an Excel worksheet, the range has some additional properties that you might want to work with.
NOTE
Microsoft Office applications use the term properties to refer to aspects of objects. As just one of many, many examples, a range of cells has a Borders property that specifies which borders (top, bottom, left, right, diagonal, or none) that the range has. Until you become familiar with the notion of properties you may find it helpful to think of a property as an option.
Right-click any cell in an external data range, and choose Data Range Properties from the shortcut menu. The dialog box shown in Figure 5.22 appears.
Figure 5.22. If you don't see Data Range Properties ...
Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
