Formatting Cells

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

Text alignment

By default, any text entered into your worksheet will be aligned to the bottom-left of a cell, while any numbers will be aligned to the bottom-right. Changing the alignment of your cell content allows you to choose how the content is displayed in any cell, which can make your cell content easier to read.

Click the arrows in the slideshow below to learn more about the different text alignment options.

To change horizontal text alignment:

In our example below, we'll modify the alignment of our title cell to create a more polished look and further distinguish it from the rest of the worksheet.

  1. Select the cell(s) you want to modify.
    Screenshot of Excel 2013Selecting a cell
  2. Select one of the three horizontal alignment commands on the Home tab. In our example, we'll choose Center Align.


    Screenshot of Excel 2013Choosing Center Align
  3. The text will realign.
    Screenshot of Excel 2013The realigned cell text

To change vertical text alignment:

  1. Select the cell(s) you want to modify.
    Screenshot of Excel 2013Selecting a cell
  2. Select one of the three vertical alignment commands on the Home tab. In our example, we'll choose Middle Align.
    Screenshot of Excel 2013Choosing Middle Align
  3. The text will realign.
    Screenshot of Excel 2013The realigned cell text

You can apply both vertical and horizontal alignment settings to any cell.