If you often have those Excel tables where you have narrow columns but the title has a group of words, then word wrapping does not always work for the best presentation. On scenarios like this, changing the text direction or orientation within the cell would help a lot.
Different Text Orientation in Excel Cells
So how to change the text direction in Excel cells?
In Excel from Office 2007, this formatting is quite simple as it is available in the Alignment section under Home tab. Choose the cells where you want to change the text orientation click the Orientation button.
Choose the orientation direction that you prefer. The available ones are Angle Counterclockwise (45 degrees), Angle Clockwise (45 degrees), Vertical Text, Rotate Text Up, and Rotate Text Down. But if you want to revert back to regular orientation, click Format Cell Alignment.
Choose the Alignment tab and on the right side you will find the Orientation box. Change it to 0 to revert back to the regular orientation. You can also give custom angle value in the box to get the preferred orientation.
In Excel 2003, choose the cells where you want to change the text direction. Right click and choose Format Cells. This will open the same box as Format cell alignment in Excel 2007. Choose the alignment tab and change as per your need.
0 Responses to “How to Change Text Orientation in Excel Cells?”