---
title: Google Adds New Themes and Tools to Google Sheets
description: The arrival of new tools that will allow enterprise users to create more compelling reports in Google Sheets.
image: https://www.appsadmins.com/hubfs/New%20Themes.png
---

[![appsadmins-svg-rules-1 (2)](https://www.appsadmins.com/hs-fs/hubfs/appsadmins-svg-rules-1%20(2).jpg?width=818&name=appsadmins-svg-rules-1%20(2).jpg "appsadmins-svg-rules-1 (2)")](https://www.appsadmins.com/)

- [Google Workspace](https://www.appsadmins.com/workspacehomepage) 
    - [Google Workspace Free Trial](https://www.appsadmins.com/gsuite-free-trial-5)
    - [Google Cloud Migration](https://www.appsadmins.com/migration-to-g-suite)
    - [Google Cloud Case Studies & White Papers](https://www.appsadmins.com/migration-resources-for-g-suite)
- Grow Your Business 
    - [Chrome Enterprise](https://www.appsadmins.com/enterprisehomepage)
    - [HubSpot](https://www.appsadmins.com/hubspothomepage)
    - [RingCentral](https://www.appsadmins.com/rchomepage)
- [Blog](https://www.appsadmins.com/blog)
- [Testimonials](https://www.appsadmins.com/testimonial)
- [Contact Us](https://www.appsadmins.com/contact-us-apps-admins)

 Menu

[G Suite Admins Blog](https://www.appsadmins.com/blog) > [G Suite Enterprise](https://www.appsadmins.com/blog/topic/g-suite-enterprise)

# Google Adds New Themes and Tools to Google Sheets

[![Lindsay Perry](http://www.coolheadtech.com/hubfs/lindsay-perry.jpg)](https://www.appsadmins.com/blog/author/lindsay-perry)

[Lindsay Perry](https://www.appsadmins.com/blog/author/lindsay-perry) March 18, 2021

#### [G Suite Business Free for 30 Days](https://www.appsadmins.com/gsuite-free-trial)

Sign up for a Free 30 Day Trial of G Suite Business and get Free Admin support from Google Certified Deployment Specialists. No Credit Card Required.

[![Start Free Trial](https://no-cache.hubspot.com/cta/default/189007/54995b89-de21-406b-824b-575c91290ec8.png)](https://cta-redirect.hubspot.com/cta/redirect/189007/54995b89-de21-406b-824b-575c91290ec8)

  

![New Themes](https://www.appsadmins.com/hs-fs/hubfs/New%20Themes.png?width=5760&name=New%20Themes.png)

If you've ever wished that you could get more done in your Google Sheets, then you're in luck. Recently, Google has been implementing a host of updates to the Google Workspace(G-Suite) productivity tools that companies rely on every day to get work done. As part of the Google Cloud Next event in Tokyo, Google announced a wide variety of new security updates to Google Workspace(G-Suite), so that enterprise users can rest assured that their information is safe and secure in the cloud. Additionally, in previous months, we've seen new changes in the Google Workspace(G-Suite) environment that include things like offline editing and Gmail enhancements too. 

Now, for companies who rely on Google Workspace(G-Suite)'s Sheets solution for managing their spreadsheets, there's a selection of new tools to explore too. At the beginning of August 2019, Google announced the arrival of new tools that will allow enterprise users to create more compelling reports in Google Sheets. These solutions include unique Themes, Scorecard charts, and Slicers. All of the tools will make Sheets more interactive, and they build on the new [features for objects](https://gsuiteupdates.googleblog.com/2019/04/new-tools-sheets.html) in Sheets that Google announced earlier this year. 

## **What's New to Google Sheets?**

As many Google Workspace(G-Suite) users already know, Google Sheets isn't just for data entry and formulas. There has always been the option within Sheets to explore things like graphs too. With the new features, those graphs and reports can become even more intuitive and immersive. For instance, with Themes, users will be able to customize the way that their spreadsheets look and feel. This means that you can add a range of charts, tables, and cells into your Sheets environment to drive better consistency for your team. The Themes options differ from previous templates that allowed businesses to create pre-made spreadsheets for budgets, schedules, and other purposes. 

The initial Themes upgrade comes with a wide selection of presets already available to choose from. However, there's also the option to create custom themes too. At the right hand side of your Sheets page, you can pull out an additional functionality panel, where you'll be able to see previews for each design available. If you want to apply a preset theme, all you need to do is go into the Format menu, then click on Theme to choose the option that's right for your team. To create a custom theme, just click on Customize instead. 

Slicers are another new feature that you'll be excited to see in the Sheets environment. These are unique drop-down fields in the Sheets environment that give you a new way [to filter dashboards and reports](https://support.google.com/docs/answer/9245556) according to specific values and conditions. 

The third and final update recently made to Google Sheets comes with Scorecard charts - the solution that allows users to display key metrics within their spreadsheets. You can use these scorecards to call out key statistics or KPIs within your sheet. What's more, there's also the option to show your statistic in comparison to other numbers. This makes it easier to illustrate how things have changed or evolved in your workplace over time. 

## **Creating Immersive Reports**

The new Google Sheets solutions join copy-and-paste images in Sheets, Guides, and formula-backed charting options inserted from Answers that Google previously announced in 2019. All of these upgraded tools come together to help businesses generate more engaging and informative documents for their teams, designed to improve productivity and drive more informed business decision-making. 

In a world where businesses need more help than ever staying agile in the workplace, the updates to Sheets are a valuable addition to the Google Workspace(G-Suite) roadmap. Themes in Google Sheets, as well as the other tools mentioned above are all rolling out to the productivity suite immediately. 

Notably for Google Workspace(G-Suite) admins, the new features in Sheets will be switched on by default. You will need to follow the instructions provided by Google if you want to turn this functionality off for your team members in the months to come. 

 

Ready to get started? Our Cloud Solutions Specialists at Apps Admins are ready to serve your company's work from home needs.

[![Contact Us ](https://no-cache.hubspot.com/cta/default/189007/fcecc901-af47-4914-b270-7aa97d18f606.png)](https://cta-redirect.hubspot.com/cta/redirect/189007/fcecc901-af47-4914-b270-7aa97d18f606)

 

 

 

- <http://twitter.com/share?url=https://www.appsadmins.com/blog/google-adds-new-themes-and-tools-to-google-sheets>
- <http://www.facebook.com/sharer.php?u=https://www.appsadmins.com/blog/google-adds-new-themes-and-tools-to-google-sheets>
- <https://www.linkedin.com/shareArticle?mini=true&url=https://www.appsadmins.com/blog/google-adds-new-themes-and-tools-to-google-sheets>
- [mailto:%20?body=https://www.appsadmins.com/blog/google-adds-new-themes-and-tools-to-google-sheets](mailto:%20?body=https://www.appsadmins.com/blog/google-adds-new-themes-and-tools-to-google-sheets)
- #AppsAdmins

### 0 Comments

[![appsadmins](https://www.appsadmins.com/hubfs/Group%20of%20business%20people%20in%20office%20working%20on%20project-1.jpeg)](https://www.appsadmins.com/blog/top-3-cs-to-manage-your-business-online-with-google-workspace)

[G Suite Enterprise](https://www.appsadmins.com/blog/topic/g-suite-enterprise), [Collaboration](https://www.appsadmins.com/blog/topic/collaboration)

## [Manage Your Team Online with Google Workspace](https://www.appsadmins.com/blog/top-3-cs-to-manage-your-business-online-with-google-workspace)

[![black-board-min](https://www.appsadmins.com/hubfs/Goodbye.png)](https://www.appsadmins.com/blog/goodbye-google-assistant-reminders-hello-priority-pages-and-workspaces)

[G Suite Business](https://www.appsadmins.com/blog/topic/g-suite-business), [G Suite Enterprise](https://www.appsadmins.com/blog/topic/g-suite-enterprise)

## [Goodbye Google Reminders, Hello Priority and Workspaces](https://www.appsadmins.com/blog/goodbye-google-assistant-reminders-hello-priority-pages-and-workspaces)

[![g-mail-business-encryption](https://www.appsadmins.com/hubfs/Encrypting%20Your%20Emails%20Comparing%20the%20Top%202%20Options%20for%20Google%20Workspace.png)](https://www.appsadmins.com/blog/-encrypting-gmail-the-top-2-options-for-g-suite-business-customer)

[G Suite Business](https://www.appsadmins.com/blog/topic/g-suite-business), [G Suite Enterprise](https://www.appsadmins.com/blog/topic/g-suite-enterprise), [Security and Governance](https://www.appsadmins.com/blog/topic/security-and-governance)

## [Encrypting Your Emails: Comparing the Top 2 Options for Google Workspace](https://www.appsadmins.com/blog/-encrypting-gmail-the-top-2-options-for-g-suite-business-customer)

![nextgen-2016-crn-1](https://www.coolheadtech.com/hubfs/nextgen-2016-crn-1.jpg "nextgen-2016-crn-1")

![nextgen-2017-crn](https://www.coolheadtech.com/hubfs/nextgen-2017-crn.jpg "nextgen-2017-crn")

![nextgen-2018-crn](https://www.coolheadtech.com/hubfs/nextgen-2018-crn.jpg "nextgen-2018-crn")

<https://linkedin.com/company/coolhead-tech> <https://twitter.com/coolheadtech> <http://youtube.com/coolheadtech>

Copyright © 2020 Apps Admins

#### Google Cloud Services

- [Start a Google Workspace Free Trial](https://www.appsadmins.com/gsuite-free-trial)
- [Transfer Google Workspace Billing](https://www.appsadmins.com/transfer)
- [Add a Google Workspace User](https://www.appsadmins.com/collections/g-suite)
- [Get Google Workspace Admin Support](https://www.appsadmins.com/collections/apps-administration)

#### Customer Service

- [Contact us](https://www.appsadmins.com/contact)
- [FAQ](https://www.appsadmins.com/blog/evolving-the-enterprise-why-choose-g-suite)
- [Terms](https://www.appsadmins.com/blog/common-g-suite-migration-terms-to-know)

#### [Contact](https://www.appsadmins.com/contact)

[Apps Admins](https://meetings.hubspot.com/meet-with-marvinm/appsadmins)  
15105 John J. Delaney   
Suite D-124  
Charlotte, NC 28277  
(866)-249-7313

```json
{
  "@context" : "http://schema.org",
  "@type" : "NewsArticle",
  "author" : {
    "@type" : "Person",
    "name" : "Lindsay Perry"
  },
  "dateModified" : "March 18, 2021",
  "datePublished" : "March 18, 2021",
  "description" : "The arrival of new tools that will allow enterprise users to create more compelling reports in Google Sheets.",
  "headline" : "Google Adds New Themes and Tools to Google Sheets",
  "image" : {
    "@type" : "ImageObject",
    "height" : 2544,
    "url" : "https://www.appsadmins.com/hubfs/New%20Themes.png",
    "width" : 1272
  },
  "mainEntityOfPage" : {
    "@id" : "https://google.com/article",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "https://www.coolheadtech.com/hubfs/gcp-apps-admin.png",
      "width" : 600
    },
    "name" : "Coolhead Tech"
  }
}
```