Enjoying Leftovers

I hope you enjoy the tips in this week's newsletter. As for me, I'm enjoying leftover turkey and ham from our Thanksgiving holiday. (Other than that, it is a very laid-back weekend.)

—Allen
     

ExcelTips (menu) for 28 November 2020

Powerful spreadsheets
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 »

 
Find and Replace
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!

 
Editing
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 »

 
Excel can calculate at lightening speed
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 »

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  •  307-200-0450