By using the Highlight Cells Rules, you can highlight duplicate cells in your Excel worksheet to avoid confusion and mistakes.

Learn how to highlight cells with negative values in Excel. Make negative numbers stand out in Red using Conditional or Custom Formatting.

Isolate a specific value, such as a number value in cells that contain both numbers and letters by using the Excel MID function. Click in the cell where you will display the value you want to isolate.

How to highlight values Excel has a built-in conditional rule that highlights unique values. You don’t have to come up with a special formula—you just run though a few clicks.

Even if you've never created a merged cell in a business spreadsheet, you may receive a spreadsheet that has one. Excel allows you to combine multiple cells into a single cell by clicking a button ...

Sometimes it's necessary to split cells in a spreadsheet, and Microsoft Excel makes it easy enough to do.

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

Do you want to keep important labels and data in view as you scroll through your Excel worksheets? Here are the steps to freezing those columns and rows.