Google Workspace Changes

Group data by time frame in Google Sheets pivot tables.

When creating pivot tables in Google Sheets, users can now group their data by specific time frames, such as week, month, or year, to facilitate better temporal analysis of their data.

Ability to add checkboxes in cells in Google Sheets.

Google Sheets has added the ability to insert checkboxes directly into cells, making it easier for users to create checklists and track task completion within their spreadsheets.

Expanded options for row and column grouping in Google Sheets.

Google Sheets now provides more options for grouping rows and columns, enabling users to organize and manage their data more effectively.

Added printing page breaks and custom paper sizes to Google Sheets.

Google Sheets has introduced new printing capabilities, allowing users to add printing page breaks and define custom paper sizes to better control the layout of their printed documents.

Record macros in Google Sheets to automate repetitive tasks.

Google Sheets now allows users to record macros in the cloud to automate repetitive tasks without needing to write code. The macro recorder automatically converts actions into Apps Script, which can be edited directly for updates. Because these macros are cloud-based, teams can run them simultaneously without interrupting other collaborators working in the same sheet.

Braille support added to Google Sheets

Google Sheets now supports Braille displays, enabling users to read and edit cell contents and navigate between cells. This feature is currently available on Chrome OS using the ChromeVox screen reader.

Google Sheets introduces intelligent pivot table suggestions, formula suggestions, and enhanced data analysis tools.

Google Sheets is adding several AI-powered and analytical features to help users uncover insights. This includes intelligent pivot table suggestions via the Explore panel and natural language processing, machine-learning-based formula suggestions, a refreshed pivot table UI with customizable headings, new pivot table calculation options (such as showing values as a percentage of totals), the addition of waterfall charts, and improved importing of fixed-width formatted data files.

Comments in the Google Sheets and Slides apps for Android and iOS

Users can now add new comments and reply to existing comments within the Google Sheets and Slides mobile apps for Android and iOS, bringing parity with the Google Docs mobile apps.

Google Sheets functions are now available in users' preferred languages.

Google Sheets now supports displaying functions in the user's preferred language for English and 21 other supported languages across both web and mobile platforms. New users will see functions in their preferred language automatically, while existing users can choose whether to keep functions in English or switch to their preferred language via the Spreadsheet settings in the File menu.

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.