Google Workspace Services

Services

Services

Development
Training

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 predictions 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

Google Workspace Services

Google Workspace Services

Euro 2020 Google Sheets Sweepstake

How to remove headers from Google Docs

Add a secondary time zone to Google Calendar