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 ” Stands for Uniform Resource Locator ; similar to a filename or address. The Web uses it to locate the Web page. Using the Web ToolbarTo 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
Opening a Web Page in ExcelWhen 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. |