Written by The New Paperclip on August 19, 2007 – 4:36 pm
Have you ever seen those spreadsheets or charts where the text isn’t normal? You know the ones where the text is diagonal, or vertical, or on its side? It is a pretty nifty trick you can use to display more information in less space. And in Excel 2007 it is really easy to do.
How to change text orientation in Excel 2007
- Type the text into a cell
- Select the cell
On the home tab of the ribbon, look for the alignment group. There you will find a button with an ‘a’ and a ‘b’ and an arrow all on an angle. That’s the Orientation menu. Click on the little drop down arrow beside it.
- Select one of the quick options to angle your text
If you want to be more specific about the angle of your text, you can select “Format Cell Alignment” and set down to the degree how “slanty” you want your text.
The results are pretty impressive - well your boss will think so and that is all that matters right?
’till next time!
TNP


[…] I’ve learned about a blog that dedicated exclusively to "Tips, Tricks and Tutorials for Microsoft Office 2007." Written by Paul Woods, a former Microsoft employee from Brisbane, Australia, The New Paperclip has lots of great information about the latest versions of not just Word, Excel, PowerPoint, Publisher, Access, and Outlook, but also the programs that aren’t as widely known, including Visio, Project, One Note, Groove. Here’s a sample of the types of tips you can expect to find there: Have you ever seen those spreadsheets or charts where the text isn’t normal? You know the ones where the text is diagonal, or vertical, or on its side? It is a pretty nifty trick you can use to display more information in less space. And in Excel 2007 it is really easy to do. [Keep Reading] […]