Fast AutoFill

Want to fill a long column with predictive data? It's easy to do by using AutoFill and a double-click of the mouse.

Read this tip »

Saving in Multiple Locations

Need to save a workbook in more than one location? Here's a handy macro that can save your workbook in lots of different places.

Read this tip »

Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

Counting Commas in a Selection

If you have a range of cells in which you want to count all the commas, there are several ways you can derive the figure you need. This tip examines different methods to achieve the count, and you can easily adapt the methods to count other characters.

Read this tip »

Locking All Non-Empty Cells

Need to make sure that your worksheet is locked, with only the blank cells accessible to editing? You can do this easily by using the Go To Special dialog box, or you can use a macro to do your configuration.

Read this tip »

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.