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

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

There are several ways to make data stand out visually in an Excel spreadsheet, but one of the simplest and most effective is to apply conditional formatting. What is conditional formatting in Excel?

In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...

To clear formatting from the selected cells in your workbook in Microsoft Excel, you can use Clear Formats, Keyboard shortcuts, Format Painter tool, etc.

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

This guide explains how to generate barcodes in Excel without any additional installations, using both the desktop and web versions of Excel. It covers formatting cells to preserve leading zeros ...

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

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.

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...