Business Analysis with Microsoft® Excel, Second Edition

Working with External Data Ranges

When you have imported data into a worksheet as the previous section described, you have more than just the data set itself. A new range name is automatically defined, and refers to the range of cells defined by the fields and records that were returned. That data range has properties that you can manipulate. You can access the properties by clicking the Properties button on the Import Data dialog box (see Figure 18.9).

But it's usually best to have a look at the data before you start changing the ranges properties. You can modify the properties after the data has been written to the worksheet. Just right-click any cell in the external data range and choose Data Range Properties from the shortcut menu. When you ...