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 (ribbon) for 11 July 2020

Excel can calculate date in lightening time
Making a Named Range Non-Scrollable

Excel provides a few ways that you can freeze or split what you see in your worksheet. The appropriateness of these tools to a particular task depends entirely on what you want to see happen with your data.

Read this tip »

 
AutoFill
Turning Off AutoFill

AutoFill is a great editing tool that comes in particularly handy when you are first creating a worksheet. You may, at some point, want to turn off the feature. This tip shows how you can do this.

Read this tip »

 
Pay a Visit to Formville

Need invoices, statements, receipts, applications, and hundreds of other business forms you can put to use right away? How about if you can get those forms for free? Discover what awaits you in Formville, your destination for free printable business forms.

 
Charts and charting
Changing Axis Tick Marks

Create a chart in Excel, and you may find that the tick marks shown on the axes in the chart aren't to your liking. It is easy to change the interval at which the tick marks occur by using the information in this tip.

Read this tip »

 
Editing
Checking for an Entry in a Cell

You may be looking for a way to have a formula determine if a particular cell has anything in it. Here's how you can find the information.

Read this tip »

 
Date formulas
Calculating Months for Billing Purposes

Different businesses have different ways to calculate elapsed time for billing purposes. Figuring out a formula that reflects your company's calculation method can be challenging.

Read this tip »

 
Worksheets
Sheets for Days

Need a quick way to have a worksheet for each day in a month? Here's a macro that makes the worksheet creation a snap.

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.

 
Seeing the Difference on the Status Bar

I frequently need to see the difference between two cell values. Clearly I can enter a simple =A1 - B1 into a spare cell, but it would be so much easier if I could just select the two cells of interest and see the difference, as with sums, averages, etc., in the Status Bar at the bottom. Is this possible?
—Mike Rawlings (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