Allen Wyatt's ExcelTips (ribbon)

ExcelTips
(ribbon interface)
12 April 2014

Publisher's Notes

Tips

Incorrect Links after Sorting Hyperlinks

Using SUM In a Macro

Calculating Statistical Values on Different-Sized Subsets of Data

Creating Scenario Summaries

Help Wanted

Saving Movement on Enter with a Workbook

Web Addresses

ExcelTips

Tips.Net Store

ExcelTips Premium

Advertising

Help Wanted Questions

Free Business Forms

Free Personal Forms

Contact Info

Help Wanted Answers

Editor and Publisher

Allen's Blog


(Click above for more info)

Publisher's Notes

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!

—Allen

Tips

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.

Read the full tip...

(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.

Read the full tip...

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.

Read the full tip...

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.

Read the full 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:

  • Smoothing Out Data Series
  • Relative References within Named Ranges
  • Controlling the Printer in a Macro
  • Making a Cell's Contents Italics within a Macro

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.

Help Wanted

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?
—Kathy Mellor (provide an answer for this Help Wanted question)

 
Tips.Net

Publisher and Copyright Information
ExcelTips is published weekly by Sharon Parq Associates, Inc., PO Box 794, Orem, UT 84059. Copyright 2014 by Sharon Parq Associates, Inc., All Rights Reserved. All broadcast, publication, or retransmission is strictly prohibited without prior written permission from the publisher. ExcelTips is part of the Tips.Net network. Full information on distribution rights can be found in the FAQ at the ExcelTips Web site.