ADVERTISEMENT

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

Google is a huge fan of hiding games and tricks, called Easter eggs , in its services.

google sheets pride month
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.

ADVERTISEMENT

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.

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.

ADVERTISEMENT

See Also:

SEE ALSO: The 23 most powerful LGBTQ+ people in tech

FOLLOW BUSINESS INSIDER AFRICA

Unblock notifications in browser settings.
ADVERTISEMENT

Recommended articles

Africa's giants play tug of war for the top economic spot

Africa's giants play tug of war for the top economic spot

Morocco is making giant strides to become Africa's aviation manufacturing hub

Morocco is making giant strides to become Africa's aviation manufacturing hub

Hackers test their ransomwares in less protected regions like Africa before striking richer nations: Report

Hackers test their ransomwares in less protected regions like Africa before striking richer nations: Report

Top social media platforms used for agriculture in Kenya - Survey

Top social media platforms used for agriculture in Kenya - Survey

African countries with the fastest-growing military strength in 2024

African countries with the fastest-growing military strength in 2024

3 African countries could play host to Russian diplomatic missions

3 African countries could play host to Russian diplomatic missions

Trends in online casino gaming in New Zealand

Trends in online casino gaming in New Zealand

10 African countries with the highest number of migrants

10 African countries with the highest number of migrants

PHOTOS: Inside the hostel in Rwanda set to house migrants from the UK in July

PHOTOS: Inside the hostel in Rwanda set to house migrants from the UK in July

ADVERTISEMENT