Today I'm off on the road again, this time for an overnight excursion. We are traveling down to Gallup, New Mexico (450 miles), to visit with friends for the church blessing of their infant. We are looking forward to the trip; I always enjoy traveling through the wide-open spaces of the American West.
As mentioned, this is a quick overnight trip, and we'll be making the return leg Sunday (tomorrow).
I hope you have a great week and enjoy the tips in this issue!
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.
Incorrect Links after Sorting Hyperlinks
When you sort your data you should always check to see if the sort was done correctly. What if sorting messes up hyperlinks in a worksheet, though? That seems to be a unfortunate problem with Excel under some circumstances.
(Thanks to Guy Goodwin for contributing to this tip.)
Using SUM In a Macro
Want to use a worksheet function (such as SUM) from within a macro? Here's how easy it is to accomplish the task.
Enhance Your Excel Skills with Macros
Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...
Calculating Statistical Values on Different-Sized Subsets of Data
Discovering different ways to analyze your data can be a challenge. Here's how to work with arbitrary subsets of a large universe of data so you can get the analysis you need.
Creating Scenario Summaries
If you've defined a variety of scenarios for your workbook, Excel can provide a handy way to compare the effects of those scenarios. This is called a scenario summary, as 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.
Saving Movement on Enter with a Workbook
I use several Excel workbooks daily. In some, I want the cursor to move down after entering the data and in others I want the cursor to move right. Is there a way to save the cursor direction with each individual workbook?
Publisher and Copyright Information