Checking for Text

Need to figure out if a particular cell contains text? You can use the ISTEXT function to easily return this bit of trivia.

Read this tip »

Turning Off Automatic Capitalization

Type some information into a worksheet, and you may notice that Excel automatically capitalizes some of your information. This happens because of an AutoCorrect setting that you can, if desired, change.

Read this tip »

ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 400 pages of detailed info on how to better use Excel. Learn more about Excel today!

Changing the Comment Color

Normally Excel displays comments in a color reminiscent of sticky notes you keep around your office. If you want them to use a different color, here's how to make the change.

Read this tip »

Hyperlinks in Shared Workbooks

Inserting a hyperlink into a workbook that is shared with others is not possible in Excel. Here's what you can do about it.

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.