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 (menu) for 10 May 2025
Cell formatting
Changing Cell Patterns

You can shade your cells by filling them with a pattern. Here's how to select the pattern you want used.

Read this tip »

 
Powerful spreadsheets
Running a Macro when a Workbook is Closed

One of the automatic macros you can set up in Excel is one that is triggered when a workbook is closed. This tip explains how you can create a macro that runs whenever the workbook is closed.

Read this tip »

 
PivotTables Make You Feel Faint?

Do you get weak in the knees when asked to deal with huge amounts of data? Forget feeling faint ever again when you are asked to deal with PivotTables. Learn much more than the basics with PivotTables for the Faint of Heart, now available in three great versions.

 
Powerful spreadsheets
Handling Leading Zeros in CSV Files

When dealing with files containing comma-separated values, you want to make sure that what gets imported into Excel reflects what is really in the file. If you import a file and find that Excel strips off leading zeros from what it imports, there are a number of possible reasons. This tip explains how you can track down the problem and correct it.

Read this tip »

 
Powerful spreadsheets
Printing a Draft Watermark

Adding a watermark to the background of a printout can be challenging. This tip explains the different ways you can implement your own watermarking techniques.

Read this tip »

     

Special Note!

I've been publishing ExcelTips for years. Decades, actually. The newsletter you are reading right now is for very old versions of Excel. I still publish it because I know that some people are still using very old versions of Excel. Most people, however, are using newer versions of the program. If you are are using a newer version of Excel (2007, 2010, 2013, 2016, 2019, 2021, or the version in Microsoft 365), then you should seriously consider changing to the version of the newsletter designed for you. You can do so by clicking this link.

Thanks for your support of ExcelTips, and I hope you enjoy whichever version of the newsletter you receive. If you have any questions, just let me know.

 
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