Google Workspace may have just solved hours of cumulative frustration and annoyance with a new addition to its spreadsheet software that utilizes the flexibility of your mouse.
The company has revealed a new feature which will allow users to autofill by dragging or double clicking a selection handle using a mouse in the Google Sheets Android app.
The new feature is available to users on Rapid Release domains now, with other users set to see it soon – but it seems like a genuine game-changer from Google that could be a huge productivity boost.
Google Sheets mouse autofill
It sounds so simple that we can't quite figure out why this hasn't always been a thing – and in a gif on its Google Workspace updates blog (opens in new tab), the company shows that the new tool really is that easy to use – you simply click on the highlighted field, then hold and drag over the boxes you'd like to expand to – and voila.
Google says that the launch comes shortly after the roll out of full mouse support for Google Sheets on Android, and is the latest in a series of improvements for users to enjoy.
Recently, the spreadsheet software, part of the Google Workspace office suite, said it would begin offering named functions, allowing users to create high-performance custom functions that support built-in Sheets formula constructs.
Users will also be able to import named functions from existing Sheets files, allowing them to use functions created in one Sheets file in a different Sheets file, boosting reusability across spreadsheets.
The company also recently launched “intelligent corrections” for formulas in Google Sheets, context-aware fixes that it says help you improve and troubleshoot many different kinds of formulas.
English
Arabic
Belarusian
Bengali
Bosnian
Bulgarian
Chinese (Simplified)
Croatian
Czech
Danish
Dutch
Estonian
Filipino
Finnish
French
Georgian
German
Greek
Gujarati
Hausa
Hebrew
Hindi
Hmong
Hungarian
Igbo
Indonesian
Italian
Japanese
Javanese
Kazakh
Korean
Kurdish (Kurmanji)
Kyrgyz
Lao
Latvian
Lithuanian
Macedonian
Malagasy
Norwegian
Persian
Polish
Portuguese
Punjabi
Romanian
Russian
Serbian
Slovak
Slovenian
Spanish
Swedish
Thai
Turkish
Ukrainian
Vietnamese
Yoruba