How to alter text orientation to vertical in Google Spreadsheet document?

Question

Using MS Excel I can go to Format of the cell and choose the text orientation from horizontal to vertical fairly easy. How do I alter text orientation to vertical in Google Spreadsheet document?

Answer 1

1. Select your cell

2. Replace its content with the following formula:

   =ARRAYFORMULA(CONCATENATE((MID( "Text to become vertical"; ROW(INDIRECT("YY1:YY"&LEN( "Text to become vertical" ))); 1)&CHAR(10))))
   

3. Repeat for each cell

Observation: make sure the text you want in your cell is the same in both instances of the formula.

From here: http://www.quikstarts.com/Internet/Google-Docs/how-to-make-vertical-column-headers-in-google-docs/

Answer 2

You have do create it as a drawing. See here for more details on how to create word art.

Answer 3

Place the cursor between two characters, hold down the Ctrl key and press the Enter key to create a line break between the chars.