Page 107 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 93

WORKING WITH EXTERNAL DATA 5

You can import the text formatting If you want to use a Web page
along with the Web page data. Click query in other worksheets, you
the Options button in the New Web can save it with all of the
Query dialog box. In the Web Query selections specified in the New
Options dialog box that displays, select Web Query dialog box. To save a
one of the following formatting options Web query, click the Save Query
( changes to ). button ( ) in the New Web
Query dialog box. In the dialog
box that displays, type the desired
FORMATTING DESCRIPTION query name, select a folder
location, and click Save.
None Imports the text only
and applies the You apply a Web query by clicking
Normal format style. Data ➪ Import External Data ➪
Rich Text Imports the text with Import Data. In the Select Data
the formatting on the Source dialog box, select the
Web page. query and click Open. In the
Full HTML Imports the text with Import Data dialog box, select the
all HTML styles, desired location for the new query
including links. and click OK.

=$A$1

■ The Import Data dialog ‡ Type the cell reference for ■ The worksheet contains
box displays. the first cell of imported data, the imported Web data.
or select it with the Collapse
Á Click the Existing Dialog button.
worksheet option to import
data into the current ■ To place the imported data
worksheet. in a new worksheet, click
New Worksheet.
° Click OK.
93