Time is Fleeting

It is amazing how quickly we are racing toward the end of the year. It won't be long before Thanksgiving is here, followed shortly thereafter by Christmas. Then, the new year will be upon us.

It just seems like this year has raced by...

This time of year is a planning time for many companies and individuals. We not only take stock of the waning year, but look forward to the new one. (Yes, fewer than 8 weeks remain in the year.)

As part of that reflection and planning process, you may be looking for ways to improve your skills and expand what you can do. A great aid in that development (personal or corporate) would be the Tips.Net Library. I announced it this past week, and the doors to the Library are open right now. It provides you with an "all-access pass" to information, learning, and growth at an astounding 75% discount.

I won't go into the details here, but I have provided those details at this page:

https://library.tips.net

Check it out soon. The Library doors will only be open for a while longer; they will close on November 20.

I hope you have a great weekend.

—Allen
     

ExcelTips (ribbon) for 9 November 2019
Workbooks
Opening Two Workbooks at Once

Do you work with a group of workbooks all the time in Excel? Windows and Excel both provide a plethora of ways you can open both workbooks at the same time.

Read this tip »

(Thanks to Ron Solecki, Harold Druss, Paul Webster, Ryszard Raciborski, Alan Cannon, Jos Graindor, James Woolley, Benjamin Morin, Bob Beechey, Jiim Morrison, Alec Whatmough, Ben Davies, Jacques Raubenheimer, Wayne Edmondson, Mark Galloway, Tamara Power, Dave Potts, Gerhard Seljehammer, Olle Ivert, Yvan Loranger, John MacLeary, and Dave Newcomer for contributing to this tip.)

 
Printing
Printing a Draft Watermark

Adding a watermark to the background of a printout can be challenging. This tip explains the different ways you can implement your own watermarking techniques.

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!

 
Powerful spreadsheets
Backing Up Custom Dictionaries

The custom dictionary used in Excel contains the information you decide relative to spelling. After a while, you might start to realize how much work it took to get that dictionary just as you like it. Here's how to back up all that work.

Read this tip »

 
Date formulas
Calculating Fractions of Years

When working with dates and the relationship between dates, Excel provides a variety of worksheet functions that may prove helpful. One such function is YEARFRAC, which allows you to calculate what fraction of a year is represented by the number of days between two dates.

Read this tip »

 
Macros extend Excel
Running a Macro when a Worksheet is Deactivated

When you change from one worksheet to another, you may want to have Excel automatically run a macro for the worksheet you are leaving. You can easily create such a macro by using the Auto_Deactivate event.

Read this tip »

(Thanks to Col Delane for contributing to this tip.)

 
Macros extend Excel
Copying Worksheet Code Automatically

When creating a workbook to be used by others, you may want any worksheets they add to the workbook to contain some special macro coding. Here's some ideas on how you can make sure that the worksheets contain just what you need.

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.

 
Finding Circular References

When I open a particular workbook, Excel informs me that it contains circular references. Problem is, I cannot figure out where that circular reference is. What is the best way to locate these?
—Michael Armstrong (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