Excel 2010 Bible

Chapter 28: Excel and the Internet

609

FIGURE 28.3

Viewing the single file Web page in Internet Explorer.

Opening an HTML File

Excel can open most HTML files, which can be stored on your local drive or on a Web server.

Choose File ➪ Open and locate the HTML file. If the file is on a Web server, you’ll need to copy

the URL and paste it into the File Name field in the Open dialog box.

How the HTML code renders in Excel varies considerably. Sometimes, the HTML file may look

exactly as it does in a browser. Other times, it may bear little resemblance, especially if the HTML

file uses Cascading Style Sheets (CSS) for layout.

After opening an HTML file, you can work with the information using the normal Excel tools.

Another way to open an HTML file from a Web server is to use a Web query, which is discussed

later in this chapter (see “Using Web Queries”).