Filling the G-Apps: Vertical Text in Google Spreadsheet

By -
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

Post a Comment

Popular posts from this blog

Stay COVID Meeting Safe

By -
I've had a number of people asking me recently about using recently popularised Apps due to COVID-19 in personal situations. In my personal opinion, I would steer away from both Zoom and Houseparty in particular, use something that is tried and tested like Messenger , Hangouts , Facetime or WhatsApp and ensure they're up to date as the latter two have also had hacking issues in the past due to people not updating after identified security breaches. Both Apps are very popular at the moment and have had security and privacy concerns raised. Houseparty has been reviewed by security experts which have said: "it's probably safe". It has safe security options but it is up to the end-user to implement them correctly. Having said that if you read the fine print Houseparty uses your personal data and advertising as their income (nothing is free), there have been reports of users having their login details for Netflix and Spotify accounts compromised but these ar
Read more

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

By -
Image
PII (Personally Identifiable Information) What is PII and what should I be aware of? What is PII? In terms of Cyber Security PII (Personally Identifiable Information) is any information associated with the target that could be used as potential leverage for an attack against that individual, an associate, or the company they work for as well as any clients and suppliers the business deals with.
Read more

Filling the G-Apps: Adding/Embedding LucidChart in Google Sites

By -
Image
What is LucidChart LucidChart is a flow-chart web application that can be integrated with Google Apps. It's simple to use once you understand how sharing works between LucidChart users (similar to Drive) and it saves time in generating flow-charts for internal workflow processes, customers, marketing and documentation purposes. Adding/Embedding LucidChart in Google Sites To display a LucidChart document inline on the Intranet you need to complete the following steps: LucidChart Once the document has been reviewed and is ready to share publicly on the Google Site select the "Share" button (top right corner) Select the "Embed" tab and select the "Publish Link" checkbox Look for the code that starts "src=" and select and copy everything the parenthesis: Google Sites  Edit the Site page Select "Insert" from the Site Menu (located at the top left corner under the page name) Under "Gadgets" select "..
Read more