Microsoft Office Tutorials and References
In Depth Information
columns of data to help visually group them, or even add some clip art, a company logo,
or some pictures.
Not everyone has an eye for color, and pulling it all together can be daunting, so Excel
provides you with professionally designed themes, which you can apply to any workbook.
A theme is a set of unified design elements that provides a consistent look for a work-
book by using color themes, fonts, and effects, such as shadows, shading, and animations.
However, if you simply want to format a range of cells in a worksheet you can quickly ap-
ply a cell style. A cell style is a defined collection of formats—font, font size, attributes,
numeric formats, and so on—that you can store as a set and later apply to other cells. You
can use one of Excel’s built-in cell styles, or create one of your own.
If you need to find the various formatting attributes and change them, you can use the
Find and Replace Formatting feature to change them all at once instead of making indi-
You can change the appearance of the data in the cells of a worksheet without changing
the actual value in the cell. You can apply numeric formats to numbers to better reflect
the type of information they represent—dollar amounts, dates, decimals, and so on. For
example, you can format a number to display up to 15 decimal places or none at all. If you
don’t see the number format you need, you can create a custom one.
Format Numbers Quickly
Select a cell or range that contains the number(s) you want to format.
Click the Home tab.
Click the Number Format list arrow, and then click any of the following
• General. No specific format.
• Number. 0.75
• Currency. $0.75
• Accounting. $ 0.75
• Short Date. 3/17/2013
• Long Date. Wednesday, March 17, 2013
• Time. 6:00:00 PM