Playing Catch-up

This past week has been rather busy. We returned from Arizona (finally!) on Wednesday, but we were a bit under the weather with coughs and colds. While trying to fight that off and catch up on sleep, I also had the need to get caught up on work that was delayed while I was traveling.

I *think* I'm mostly caught up, but it seems that just about every time I turn around, I find another thing needing attention. (Perhaps I won't truly be caught up until Monday or Tuesday. Who knows!)

Anyway, I hope your weekend is going well and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 22 April 2017

Macros extend Excel
Forcing a Macro to Run when a Worksheet is Recalculated

Normally a macro is only calculated when you specifically tell Excel to calculate it. Some macros need to be calculated whenever your worksheet is recalculated. This won't happen unless you include a very specific command within the body of your macro.

Read this tip »

 
AutoCorrect
Using AutoCorrect

The AutoCorrect feature in Excel is a great tool for quickly entering information. Here's an explanation of the feature and a quick overview of how to use it.

Read this tip »

 
Is It Worth a Thousand Words?

Tired of looking at boring numbers? Add the persuasive power of charts and graphics to your worksheets. Excel's tools can help you present your data in a more understandable, accessible manner. Find out why a picture is worth a thousand words.

 
Charts and charting
Adding Text Boxes to Charts

Need to add a text box to your charting masterpiece? There are a couple of ways you can do so.

Read this tip »

 
Files
Loading Unwanted Files at Startup

Imagine how painful it would be if every time you started Excel it tried to load all the files in your root directory? That is what was happening to Stephen, and here's how to fix it.

Read this tip »

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450