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.)

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.

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 »

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 »

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)