Archives Special Ending Soon

Just a quick reminder that the annual ExcelTips archives are still avaialble at a 30% discount. This is a limited-time offer, though; it ends this coming Wednesday.

Each annual archive provides a complete year of tips published in the pages of this newsletter, organized by topic. You'll at least want to check it out, as this offer only rolls around once a year. You can find full information at this page:

http://store.tips.net/T009970

I hope you have a great day and enjoy the tips in this week's newsletter!

—Allen
     

ExcelTips (ribbon) for 18 January 2020

Customizing Excel
Adjusting Status Bar Font Size

Excel can helpfully display some statistical information in the program's Status Bar. If you cannot see all the information you need, then you may want to adjust the font used in the Status Bar. Unfortunately, this is not as easy of a proposition as you may hope.

Read this tip »

(Thanks to Steve Aprahamian, Ron Solecki, Guy Goodwin, Philip Standley, and Wayne Edmondson for contributing to this tip.)

 
Cell formatting
Indenting Cell Contents

Excel allows you to apply several types of alignments to cells. One type of alignment allows you to indent cell contents from the left or right. Here's how to do it.

Read this tip »

 
Is It Worth a Thousand Words?

Tired of looking at boring numbers? Add the persuasive power of charts and graphics to your worksheets. Excel's tools can help you present your data in a more understandable, accessible manner. Find out why a picture is worth a thousand words.

 
Worksheet functions
Checking for Text

Need to figure out if a particular cell contains text? You can use the ISTEXT function to easily return this bit of trivia.

Read this tip »

 
Cell formatting
Making a Cell's Contents Bold within a Macro

When your macro is processing information in a worksheet, do you need to periodically make the contents of a cell bold? You can do so by adding one simple statement to your macro, as demonstrated in this tip.

Read this tip »

 
Protecting worksheets
Controlling Entry Order on Unprotected Cells

When you protect a worksheet, one of the benefits is that you can limit which cells can be used for data entry. How a user moves from cell to cell is controlled by Excel. If you want to control the order of cell selection rather than having Excel control it, read on.

Read this tip »

(Thanks to Willy Vanhaelen for contributing to this tip.)

 
Worksheet functions
Making PROPER Skip Certain Words

The PROPER worksheet function is used to change the case of text so that only the first letter of each word is uppercase. However, some words should not have the initial letter uppercased. There are a couple of ways you can modify the work done by PROPER, as described in this tip.

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.

 
Making Worksheet Copies for Daily Shifts

I have an Excel worksheet that I need to use for each of 3 shifts each day. I make a copy of this worksheet for each shift, each day, over and over. It seems that it would be helpful if I had a macro that could copy the master worksheet 3 times for each day in a month, naming the worksheets "February 1 Shift 1," "February 1 Shift 2," etc. I cannot find a macro to do something like this and was wondering if anyone could help.
—Ryan Lewis (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