Find and Replace is a useful feature in the Office suite programs which allows replacing an existing text with a new text. However, it can also be used to find and replace the color of the text. You ...

In this post, we will show you how to change lowercase to uppercase in Excel. Textual data in Excel often consists of datasets that are written in lowercase. Sometimes, we require changing this data ...

Excel drop-down lists, like those found on Web pages, help you view large amounts of data in a small area. They are also useful for limiting the choices an Excel spreadsheet user can make when editing ...

Microsoft Excel may be a productivity app that emphasizes numbers, but it has useful tools for text as well. For instance, that handy spreadsheet app will let you wrap text. And getting it done is a ...

In the November 2004 Tech Q&A column (page 85) I wrote with absolute confidence that there is no easy way to change the case of text in Excel. Within three weeks of the publication date, 435 ...

Sometimes there's just too much text to display when properly titling your Microsoft Excel columns. Although you can try wrapping text, using acronyms or shortening words, the headers widen your ...

Every time Melanie publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from ...

Reader Jackolyn wrote in with this question: “I am the newsletter editor for our church newsletter and Excel is driving me crazy with its KARTIKA font. Each time I try to type info in a calendar cell, ...