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 ...

Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart. Conditional formatting makes a cell look a certain way ...

Have you ever stared at a massive spreadsheet, feeling overwhelmed by rows and columns of data that all seem to blur together? You’re not alone. Whether you’re tracking project deadlines, analyzing ...

Sometimes when I’m working with an Excel worksheet and I want a cell to look a certain way, I run into what appears to be a limitation in the program. It might be trying to enter product numbers with ...

Excel isn’t the sexiest application in the world—it has an unfortunate association with the type of Milton-esque office drones we all wish we weren’t. All the same, you’re going to have to use at some ...

A giant grid of numbers can be mind-numbing. Once I discovered the magic of color-coded rules, spotting shifts and irregularities got a whole lot easier. A vivid spreadsheet quickly calls attention ...

One of the most common problems with some Excel workbooks (and other types of spreadsheets) is painfully slow load times and updates. There are three typical cuprits: too many calculations, too much ...

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 ...

One of the easiest ways to remove specific text, letters, or symbols from an Excel spreadsheet is to use the Find and Replace feature. The Camera tool is a handy function that allows you and your ...