Searching on the Web

You can browse the Web to your heart's content by using Excel to start Microsoft Internet Explorer. You don't have to leave the program and start Internet Explorer or any other browser you might normally use. First, you need to connect to go online, and then just use the Web toolbar in Excel. You can enter a uniform resource locator (URL) and search for a specific Web page or browse around the Web at any time.

URL? graphics/newterm_icon.gif Stands for Uniform Resource Locator; similar to a filename or address. The Web uses it to locate the Web page.

Using the Web Toolbar

To display the Web toolbar in Excel, right-click any toolbar and choose Web from the shortcut menu. Excel docks the Web toolbar above the Formula bar.

Figure 24.2 shows the tools on the Web toolbar that are for browsing pages backward and forward, refreshing the current page, searching the Web, storing Web pages in the Favorites folder, and entering a URL.

Figure 24.2. The Web toolbar.


Table 24.1 lists the Web tools on the Web toolbar and what they do.

Table 24.1. Web Toolbar Tools


What It Does


Displays the previous Web page


Displays the next Web page


Stops the browser from searching for a Web page


Reloads the current Web page and updates it with the latest information

Start Page

Displays the home page for a Web site

Search the Web

Displays the Web site you requested in the Address box


Stores your favorite Web site addresses


Displays the Go menu that contains commands for navigating through Web pages

Show Only Web Toolbar

Hides all other Excel toolbars and displays only the Web toolbar


Lets you enter a Web address

Opening a Web Page in Excel

When you find the Web page you want to read, you can open that page directly in Excel. To do so, make sure you are connected and online. With the Web toolbar displayed in Excel, type the URL into the Address box on the Web toolbar. When the browser finds the Web site you requested, the Web page displays in your Excel window.

    Part I: Excel Basics