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

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

5 Common Tech Problems and How to Solve Them

By -
Image
I thought I'd start off 2025 with something simple for everyone, so here are 5 common IT issues you might get at home or work... Technology is an integral part of our daily lives, both at home and in the workplace. However, it can also be a source of frustration when things go wrong. Here are five common tech problems and how to solve them: Slow Internet Speeds Home Restart your modem and router: This simple step often resolves temporary connection issues. Sometimes 10 seconds is needed to clear any cached issues Check for interference: Cordless phones, microwaves, and even baby monitors can interfere with Wi-Fi signals. Try moving your router to a different location. But before moving you can use your mobile connected to the Wi-Fi to see if there's interference between rooms by watch in the signal strength or use a Wi-Fi Analyser App Run a speed test: Use online tools like Speedtest.net to measure your actual internet speed. If it's significantly slower than your plan, c...
Read more

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