You probably already knew that you can align text vertically and horizontally, but did you know that you can also change the orientation of text within a cell? Keep a lookout for the -> button on the home tab, or look under “Alignment” in the “Format Cells” dialog box.

Notice how the border and fill area changes to match the alignment of the adjoining cell.

Text Wrapping causes text that would fall outside the left or right boundaries of the cell to be continued on subsequent lines within the cell.

VBA to Format Cell Alignment
Selection.Orientation = int
where int [integer] is the degrees of rotation [i.e. 45]

Selection.WrapText = bool
Where bool [boolean] is True or False