Reviewing or working with the data in your worksheets might not be high on the list of tasks you do with great enthusiasm, but you can make your work in Excel visually interesting by formatting the cells in your worksheets. To add continuity to the design, you can use the predefined formats that match the main theme used in the document. You can also modify the formatting by choosing different fonts and adding emphasis such as italicized or bold type, adding borders and color to the cells, and aligning your data for the greatest clarity.

Format Some Cells

1. Select the cells you want to format with the same formatting.

2. On the Home tab, click Cell Styles, and point to the different styles to see how your selected cells look using that style. Click the style you want.

3. To customize any existing formatting or to create your own formatting, use the buttons and galleries on the Home tab to format the cells with fonts, emphasis, alignment, borders, and colors; and specify whether you want the text to wrap onto more than one line if it’s too long to fit into its cell.

   

Tip

To select a large range of cells, select the first (top-left) cell of the selection, scroll down and/or over to the end of the area to be selected, hold down the Shift key, and then click the last (bottom-right) cell of the selection.