As mentioned in the intro, you can use conditional formatting to make certain values stand out with colored text and backgrounds. You can, for example, indicate problem data values in red, and ...

The easiest way to spot a unique value is to format it, and Microsoft Excel offers two ways to do so.

How to combine values into a single cell in .xls Excel files The newer features and functions that I’ll be using later in this article aren’t available in the earlier .xls format.

The Microsoft Excel Status Bar is now more advanced than before with the new ability to copy and paste values.

Copy Comments and Notes With Paste Special in Microsoft Excel, you can copy and paste more than a cell's contents or formatting. Indeed, you can also duplicate a cell's comment or note in another ...

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows. When you try to copy the subtotals by ...

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...