Excel for gaianation.net 365 Excel for gaianation.net 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 More...Less
*

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

You are watching: Rotate the text in excel 45 degrees

Change the orientation of text in a cell

Select a cell, row, column, or a range.

Select Home > Orientation , and then select an option.

You can rotate your text up, down, clockwise, or counterclockwise, or align text vertically:

Rotate text to a precise angle

Select a cell, row, column, or a range.

Select Home > Orientation  > Format Cell Alignment.

Under Orientation on the right side, in the Degrees box, use the up or down arrow to set the exact number of degrees that you want to rotate the selected cell text.

Positive numbers rotate the text upward. Negative numbers rotate the text downward. 

Align a column or row

Begin by selecting the cell or cells you want to align. You can align text in a single cell, a range of cells, a row or rows, a column or columns, or the entire worksheet. (Use Ctrl+A to select all cells.)

Select the cells you want to align.

On the Home tab, in the Alignment group, select a horizontal alignment option:

Align Left

Center

Align Right

On the Home tab, in the Alignment group, select a vertical alignment option:

Top Align

Middle Align

Bottom Align


Rotate text

We"re sorry. Excel for the web doesn’t have the font orientation option for you to apply vertical text or rotate text in an angle.

To express your interest in having this feature in Excel for the web, please go to the Visio Suggestion Box and click the Vote button. 

If you have the Excel desktop application, you can use it to open your workbook and rotate text there.

Align text

The alignment options let you define the placement of text within a cell on the horizontal axis and on the vertical axis.

Select a cell, row, column, or a range.

On the Home tab, in the Alignment section, select an alignment option:

Top Align

Middle Align

Bottom Align

Align Left

Center

Align Right

Indent text

You can indent text or undo an indent.

Select a cell, row, column, or a range.

On the Home tab, in the Alignment section, select an indent option:

Increase Indent

*
shifts text rightward.

Decrease Indent 

*
shifts text leftward.


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

Change the orientation of text in a cell

Select a cell, row, column, or a range.

Select Home > Orientation , and then select an option.

You can rotate your text up, down, clockwise, or counterclockwise, or align text vertically:

Rotate text to a precise angle

Select a cell, row, column, or a range.

Select Home > Orientation  > Format Cell Alignment.

Under Orientation on the right side, in the Degrees box, use the up or down arrow to set the exact number of degrees that you want to rotate the selected cell text.

Positive numbers rotate the text upward. Negative numbers rotate the text downward. 

Align a column or row

Begin by selecting the cell or cells you want to align. You can align text in a single cell, a range of cells, a row or rows, a column or columns, or the entire worksheet. (Use ⌘+A to select all cells.)

Select the cells you want to align.

See more: Where Are The Pigment Molecules Located ? A) Between A) Between

On the Home tab, select a horizontal alignment option:

Align Left

Center

Align Right

On the Home tab, select a vertical alignment option:

Top Align

Middle Align

Bottom Align


Need more help?

You can always ask an expert in the Excel Tech Community or get gaianation.net in the Answers community.