Do You Macro?

This past week I sent out a message about the fact that I updated my ExcelTips: The Macros e-book. It's been almost exactly two years since I last updated it, and I finally made the latest edition available this past week.

This edition is (as you would expect) updated from the previous editions, and it now contains over 1,450 pages of great content. That's a *TON* of information on how to work with macros!

ExcelTips: The Macros, twelfth edition, includes every tip related to macros that has ever been published in almost three decades of ExcelTips, all in one convenient e-book. There's too much in this edition to cover here, but I'd invite you to go and take a look:

     https://store.tips.net/T010157

The page includes complete details, including information on how the new edition is available, for a limited time, for 30% off the regular price. (That means you can get an immediate download, if you choose, for only $27.99.)

Don't delay; this special offer is available only for the next ten days or so; it ends on May 21, 2025.

Thanks for your continued support of ExcelTips!

—Allen
     

ExcelTips (ribbon) for 10 May 2025
Formulas
Finding References to Nonexistent Cells

When you merge cells that already contain information, you may run into problems with formulas that refer to the pre-merged cells. This tip examines what you can do to avoid problems and track down issues.

Read this tip »

(Thanks to Dave Newcomer, Michael Avidan (MVP), James Woolley, Ryszard Raciborski, Tomek Dluzniewski for contributing to this tip.)

 
Excel can calculate date in lightening time
Going to the Corners of a Selected Range

When you select a range of cells (particularly if it is a large range of cells), you may not be quite sure if you've selected everything you needed to. One way to check is to move around the corners of the selected range, using the shortcut key described in this tip.

Read this tip »

 
Lookup Exactly the Data You Want

Excel's lookup functions are easily the most powerful worksheet functions you can use. Master these seven functions you'll never again view a worksheet full of data in the same way. The power these functions provide you is anything but small. Take your first step today!

 
Worksheets
Changing the Color of Worksheet Gridlines

Want the gridlines in your worksheet to be a different color? You aren't limited to stodgy black; Excel lets you make them just about any color you want. Here's how to make the change.

Read this tip »

 
Comments
Finding and Replacing Text in Notes and Comments

Excel allows you to add comments to individual cells in your workbook. Unfortunately, Excel doesn't provide a way to search and replace text in those comments. You can do it with a macro, however.

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.

 
Moving Worksheet Tabs to a Different Place

By default, Excel places the worksheet tabs just below the worksheet and above the status bar. Is it possible to move the tabs to a different side of the worksheet? If I was able to move them to the left or right side, it seems I could see more of them at once.
—Benny Esposito (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