I have a friend on the inside…


Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today



Have you ever seen those spreadsheets or charts where the text isn’t normal?  You know the ones where the text is diagonal, neurosurgeon rheumatologist or vertical, resuscitator 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

  1. Type the text into a cell
  2. Select the cell
  3. On the home tab of the ribbon, rx 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.
  4. 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 😉

Want to know lots of in depth techincal stuff about Microsoft Office?  Well if I can’t answer it, order there are plenty of people at Microsoft who know their stuff!

One of them is Alistair Speirs, generic a Office Technology Specialst at Microsoft Australia.  If you want to dive deep into everything office (beyond the tutorials from yours truely!) then you should check out his blog…

http://blogs.msdn.com/alspeirs/

Check out some of his posts on Business Desktop Deployment, clinic Enterprise Search, Office Busines Applications, OpenXML, and one he stole from me… Random text in Word 🙂

TNP and Alistair go way back… he knows his stuff!

’till next time!
TNP 😉

One thought on “I have a friend on the inside…

  1. Hi there!

    I started using microsoft one note 2007 and one thing is really bothering me.
    In Microsoft Office, if we want to move images by the slightest detail we press the “ctrl” key along with the arrow key as to which direction we have to move the image. Howver in one note, i have searched everywhere but am struggling to find it out. I would be extremely thankful if you could solve this query for me.

    Please Please Please help me out.

Leave a Reply

Your email address will not be published. Required fields are marked *