Google Sheets are about to become even more chaotic and unwieldy

spreadsheet
(Image credit: Shutterstock / 200dgr)
Audio player loading…

A new era of gargantuan Google Sheets could be coming thanks to a new change made by the company.

In a Google Workspace update blog, the company revealed that it was increasing the cell limit in its spreadsheet software from up to five million cells to up to ten million cells.

The new limit isn't just for newly-created files either, with Google noting that it will also be available for existing and imported files, meaning you can expand to your heart's content. 

Giant Google Sheets

"Over the course of the last four years, we’ve been steadily increasing the cell limit in Google Sheets: from 2 million to 5 million in 2019 and now to 10 million," the blog post (opens in new tab) read. "We hope this and future increases give users the ability to work with their data on a much greater scale in Google Sheets."

The update is rolling out now to all users, and won't require any special admin control or action to activate. It's available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers.

The feature is the latest in a series of recent updates to Google Sheets as it looks to boost its offerings for hybrid workers.

This includes the recent addition of intelligent formula suggestions based on the data in question and the user’s initial input, taking much of the heavy lifting out of complex formulae.

The software itself also recently saw a cosmetic overhaul to make Google Sheets better for users with smaller screens. The changes saw the menu bar, as well as the right-click menu shortened to better fit on a smaller screen, and to prevent menu items from being hidden off-screen.

Some features were also reorganized and moved to “more intuitive” locations. For example, freezing a row or a column can now be done directly from the right-click menu. Menu items also received new icons, while the descriptions of some items in the menu are shorter.

Mike Moore
Deputy Editor, TechRadar Pro

Mike Moore is Deputy Editor at TechRadar Pro. He has worked as a B2B and B2C tech journalist for nearly a decade, including at one of the UK's leading national newspapers and fellow Future title ITProPortal, and when he's not keeping track of all the latest enterprise and workplace trends, can most likely be found watching, following or taking part in some kind of sport.