Catching Up

I'm hoping that your weekend is going well. Here at the Wyatt household we are catching up on work that has been put off for far too long. (For instance, the house is getting painted--about two years past when it should have been!) This has to be done about this time of year, because it is the only time at our elevation when you can count on the temperatures being warm enough both during the day and overnight.

In "newsletter news," if you are a relatively new subscriber to ExcelTips, you may not know about its sister publication, for users of Microsoft Word. If you don't subscribe, you really should check it out. You can find the website here:

     https://wordribbon.tips.net

You can poke about on the site at any time, and you can also sign up for the newsletter using the signup form at the right side of any page.

Anyway, I hope you enjoy the tips in this week's newsletter!

—Allen
     

ExcelTips (menu) for 11 July 2020
Graphics
Inserting Multiple Drawing Objects

When you need to add more than one of a particular drawing object to a worksheet, you can use the techniques described in this tip to make the job faster. Excel allows you to "lock" the drawing tool on so that creating multiple objects is very easy.

Read this tip »

 
Files
Cannot Double-Click to Open a Workbook

When you double-click on a workbook in Windows, the Excel program should be started and the workbook loaded. When this doesn't happen, it means something has gone wrong and you need to try to track down the problem.

Read this tip »

 
Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

 
Charts and charting
Noting a False Zero On a Chart

When creating charts that will be used by other people, you may need to take some liberties with the presentation of your data so it is more easily understood. You will obviously want to note on the chart that some changes have been made, but how do you do it?

Read this tip »

 
Macros extend Excel
Finding the Path to the Desktop

Figuring out where Windows places certain items (such as the user's desktop) can be a bit frustrating. Fortunately, there are specific functions built into Windows that can help you determine the location you need.

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