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 a worksheet, it consists of a minimum of two parts: display text and URL address. If you have a whole series of hyperlinks from which you want to extract the underlying address, 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 a Web page and paste it into a worksheet, you can end up with more than you bargained for. Here's how to get rid of the extraneous objects that may end up in the worksheet.
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
Make a reference to a hyperlink in a formula, and you may be surprised that the reference doesn't return an active hyperlink. Here's why that happens and what you can do about it.
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 a Browser in a Hyperlink
Excel allows you to easily add hyperlinks to a worksheet. Click on it, and the target of the link is opened in a browser window. If you want to specify which browser is used to display the link, things get more complex.
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.