Sheets

Sheets

Tips
Sheets

Create, edit and collaborate better with these Google Sheets tips and tricks

Tips

Keep
Drive
Gmail
Docs
OverDRIVE
Calendar
Sheets
Sites
Chrome
Contacts
Slides
Hangouts & Chat
Google Plus
Forms
More...

Sign in with Google

Or

We won't share your email address with any third-parties.
Please see our Privacy Policy for further information.

About Us

G Suite Tips is provided by the team at OverDRIVE. We’re passionate about G Suite and everything Google, so we’re delighted to share the latest insights, tips and tricks with you.

Join in

If you’ve got a top tip then share it. We’re all ears!
Suggest a Tip

Latest Tips

Use the new Compare Documents feature to highlight the differences between two docs

Use the new Compare Documents feature to highlight the differences between two docs In this example, we have a Business Process Manual from 2018 and we are using the Compare documents feature to compare it with the new Business Process Manual for 2019. To try this, in your doc go to: Tools > Compare documents Select the file you want to compare your current document to In the Attribute differences to field, enter the name of the person who will be labelled as the author of the changes in the comparison file. Select Compare This will create a comparison file with the differences highlighted as Suggested Edits Guest tip by Jordan Hughes at CloudShed .
Create impressive dashboards using these new Google Sheets features

Create impressive dashboards using these new Google Sheets features Last month Google announced 3 new features to enhance reporting in Google Sheets Themes Using themes, you can apply changes to the format of an entire spreadsheet. This will affect the following: Text font and colour in the sheet, charts, and pivot tables Chart background colour Colour of series on charts Pivot table background To apply a theme, select Format > Theme and choose from a preset theme, or to create a custom theme, select Customise in the top right. Slicers If you create a custom dashboard, you can add a slicer to filter your tables, charts, or pivot tables. Scorecard Charts These can be useful to show KPIs, on your spreadsheet. Now you can really show off in Sheets! Guest tip by Jordan Hughes at CloudShed .
Create team task lists in Keep

Stay organised with team task lists in Keep Google Keep is great to take quick notes in meetings and keep your own personal task lists. It’s also great when you can share those task lists with your team, so you can all stay organised, together! Here’s how to do it: You can find Keep in your G Suite apps menu (it’s a mobile app too) In Keep > Select Title your list and start adding tasks Select and add the email addresses of the people you want to share with Awesome… You now have a live, collaborative task list with your colleagues (it’s also great for shopping lists on your personal Google accounts!) Guest tip by Jordan Hughes at CloudShed .

Tags

Keep Android iOS Migration Scripts Security Admin Images Drive Gmail Docs OverDRIVE Calendar Sheets Sites Chrome Contacts Slides Hangouts Google Plus Forms More

Website Terms of Use | Privacy | GDPR

Disclaimer

The Tools provided here are not supported under any standard support program or service. All Tools are provided AS IS without warranty of any kind.

Refractiv further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the Tools and documentation remains with you. In no event shall Refractiv, its authors, or anyone else involved in the creation, production, or delivery of the Tools be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation, even if Refractiv has been advised of the possibility of such damages.

Show More Show Less

Convert Google Drive and
G Suite content into web pages automatically

Keep Android iOS Migration Scripts Security Admin Images Drive Gmail Docs OverDRIVE Calendar Sheets Sites Chrome Contacts Slides Hangouts Google Plus Forms More

OverDRIVE is a smart site
builder like no other

Discover how to turn Drive and G Suite content into web pages automatically

Register

Say goodbye to
traditional websites

Turn Drive and G Suite content into web pages automatically

Set up a site in minutes

#1 CRM for
G Suite

More...

Drive permissions

Identify and manage the sharing rights of every file from every user on your domain

G Suite Training

Get the most from your G Suite investment,
with a training solution that's just right for you.

© 2019 G Suite Tips

Powered by OverDRIVE

Tips
Tools
Add-on Apps
Blog
Events
Contact