Topic: Online and Web

The following are additional topics related to the category listed above. A bracketed number after the topic indicates how many articles are related to that subject.

Tips, Tricks, and Answers

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

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 2002 | 2003

More Topics

Tips, Tricks, and Answers

Fast Answers!

Helpful Links

Great Info!

RSS Feeds