Microsoft Office Excel 2007 helps you manage large quantities of data with ease. One of the ways you can accomplish this is by changing how the program displays the data in your worksheet. For example, you can easily change the size of characters displayed in a cell, add color to emphasize important cells, or change the orientation of text within a cell. Excel 2007 also enables you to change a cell’s formatting based on the contents of the cell by creating conditional formats. While you had the ability to create these conditional formats in previous versions of Excel, Excel 2007 greatly expands the type and number of formats you can create.
Some cells have values that need to stand out. Whether the value is a grand total for a year’s sales or a label that lets your colleagues know that data entered into the worksheet must be within certain limits, you can change the font used to display the data; make the text larger or smaller; or make the text appear bold, italicized, or underlined. You can apply these settings by using the controls on the Home tab of the ribbon or on the Mini toolbar, but formatting cell contents isn’t an all-or-nothing proposition. You can choose to format a word or even a single character in a cell.
Use the tools in the Font, Alignment, and Number groups to change your text’s appearance.Caution
When you select multiple cells to change their appearance, the range you select might have a combination of cells that have already had formatting applied to them and cells that do not have any formatting applied. If this is the case, you might have to click the buttons multiple times until all of the cells are formatted how you want them.
