Snow. Snow? Really?

This week has been one of travel and work--lots of work. I've decided to redo one of my large products, and that takes a huge amount of effort and time. (There are times I wish there were others in my office besides just me!)

Added to the mix was the fact that we had a solid reminder that winter is on the way. Even though you might think that we should consider having autumn before winter comes, we had our first snowstorm of the season this past Tuesday. Very little accumulation and what there was soon melted, but it was simply another in-your-face reminder of what is to come.

Anyway, I hope your week has gone well, and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (ribbon) for 23 September 2017

Cell formatting
Adjusting Center Across Selection with a Cell Value

One of the most common cell alignment settings I use is the one to center across a selection. If you want to vary how this setting does its work, you'll need to resort to using a macro, as described in this tip.

Read this tip »

(Thanks to Andrija Vrcan, Terry Horan, Mike Shellito, Bob Beechey, Harry Ruchti, Jacques Raubenheimer, Dave Kerr, and Michael Schaper for contributing to this tip.)

 
Graphics
Moving and Copying Graphics Objects

Excel doesn't just work with numbers and text. You can also add graphics objects to your worksheets, and then use Excel's tools to work with those objects. Here's how to move and copy graphics to your heart's content.

Read this tip »

 
Formatting Made Powerful

Discover one of the foundational building blocks of Excel. Custom formats are the basis for all cell-level formatting in Excel, and you can master their use. Display your data exactly and precisely as you want.

 
Powerful spreadsheets
Personal Workbook Fails to Load

The Personal workbook is special; it is where you can store macros you want to use all the time in Excel. What do you do, however, if the Personal workbook doesn't automatically load when you start Excel?

Read this tip »

 
Powerful spreadsheets
Excluding a Specific Add-In at Startup

Got an add-in that you don't want loaded each time that Excel starts up? Here are a few ways that you can exclude it.

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.

 
Protecting Conditional Formatting

I have a worksheet that uses conditional formatting extensively. However, the conditional formatting keeps getting messed up when users copy and paste information or when they use drag and drop to edit the worksheet. What is the best way to prevent this from happening?
—Kees Ritmeester (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