Formatting Cells

Basic formatting in Excel can customize the look and feel of your Excel spreadsheet. Learn about formatting cells in Excel here.

Formatting text

Video: Formatting Cells in Excel 2010

Launch video!Watch the video (3:23).

Many of the commands you will use to format text can be found in the Font, Alignment, and Number groups on the Ribbon. Font commands let you change the style, size, and color of text. You can also use them to add borders and fill colors to cells. Alignment commands let you format how text is displayed across cells both horizontally and vertically. Number commands let you change how selected cells display numbers and dates.

Optional: You can download this example for extra practice.

To change the font:

  1. Select the cells you want to modify.
  2. Click the drop-down arrow next to the Font command on the Home tab. The font drop-down menu appears.
  3. Move your mouse over the various fonts. A live preview of the font will appear in the worksheet.
    Changing the font Changing the font
  4. Select the font you want to use.

To change the font size:

  1. Select the cells you want to modify.
  2. Click the drop-down arrow next to the font size command on the Home tab. The font size drop-down menu appears.
  3. Move your mouse over the various font sizes. A live preview of the font size will appear in the worksheet.
    Changing the font size Changing the font size
  4. Select the font size you want to use.

You can also use the Grow Font and Shrink Font commands to change the size.

The Grow Font and Shrink Font Commands The Grow Font and Shrink Font commands

To use the bold, italic, and underline commands:

  1. Select the cells you want to modify.
  2. Click the Bold, Italic, or Underline command on the Home tab.
    The Bold, Italic, and Underline Commands The Bold, Italic, and Underline commands