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

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?

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Excel's text formatting capabilities can make the results of your financial, statistical or scientific spreadsheet calculations more esthetically pleasing and easier to follow.

Learn how to master Excel 365 conditional formatting to transform raw data into actionable insights with this step-by-step guide.

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.

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

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.

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