O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required