Google Workspace Changes

Enhanced commenting, chart creation, and font support in the Google Sheets app for Android.

The Google Sheets app for Android now allows users to add new and reply to existing comments. Chart creation is improved with automatic data selection expansion and three recommended chart types based on selected data. Additionally, users can now view over 400 new fonts that were previously added to Sheets on the web.

Paste special feature added to Sheets Android app

The Sheets Android app now supports the 'Paste special' feature, enabling users to copy content and paste only specific elements such as values, formatting, formulas, data validation, or conditional formatting, as well as the ability to transpose content.

View existing filters in the Sheets Android app

Filters applied to data in Google Sheets on the web are now visible within the Sheets Android app, providing users with clarity on whether they are viewing filtered content.

Hide toolbars and headers when scrolling or zooming in Sheets Android app

The Google Sheets Android app now automatically hides toolbars and headers when a user scrolls down or zooms in on a spreadsheet, allowing more of the content to be visible on the screen at once.

New formatting options for pasting content in Google Sheets.

Google Sheets now offers alternative formatting options after pasting content via a small widget that appears in the bottom corner of the pasted cells. Users can select 'Paste values only' to remove formatting or 'Paste format only' to apply only the cell's style. Additionally, Chrome users can use the shortcut Ctrl + Shift + V to automatically paste values without formatting.

Ability to insert and modify chart types in the Google Sheets Android app.

The Google Sheets Android app has been updated to allow users to insert charts and change their types directly within the mobile application. For example, users can now quickly change a bar chart inserted from Explore into a column chart without needing to use the web version of Sheets.

Partial cell formatting in Google Sheets

Users can now select and apply text formatting to only a portion of the characters within a single cell in Google Sheets on the web and Android app.

Explore in Google Sheets

The Explore feature in Google Sheets (web and Android) automatically analyzes spreadsheet data to create dynamic charts, surface insights, and perform instant calculations.

More intuitive keyboard functionality in Google Sheets for Android

The Google Sheets Android app now automatically launches the alphabetic keyboard when a cell contains text and the numeric keyboard when a cell contains numbers or symbols, while also offering an easy way to shift between the two options.

Autofill in Google Sheets for Android

The autofill feature, which allows users to repeat information or complete a pattern in a spreadsheet, is now available in the Google Sheets app for Android.

Include hidden and filtered data in Google Sheets charts.

Google Sheets now provides the option to include hidden or filtered source data in charts. When users filter or hide source data, a notification appears allowing them to include that data in the chart. This setting can also be toggled within the Chart Editor under the 'Chart types' section by checking or unchecking 'Include hidden / filtered data'. This update also improves the accuracy of imported Microsoft Excel spreadsheets that contain hidden data.

Google Sheets now supports publishing spreadsheets in five additional formats: .csv, .tsv, .pdf, .xlsx, and .ods.

Users of Google Sheets on the web can now publish their spreadsheets in five additional formats beyond the standard web page: comma-separated values (.csv), tab-separated values (.tsv), PDF documents (.pdf), Microsoft Excel spreadsheets (.xlsx), and OpenDocument spreadsheets (.ods). When the generated URL is opened in a browser, the spreadsheet will automatically download in the chosen format.

Insert images into Google Sheets while offline

Users can now insert images into Google Sheets when working offline in the Chrome browser, provided that offline access has been enabled. Any images inserted while offline will be synced once the user regains internet connectivity.

Introduction of protected cell warnings to prevent accidental edits.

To facilitate safer collaboration, Google Sheets now allows owners to set warnings for individuals who attempt to edit certain cells, reducing unintended changes like typos without requiring complex permission settings.

Pivot table enhancements with calculated fields and GETPIVOTDATA function.

Google Sheets has introduced calculated fields to pivot tables, allowing users to apply formulas to pivot table data, and the GETPIVOTDATA function to retrieve specific data from a pivot table.