Instantly sync your data from Sheets → Docs or Slides
Whether you’re preparing a client presentation or sharing sales forecasts, keeping data up-to-date can be time-consuming, especially if you need to update charts or tables in multiple sources. This is why we made it easier to programmatically update charts in Docs and Slides last year.
Now, we’re making it simple to keep tables updated, too. Just copy and paste data from Sheets to Docs or Slides and tap the “update” button to sync your data.
Even more Sheets updates
We’re constantly looking for ways to improve our customers’ experience in Sheets. Based on your feedback, we’re rolling out more updates today to help teams get work done faster:
Keyboard shortcuts: Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”
Upgraded printing experience: Preview Sheet data in today’s new print interface. Adjust margins, select scale and alignment options or repeat frozen rows and columns before you print your work.
Powerful new chart editing experience: Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads.
More spreadsheet functions: We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also supports statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”
Increased support for charts in the Sheets API: Use the API to programmatically generate most charts with support for dozens of new operations.
These new features in Sheets are rolling out starting today. Learn how Sheets can help you find valuable insights.
One last thing—so that we can focus our efforts on the improvements to charts outlined above, we’re also deprecating one of the lesser-used chart types: the Motion chart. Beginning in July 2017, you will no longer be able to insert or create Motion charts, and, in September 2017, you will no longer be able to edit them.
No earlier than December 2017, any Motion charts still in Sheets will become static images and no longer update when their corresponding data changes.
In the Google Cloud Community, connect with Googlers and other Google Workspace admins like yourself. Participate in product discussions, check out the Community Articles, and learn tips and tricks that will make your work and life easier. Be the first to know what's happening with Google Workspace.
On the “What’s new in Google Workspace?” Help Center page, learn about new products and features launching in Google Workspace, including smaller changes that haven’t been announced on the Google Workspace Updates blog.