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

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

Why Outsourcing IT Services is a Smart Move for Your Business

By -
Image
Owning a small business can be both rewarding and challenging. With tight budgets and limited resources, it can be difficult to prioritise spending and dedicate time to digital tools. However, outsourcing IT services can be a game-changer.   Let's explore four key benefits: Increased Productivity By entrusting your IT tasks to qualified professionals, you empower your employees to focus on their core competencies. This leads to increased productivity and efficiency, ultimately driving business growth. Access to Highly Trained Professionals Outsourcing IT services provides access to a pool of skilled and experienced IT experts. These professionals can handle complex technical issues, ensuring smooth operations and minimising downtime. Enhanced Security In today's digital age, cybersecurity is paramount. Outsourcing IT services offers robust security measures, including round-the-clock monitoring, threat detection, and data protection. This helps safeguard your business from cyb...
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