Online and Web (Microsoft Excel)
Often, the purpose of using Excel is to publish content online.
Fortunately, Excel provides a few tools to make the transition from an Excel file to the Internet easy. In addition, you may want to pull information from online sources and place it within your worksheet.
These tips explain what you can do with Internet-related content in Excel.
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.
Besides saving a worksheet as a complete Web page, you can also save smaller portions of your data to an existing Web page. This tip shows how easy such an operation is.
Before some features in Excel can function properly, you must have the correct permissions set for the user of the computer. This tip explores where to look to correct some of these problems.
Want your worksheets to be available to others on the Internet? Excel provides a way you can save your data in HTML format, and it is as easy as saving your workbook in any other format.
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.
Excel allows you to open HTML pages within the program, which is great for some purposes. What if you want to open a browser window, however, from within Excel in order to display an HTML page? This tip highlights two methods you can use, within a macro, to perform the task.
You can store all sorts of information in a worksheet, including Web addresses. If you want to open those addresses in a browser, you can click on each of them individually, or you can utilize a macro. This tip examines different ways you can open a number of different addresses using macros.
Excel allows you to copy information from the web and paste it into a worksheet. Problem is, the pasting could take some time to complete. Why the pasting may be slow (and fixing it) could take some detective work, though.
When you paste information from Excel into other programs, you may get more than you actually want. It is not unusual for the paste to include formatting characters such as dollar signs and commas. Here are some ideas for getting rid of those characters and pasting just the values into the other program.
Excel provides a good number of worksheet functions that can help you pick apart text strings in various ways. In this tip those functions are put to use to pull apart a URL into its component pieces.
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.
You can configure images in Excel so that if someone clicks on them, a macro is executed. You cannot, however, have a macro and a traditional ScreenTip tied to the same object. This tip explains how you can get around this limitation using two separate techniques.
Wouldn’t it be great if Excel could automatically e-mail you when a due date is reached? It can, if you are using Outlook and you implement the macro presented in this tip.
Got a single worksheet that you want to e-mail to someone, but don’t want them to see the rest of the worksheets in the workbook? You can apply the techniques described in this tip to send just the information you want.
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.
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.
Does it bother you when you enter a URL and it becomes “active” as soon as you press Enter? Here’s how you can turn off this activation so that your URLs remain as regular text.