- slide 1 of 11
Depending on your preferences, you can rotate the full text 90 degrees clockwise or counterclockwise to make text vertical, or you can stack non-rotated characters on top of one another, which is the method used in this example.
As an example, say you have a lengthy text field that repeats for multiple rows. By making the text vertical, you not only save screen and print space, but the relatedness of the data is more obvious by applying a single label to a block of text.
1. Highlight the cells containing the text you want vertical.
- slide 4 of 11
- This example changed several formatting options:
- Horizontal Text Alignment: This option controls where text appears horizontally in the cell. By making it centered, any empty horizontal space is evenly distributed on either side of the text. This option is no different than centering text from the Home tab’s Alignment group.
- Vertical Text Alignment: Similarly, this option controls where text appears vertically. In this example, the text will be centered vertically in the cells.
Wrap Text: Checking this option allows text to wrap to the next line or column, assuming there’s not enough space to display all the text vertically. The example text is lengthy, so enabling this option is a must; otherwise, excess text is either truncated or forces the rows to messily expand.
TIP: For more control over wrapping, insert hard returns between words by pressing Ctrl-Enter at your preferred wrapping point when entering or editing the text.
Merge Cells: Checking this option combines all the highlighted cells into one large cell. Only text in the upper left cell is kept; all other text is discarded. In the example, this is exactly what you want.
4. Click OK to the warning regarding the merging of cells.
- slide 5 of 11
Now you are ready to apply the vertical text affect.
5. Click the Orientation button from the Home tab’s Alignment group and select Vertical Text. This option stacks each character, rather than rotating the text. The other options, Rotate Text Up or Rotate Text Down, turn the text counterclockwise or clockwise, respectively.
- slide 6 of 11
- slide 9 of 11
In this example, the row height was originally 15. By changing it to 16, you only slightly change the row heights, but because the change is applied to every highlighted row, it’s enough to accommodate the lengthy vertical text.
TIP: You might need to experiment for the best results. If you don’t like the results, press Ctrl-Z to undo the change and try again.
9. Click and drag the column divider to make the vertical text’s column narrower.