+

Cookies on the Business Insider India website

Business Insider India has updated its Privacy and Cookie policy. We use cookies to ensure that we give you the better experience on our website. If you continue without changing your settings, we\'ll assume that you are happy to receive all cookies on the Business Insider India website. However, you can change your cookie setting at any time by clicking on our Cookie Policy at any time. You can also see our Privacy Policy.

Close
HomeQuizzoneWhatsappShare Flash Reads
 

There's a fun Easter egg hidden inside Google Sheets that turns your spreadsheet rainbow in honor of Pride Month

Jun 22, 2019, 17:46 IST

Paige Leskin/Business Insider

Advertisement

Google is known for adding fun tricks and games to its services for tech-savvy users and developers to discover. In honor of Pride Month, the tech giant has added a Pride-ful one to make your bland spreadsheets a bit more exciting.

Adding a special function to the A1 cell in Google Sheets will change your spreadsheet from drab black-and-white page to a colorful rainbow sheet celebrating the LGBTQ community. The trick - also called an "Easter egg" - was shared by Ben Collins, a Google Sheets developer who runs a popular weekly newsletter sharing tips and tricks for using Google services.

Read more: 26 games and tricks hidden within your Google search bar

This Pride Month trick relies on the MID spreadsheet formula, a function that allows you to play around with text-based strings of data. But if you're like me, and don't understand how Sheets functions work, there's an easier way to still get the LGBTQ-themed Easter egg.

Advertisement

There's one simple step - just input this code to the A1 cell in your spreadsheet:

=ArrayFormula(TRANSPOSE(MID("PRIDE",ROW(INDIRECT("1:"&LEN("PRIDE"))),1)))

After inputting this string of text, watch your Google Sheets spreadsheet come to life.

Google's Easter egg celebrating Pride Month is a neat trick, but Google hasn't had the best month when it comes to its LGBTQ users and employees. Earlier in June, Google-owned YouTube controversially decided to not remove videos from its platform full of racist and homophobic slurs about a Vox journalist. Google CEO Sundar Pichai and YouTube CEO Susan Wojcicki have both apologized for the decision, but said they're standing by their policies to keep the videos online.

Get the latest Google stock price here.
You are subscribed to notifications!
Looks like you've blocked notifications!
Next Article