Directional Text Within Cells

  

Directional Text Within Cells - Say for some reason you wish to enter long names as column headers, this can cause for an unsightly worksheet. Okay, what we will do in this post is to have employee names along the top and days down the side.

So we can either have:

Or:

Which to be honest, neither is acceptable. So how do we fix this?

Easy, select the cells containing the long employee names and right click, select format, then alignment.

Now move the Orientation dial to say 75 degrees, or type 75 into the degrees box, and the text will be formatted as such:

The Orientation may also be set by clicking on Orientation in the home tab, under the alignment group.

www.briancunningham.co.uk
keep learning