Excel® 2010 Bible

Chapter 28. Excel and the Internet

IN THIS CHAPTER

Saving Excel files in HTML format

Creating hyperlinks

Importing data from a Web page

Most people who use a computer are connected to the Internet. The Web has become an important way to share and gather information from myriad sources. To help you with these tasks, Excel has the capability to create files that you can use on the Internet and also to gather and process data from the Web. This chapter covers topics related to Excel and the Internet.

NOTE

Four of the Office 2010 applications are available in online versions: Excel, Word, PowerPoint, and OneNote. You can run these applications from within your Web browser. The online version of Excel is not the topic of this chapter, and is not covered in this book. Rather, the chapter deals with Internet-related features for the standard version of Excel.

28.1. Understanding How Excel Uses HTML

HTML (HyperText Markup Language) is the language of the World Wide Web. When you browse the Web, most documents that your browser retrieves and displays are in HTML format. An HTML file consists of text information plus special tags that describe how the text is to be formatted. The browser interprets the tags, applies the formatting, and displays the information.

28.2. Understanding the Different Web Formats

You can save an Excel workbook so that it's viewable in a Web browser. When you save an Excel workbook for viewing on the Web, you have two options:

• An HTML file: Produces a static ...