What's New on Excel.Tips.Net

The following are the newest articles on Excel.Tips.Net. Click the article's title (shown in bold) to see the associated article.

Creating and Naming a Worksheet Using a Macro. You can use macros to make your common Excel tasks easier and faster. For instance, if you routinely need to create new worksheets based on an existing worksheet, you might want to use a macro to perform the task. Here's a couple of suggestions for just such a macro. (January 17, 2009)

Splitting Text to Multiple Cells. When processing data, you may have a need to split a long text string into shorter chunks of text consisting of whole words. The built-in tools provided by Excel may not be suitable for this purpose, but there are a couple of ways you can approach the problem. (January 17, 2009)

Shortcut for Pasting Only Values. Excel's Paste Special command is used quite a bit. If you want to create some shortcuts for the command, here's some ways you can approach the task. (January 17, 2009)

Opening an HTML Page in Excel. 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. (January 17, 2009)