Rotate or align cell data in Excel 2016 for Windows

If you want to change the way data appears in a cell, you can rotate the font angle or change the data alignment.

Row of text roated at various degrees.

  1. Select the cell or range of cells containing the text you want to rotate.

  2. On the Home tab, in the Alignment group, click Orientation Button image , and then select the rotation angle that you want.

    The font orientation options on the Home tab

Change data alignment in a cell

  1. To move the position of data in a cell, click the Home tab, and then use the alignment options.

    Excel  Ribbon Image

  2. Select the cell containing the data you want aligned, and then choose from the following alignment options:

    • Vertical alignment: Click Top Align Button image , Middle Align Button image , or Bottom Align Button image .

    • Horizontal alignment: Click Align Left Button image , Center Button image , or Align Right Button image .

    • To move data closer to the left cell border, click Decrease Indent Button image .

    • To move data further away from the left cell border, click Increase Indent Button image .

    • Wrap the text in a cell: Click Wrap Text.

    • For additional text alignment options, click Dialog Box Launcher Button image in the Alignment group. On the Alignment tab, choose the options you want, and then click OK. For example, to justify text in a cell, click Justify in the Horizontal box.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!