Filling the G-Apps: Vertical Text in Google Spreadsheet

Vertical text in Google Drive is not something that exists yet however you can do within it's standard formatting however you can produce the same effect using a calculation where "LABEL" is the text you want displayed vertically:

  • =ARRAYFORMULA(CONCATENATE((MID( "LABEL", ROW(INDIRECT("YY1:YY"&LEN( "LABEL" ))), 1)&CHAR(10))))

Comments

Popular posts from this blog

5 Common Tech Problems and How to Solve Them

Why Outsourcing IT Services is a Smart Move for Your Business

Cyber Security Awareness 002: Understanding PII (Personally Identifiable Information)