Formatting Cells

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

To change horizontal text alignment:

  1. Select the cells you want to modify.
  2. Select one of the three horizontal Alignment commands on the Home tab.
    • Align Text Left: Aligns text to the left of the cell
    • Center: Aligns text to the center of the cell
    • Align Text Right: Aligns text to the right of the cell
    Aligning Text Left Aligning Text Left

To change vertical text alignment:

  1. Select the cells you want to modify.
  2. Select one of the three vertical Alignment commands on the Home tab.
    • Top Align: Aligns text to the top of the cell
    • Middle Align: Aligns text to the middle of the cell
    • Bottom Align: Aligns text to the bottom of the cell
    Top Aligning Text Top Aligning Text

By default, numbers align to the bottom-right of cells, while words and letters align to the bottom-left of cells.

Using the Format Painter

If you want to copy formatting from one cell to another, you can use the Format Painter command on the Home tab. When you click the Format Painter, it will copy all of the formatting from the selected cell. You can then click and drag over any cells you want to paste the formatting to.

Watch the video below to learn two different ways to use the Format Painter.