Don't Miss Out

Just a quick reminder that the annual ExcelTips archives are still avaialble at a 30% discount. This is a limited-time offer, though; it ends this coming Wednesday.

Each annual archive provides a complete year of tips published in the pages of this newsletter, organized by topic. You'll at least want to check it out, as this offer only rolls around once a year. You can find full information at this page:

http://store.tips.net/T009970

I hope you have a great day and enjoy the tips in this week's newsletter!

—Allen
     

ExcelTips (ribbon) for 11 January 2025

Charts and charting
Charting with a Large Number of Data Set Formats

When you are trying to convey quite a bit of data in a chart, formatting all your data series can be challenging. This tip looks at some ideas you can use to make sure your data is conveyed in the best way possible.

Read this tip »

(Thanks to Dave Newcomer, Ryszard Raciborski, and Peter McNab for contributing to this tip.)

 
Formulas
Finding Circular References

If you have circular references in a workbook, you may see an error message appear when you first open that workbook. If you want to track down those offending circular references, Excel provides two different techniques you can use.

Read this tip »

 
Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

 
Worksheet functions
Cleaning Text

You can use the CLEAN worksheet function to remove any non-printable characters from a cell. This can come in handy when you want to pare down what is stored in a worksheet.

Read this tip »

 
Worksheet functions
Using COUNTIF with Colors

Excel allows you to easily format cells with different fonts, borders, and colors. If you want to count the number of cells that use a particular background color, there are a couple of approaches you can use. This tip shows you how.

Read this tip »

     

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.

 
Excel Stops Recalculating

I've been using Excel for quite some time. I noticed that one of my often-used workbooks recently stopped recalculating. When I check if calculation has been set to manual (Excel Options), it has been. I haven't purposely done this, however. Is there some shortcut key I'm hitting, by mistake, that sets calculation to manual?
—Vernon Richards (provide an answer for this Help Wanted question)

 
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