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.

graphics/24fig02.jpg

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

Table 24.1. Web Toolbar Tools

Tool

What It Does

Back

Displays the previous Web page

Forward

Displays the next Web page

Stop

Stops the browser from searching for a Web page

Refresh

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

Favorites

Stores your favorite Web site addresses

Go

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

Address

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
     
    ASPTreeView.com
     
    Evaluation has ИКѕїСіСУПexpired.
    Info...