How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.

If Excel's number formats don't work for you, you can create a custom number format.

Excel provides numerous predefined table styles that you can use to quickly format a table. If the predefined table styles don't meet your needs, you can create and apply a custom table style.

In Excel, formatting worksheet (or sheet) data is easier than ever. You can use several fast and simple ways to create professional-looking worksheets that display your data effectively.

Select the cell or range of cells that you want to format. On the Home tab, select the Number Format down arrow, then select More Number Formats at the bottom of the list.

You can use conditional formatting to highlight cells that contain values which meet a certain condition. Or you can format a whole cell range and vary the exact format as the value of each cell varies.

Feb 2, 2012 · If you don’t like the default date format, you can pick a different one in Excel, like February 2, 2012 or 2/2/12. You can also create your own custom format in Excel.

You can scroll through the table formats with the mouse or your keyboard's arrow keys. Custom table styles are available under Custom after you create one or more of them. For information on how to …

Receive tips for best practices for formatting numbers as percentages and view examples of ways to calculate percentages in Excel.