The Format Painter in Excel lets you copy formatting from one cell or group of cells to another cell or group of cells without copying their contents. Cell formatting includes everything from font ...

Do you know that you can format text in multiple ways in a single cell in Microsoft Excel? In this guide, we show how you can add multiple formatting to your text in a single cell in Excel. Formatting ...

The “Too many different cell formats” error occurs in Excel when the formatting in your spreadsheet exceeds the maximum number of formatting allowed. In Excel ...

In my post on table formatting, I demonstrated how to transform your static data into a simple yet sexy database in a matter of seconds. If you don’t know how to use table formatting, go read that ...

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number. If ...

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

Dennis O'Reilly began writing about workplace technology as an editor for Ziff-Davis' Computer Select, back when CDs were new-fangled, and IBM's PC XT was wowing the crowds at Comdex. He spent more ...

Have you ever stared at a colorful Excel spreadsheet, wondering how to quickly calculate totals or counts based on cell colors? It’s a common frustration for anyone managing large datasets. While ...

You can sum up entire columns or rows in Microsoft Excel using the AutoSum feature. The AutoSum tool automatically selects a column or row of numbers, but you can select any set of numbers by clicking ...