Online and Web

Tips, Tricks, and Answers

The following articles are available for the 'Online and Web' topic. Click the article's title (shown in bold) to see the associated article.

Automatic Text in an E-mail
When creating an e-mail address hyperlink using the Insert Hyperlink dialog box, Excel allows you to enter a subject for the message to be created by the link. If you want to also specify some body text, you need to use the techniques described in this tip.

Extracting URLs from Hyperlinks
When you add a hyperlink to and Excel worksheet, it consists of a minimum of two parts: display text and URL. If you have a whole series of hyperlinks from which you want to extract the underlying URL, this can be a tedious challenge. There are easy ways to get the required info, however.

Get Rid of Web Stuff
When you copy information from the Web and paste it into a worksheet, you may get more than you bargain for. You may end up with all sorts of other items, such as checkboxes, pictures, logos, and the like. This tip explains how you can easily get rid of most, if not all, of these items.

Hyperlinks that Open in a Different Browser Window
When you click a link in a browser, the target of that link might open in the same window or in a new window. Getting an Excel-generated webpage to do the first type of opening is easy; getting it to do the second type is much harder.

Linking to a Specific Page in a PDF File
The HYPERLINK function is great for linking to Web pages and some other resources, but it won't allow you to access a target page in a PDF file. Instead, you may need to use a macro that accesses the desired destination.

References to Hyperlinks Aren't Hyperlinks
If you have a hyperlink in a cell and you reference that cell in a formula, you may wonder why the result of the formula isn't a hyperlink as well. The answer lies in how Excel pulls the information it uses in its formulas. This tip explains the logic behind the result.

Retrieving Web Query Data without Interruption
If you use Excel's Web Query tools to grab data from a website, you may run into some problems if the site isn't available right away. This tip describes the problems and examines a way you can bypass the problem by interfacing with Internet Explorer from within an Excel macro.

Setting Web Fonts
Is your worksheet information destined for a Web page? Here's how you can specify the fonts that should be used when Excel generates the HTML code for those Web pages.

Specifying Your Target Monitor
When you create a worksheet that is destined for viewing on the Web, you will want to specify the monitor resolution you expect users to have when viewing your data. This information is used by Excel as it generates HTML files from the worksheets.

Suppressing the Reviewing Toolbar on E-mailed Workbooks
If you get tired of the Reviewing toolbar popping up whenever you open a workbook you received via e-mail. You'll love the information in this tip. Add the provided macro, and you can turn the toolbar off just as soon as it appears.

More Information

The following are additional topics related to the subject of 'Online and Web'. A bracketed number after the topic indicates how many articles are related to that subject.