Formatting

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.

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 or get support in the Answers community.

See Also

Format text in cells

Format numbers

Format a date the way you want

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×