ExcelTips (menu) for 28 November 2020

Capitalizing Just a Surname

Changing the capitalization of text is, believe it or not, a common task in Excel. Common or not, it can be frustrating to figure out how to change the capitalization of just part of the text. Here's an easy way to change the capitalization of a surname that is part of a longer name.

Read this tip »

Searching for Wildcards

Wildcard characters can be used within the Find and Replace tool, but what if you want to actually search for those wildcard characters themselves? That's where the judicious use of the tilde character comes into play.

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 500 pages of detailed info on how to better use Excel. Learn more about Excel today!

Inserting Rows

Need to insert rows in your worksheet? Excel provides a few techniques you can use to do this. Here are some ideas you can put to work.

Read this tip »

Changing Font Color

There are any number of reasons to format different cells in different colors. Excel allows you to easily change the color used to display information. This tip describes a couple of ways to change font color.

Read this tip »