Docs

Tips
Docs

Tips

Drive
Gmail
Docs
Overdrive
Calendar
Sheets
Sites
Chrome
- How to remove the Reading list button from Chrome
Contacts
Slides
Chat
Meet
Forms
Keep
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 Google Workspace and everything Google, so we’re delighted to share the latest insights, tips and tricks with you.

Latest Tips

Euro 2020 Google Sheets Sweepstake

The Euro 2020 Sweepstake is a fun way to predict match outcomes, compete with your family, friends or colleagues and add to the excitement of the tournament. The spreadsheet will automatically calculate the points for each player so you can see at the glance who’s in the lead. Here’s how to use our Euro 2020 Sweepstake template in Google Sheets: Make a copy of our Sheet . Personalise the sheet with player names. Fill in match predictions and keep on top of who’s winning! The sheet uses Protected Ranges to add some restrictions: A protected range across columns A to F so you have control of the matches and results. A protected range in the user header cells so only you can add users and Points cannot be changed. We recommend adding the following to your own sheet: A protected range per user column - so only the user can add their predictions. Protect each prediction once it is final by adding a protected range called “Lock in Predictions” across the user columns. You can do this after the matches have started to stop people changing their predictions. To add a Protected Range: Select the range or column. Right click and select Protect range. From the right hand panel, click Set permissions. From the pop up window you can choose who can edit that specific column. Remember to update fixtures and result as results come in. You can also add extra player columns, but make sure to also copy the formulas from any existing “Player” column. Have fun!
How to remove headers from Google Docs

The header section at the top of a document can be used to display information such as titles, page numbers, dates or other facts. However, you can remove this section if the document you’re working on doesn’t require one. Here’s how to remove the header from a Google Docs on a computer: Double click the header. Click ”Options”. Click “Remove header”. To remove a Google Docs header on iPhone or Android: Open the document in the Google Docs app. Tap the three dots from the top right corner of the screen. Turn on “Print layout”. Tap in the header and delete the text.
Add a secondary time zone to Google Calendar

Managing meetings or events with people from outside your time zone can be tricky. Thankfully, there’s a way to check at a glance the difference between time zones. Here’s how to add a secondary time zone to your Google Calendar: Go to calendar Settings by clicking on the gear icon. In the “Time zone” section (under General > Language and region), tick the box that says “Display secondary time zone”. Select a time zone from the “Secondary time zone” drop down. Optionally you can add a label to each time zone. Changes are saved automatically. When you go back to your calendar, you will notice the second time zone on the left side of your calendar, next to the primary one.

Powered by Overdrive

Tips
Tools
Services
- Development
- Training
Add-on Apps
Blog
- Workspace Tips: New brand and new offerings

Docs

Docs

Euro 2020 Google Sheets Sweepstake

How to remove headers from Google Docs

Add a secondary time zone to Google Calendar