You might need to clear all the cells' formats so that they can be interpreted as plain text. Here we tell you how to quickly clear any batch of cells depending on your needs. How to clear formatting ...

When you need to format text in multiple ways in a single cell in Microsoft Excel, then this guide shows you how to do it the easy way.

Formulaic conditional formatting rules in Microsoft Excel can be tricky, so learn how to avoid a common mistake.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

Pro Tip: To open formatting options, just select the cell (s) you want to format and press Ctrl-1 (Mac: Command-1). This actually works for anything in Excel: charts elements, images, etc.

Excel is known for automatically formatting certain entries, which is often useful but sometimes annoying. This automatic function can now be deactivated on an individual level. We'll show you how.

Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

Use Excel's conditional formatting feature to look at a specific cell in the row, determine if it's negative or positive and format the row based on the results.

Method for Excel 2010 For Excel 2010, right-click on the cell that contains the conditional formatting to move to other cells. Click Copy from the pop-up menu.