Change the format of a cell

Change the format of a cell

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.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Apply Excel Styles 

  1. Select the cells.

  2. Select Home > Styles and select a style.

Modify an Excel Style

  1. Select the cells with the Excel Style.

  2. Right-click the applied style in Home > Styles. Select Modify.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Format text in cells

Format numbers

Format a date the way you want