Creating Superscript and Subscript Buttons

Want a quick way to apply superscript and subscript to selected text within a cell? This tip shows how the formatting can be done through a user form and a small set of macros.

Read this tip »

Finding Workbooks Containing Macros

Workbooks can contain macros, or not. It is entirely up to you whether they do or not, but at some future time you might want to find out which of your workbooks do contain macros. The way to find such workbooks can be as simple as searching for them.

Read this tip »

(Thanks to Krishna Pillalamarri for contributing to 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!

Colorizing Charts

Need to change the color of different parts of your chart? It's easy to do when you apply the technique described in this tip.

Read this tip »

Converting Cells to Proper Case

When storing text in a worksheet, you may have a need to change the case of that text so that the initial letter in each work is capitalized. The macros in this tip will help to change the case as you require.

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.