How to Change Text Orientation in Excel Cells?
If you are new here, Subscribe to Full Feeds or by Email or follow us in Twitter and receive free daily updates on Office and Windows Tips, Tricks and Tweaks..
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.
While working in Excel I do something and the letter values which apprear are not those on the keyboard. What am I pressing to do this and how do I rectify the problem I have a Microsoft keyboard.