Fix "fake" numbers, strip hidden web spaces, and join text professionally using Excel's built-in legacy and modern tools.

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

In Google Sheets, as in other spreadsheet programs, you can set the formatting of a cell (text color, background color) based on the data contained within that cell. This is called "conditional ...

When you revise your Excel file and attempt to save it, the app, in addition to revisions, also saves any part containing data or formatting. As such, any empty cells containing formatting and lying ...

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

If you work with large spreadsheets, this one's for you.

I've seen spreadsheets that are basically interactive tutorials, and many more loaded with what Edward Tufte refers to as "chartjunk" -- embellishments that do nothing to make the presentation of ...

In Google Sheets, as in other spreadsheet programs, you can set the formatting of a cell (text color, background color) based on the data contained within that cell. This is called "conditional ...