A Humble Thanksgiving

I hope each of you had a great Thanksgiving. (If Thanksgiving was not celebrated this past week in your corner of the world, I hope you had a great Thursday.) Ours was good. Though we were missing Eric and his family from our dinner table, we were able to get together with our two other sons and their families. There was much food, much fun, and many memories.

Eric wasn't there because he is still in the hospital, though we have hopes he will be discharged shortly. He has been responding well to treatment, and he is out of the immediate danger he was in when he entered the hospital. His family (wife and two teenage children) were able to gather with him, in his hospital room, to celebrate the holiday.

The humble melancholy that often attends me when I experience deep gratitude still lingers with me. So many of you reached out to offer words of encouragement and to help with Eric's care. I was deeply moved by the many who said that they were praying for Eric and for me (for me!), something I never expected. So kind, so kind. Many of you were in my prayers of gratitude that I offered over Thanksgiving.

If you are interested in seeing how my sister's GoFundMe campaign for Eric is doing, you can do so here:

https://www.gofundme.com/f/our-turn-to-help-eric

We hope, with the help of so many kind, giving people, to top $50,000 in the near future. It would be great if that could happen before he is released from the hospital.

Anyway, I digress. I just wanted to say thank you to the many hundreds of kind, good-hearted folks who have helped from all walks of life. Thank you.

I hope you find the tips in this week's newsletter to be helpful.

—Allen
     

ExcelTips (ribbon) for 26 November 2022

Formulas
Generating Random Door Access Codes

People often use Excel to maintain lists of information that they need to track. This tip shows several ways you can track a set of unique, random door codes in a workbook.

Read this tip »

(Thanks to Ron Solecki, Brian Dorey, Steve Aprahamian, Joe Smith, Patrick Sedgwick, Dave Onorato, Ryszard Raciborski, Bill Palmer, Peter McNab, Tomek Dluzniewski, and Murray Belchamber for contributing to this tip.)

 
Worksheet functions
Using the COLUMN Function

Need to know the column number for use in a formula? The worksheet function you want is the COLUMN function, described in this tip.

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!

 
Conditional formatting
Returning a Value Based on Text Color

Conditional formatting rules can be used to adjust the way in which information is displayed in Excel, such as the text color. If you want to use a formula to "read" that text color in some way, you are out of luck, however. This tip explains how you can work around the problem.

Read this tip »

 
Formulas
Activating the Formula Bar with the Keyboard

Hate to take your hands off the keyboard while working on a worksheet? Here's one way to activate the Formula Bar without the need of using the mouse.

Read this tip »

 
Charts and charting
Using Chart Titles

Titles can be a great addition to any chart. They help provide explanatory information about the information in the chart. Here's the quick way to add all the titles you need.

Read this tip »

 
Macros extend Excel
Telling which Worksheets are Selected

If your macro processes information on a number of worksheets, chances are good that you need your macro to figure out which worksheets are actually selected. This tip explains how you can determine that info in your macro.

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.

 
Printing Two Worksheets on a Single Page

I have a workbook that contains 2 small worksheets. I would like to print the 2 worksheets on a single landscape page. I set the printer's "pages per sheet" setting to 2, but the worksheets still print on 2 separate pages. Why does this happen and how can I get both worksheets on a single printed page?
—Brian Dorey (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