You can apply formatting to an entire cell and to the data inside a cell—or a group of cells. One way to think of this is the cells are the frame of a picture and the picture inside the frame is the data. Formatting the cell might include adding a border, adding color or shading, and changing the size or style of the cell.
Excel contains many predefined cell styles that you can use. These styles let you make several formatting changes to cells at once. For example, you can add a fill color and change the color of text at the same time.
Follow these steps to apply predefined styles:
Select the cells you want to format.
Click Home > Cell Styles, and then choose the style you want.
If you don’t prefer to use a predefined style—or want to apply more specific formatting (such as a specific color) to your cells, you can right-click over the cell(s) you want to format and choose from the formatting options.
For example, to add borders and a fill color, do the following:
Select the cells you want to format and right-click.
To add borders to your cells, click the down arrow next to the Border button, and pick the borders you want.
To fill your cells with color, click the down arrow next to the Fill Color button, and choose the fill color you want.