Skip to main content

Google Sheets receives massive update w/ formula support, auto-fill, Excel compatibility, more

Hot on the heels of updating the Docs app for Android, Google has just started rolling out an update to Sheets on Android, as well. The update is packed full of changes, both feature-wise and in terms of design. The update comes just days after Google announced it was shutting down Quickoffice on iOS and Android and introduces several features formerly available in the mobile editing app.

As you would expect, the update changes the aesthetics of the app to fit into Google’s new Material Design theme, in addition to of course Android “L.” There is now a floating new document button that allows you to create a new file from anywhere within the app. The update also introduces full support for formulas, something that many power users have been longing for since day one. In previous version of Sheets, you could enter formulas, but it had to be done manually. Now, however, you can select a formula from a list, much like on most desktop spreadsheet apps. The update also introduces the ability to view files that are in the Excel format, in addition to the ability to export files in that format.

Next up, the update finally adds support for charts, including, pie graphs, line graphs, and bar graphs. Although, this comes with a catch, as you can’t edit charts on Android, only view them. Finally, Sheets now finally supports auto-fill. This means, much like on the desktop, you can drag the corner of a cell to auto-fill an area based on your previously entered data.

The update to Sheets on Android is rolling out now through the Play Store, so be sure to keep an eye out for it to hit your device.

(via Android Police)

FTC: We use income earning auto affiliate links. More.

You’re reading 9to5Google — experts who break news about Google and its surrounding ecosystem, day after day. Be sure to check out our homepage for all the latest news, and follow 9to5Google on Twitter, Facebook, and LinkedIn to stay in the loop. Don’t know where to start? Check out our exclusive stories, reviews, how-tos, and subscribe to our YouTube channel