Here we are in March, already, and this is the time that we start to seriously think about spring. (Well, we do in our area of the world.) Temperatures are trending upwards and winds are starting to blow. That brings spring shows and heralds the start of growing season.
I don't know about you, but I'm looking forward to spring. The winter has been long and hard for many in the Northern Hemisphere (particularly in the Eastern United States), so warmer weather is a good omen.
I hope that your week is going well and that you enjoy the tips in this week's issue of ExcelTips.
If you have an idea for a tip, send it our way. Any tips contributed will be credited in the issue in which they appear. You can learn more about the tips in this week's issue of ExcelTips by clicking the links provided below.
Pasting HTML without Hyperlinks
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.
(Thanks to John Vander Linden, Anwar Ahmed, Guy Goodwin, Thomas Papavasilio, Peter Johnson, Jennifer Thomas, and Don Bruck for contributing to this tip.)
Making Changes in a Group of Workbooks
If you need to change the same data in a large number of workbooks, the task can be daunting. Here are some ideas (and some macros) that can help make the task more manageable.
Pay a Visit to Formville
Need invoices, statements, receipts, applications, and hundreds of other business forms you can put to use right away? How about if you can get those forms for free? Discover what awaits you in Formville, your destination for free printable business forms.
Comments Don't Appear when Cell is Pointed To
One way that you can view comments in a worksheet is to have them appear when you hover the mouse pointer over a cell. If they don't appear when they should, the information in this tip may help.
When you add subtotals to a worksheet, Excel typically places them in the same column that you are subtotaling. If you want those subtotals moved to a different column, you'll appreciate the techniques described in this tip.
Need More ExcelTips?
You are reading the free version of ExcelTips. There is another version you could be reading right now: ExcelTips Premium. This week ExcelTips Premium subscribers also learned about:
Each weekly newsletter is in a professional PDF layout and presents double the tips (Premium subscribers see articles you won't in regular ExcelTips) with great, useful graphics. Plus, ExcelTips Premium subscribers get valuable money-saving benefits. For more information (including a sample issue), visit the Tips.Net store.
This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.
If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.
Making a Named Range Non-Scrollable
My worksheet is divided into two named-row ranges. How can I make the upper range fixed (permanently visible) while the lower range is scrollable?
Publisher and Copyright Information