A Frustrating Week

I hope you are enjoying your weekend. I've had a rather frustrating week, to tell you the truth. If you want to learn a bit about it, my experiences led me to make another post in my often-neglected blog. You may want to read it, especially if you use Gmail and have sent me messages.

—Allen
     

ExcelTips (ribbon) for 15 January 2022

Formulas
Calculating an Average within a Date Range

Need to find an average of the values that fall within a date range? Excel provides a number of ways you can do this, relying on a number of worksheet functions.

Read this tip »

(Thanks to Steve Aprahamian, Andrew Gray, Tony Greaves, John Vander Linden, Andrija Vrcan, Jim Williams, Bob Myers, Michael Avidan (MVP), Steve Peterson, Dave Towne, Wayne Edmondson, Phil Webb, Alec Whatmough, Jacques Raubenheimer, Henry Arthur, Fred van der Meulen, and James Hoyt for contributing to this tip.)

 
Editing
Automatically Breaking Text

Want to convert the text in a cell so that it wraps after every word? You could edit the cell and press Alt+Enter after each word, but there's an easier way using a formula.

Read this tip »

 
ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 500 pages of detailed info on how to better use Excel. Learn more about Excel today!

 
Linking workbooks
Finding Wayward Links

Combining workbooks that have cross-links to each other can offer some special challenges. This tip examines how you can get around those challenges.

Read this tip »

 
Charts and charting
Reading Values from Graphs

Adding a trendline to a graph will allow you to see trends a bit easier, depending on your data. You can even utilize an option that allows you to see what formula Excel uses to create the trendline from your graph's values.

Read this tip »

 
Protecting workbooks
Using Strong Workbook Protection

Need to protect the data in your workbook so that others can't get at it? Here are some ideas on how you can approach the problem.

Read this tip »

 
Macros extend Excel
Adding Buttons to Your Worksheet

You can easily add a button to your worksheet that will allow you to run various macros. This tip shows how easy it is.

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.

 
Generating Random Strings

I have a need to generate random 15- and 20-character strings, and thought I might be able to do it in Excel. The strings can contain letters and digits, with no spaces. I know about the RANDBETWEEN function, but don't really see how it could be helpful for my purposes.
—Richard Clark (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  •  307-200-0450