Vice-grip or not, Google sure has created numerous products and services to help everyone, whether it’s for personal or business use.
Each Google product - Drive, Keep, Docs, Sheets, Photos, Calendar, Gmail etc - has a streamlined interface fitted with features that boast of high-end intelligence and security (it’s Google, you shouldn’t expect less).
Seeing that a number of Formplus users are Drive-dependent, thanks to our native Sheets integration, we decided to compile a list of Hacks and Tricks to boost your productivity - whether it’s at work, school or even in your personal life.
This list deals majorly with 4 of the G Suite products - Docs, Sheets, Drive and Gmail. Subsequently, we will look into how to work smarter using other Google products.
You might be so used to Microsoft Word to not want to use another application but then, it’s safe to say that Google Docs provides most of the functionality of Word, with some extras. Google Docs can be used on any browser but to get the most out of it, it’s best to use it with the Google Chrome browser so you can make use of Chrome Extensions as well.
Let’s say your colleague is reviewing a portion of a really long document you are working on and you’ll like to see their cursor in real time, simply click their avatar in the top right corner of the page.
You don’t have to use “Control + F” (Windows) or “Command + F” (Mac) or do a long scroll to find what portion the person is working on currently.
You can use any of these templates or start out with a blank page and handle all of your own formatting.
You see that Add-ons menu? The one that you have probably ignored more times than you care to admit? Yes, that one. Do you know there is so much you can actually achieve with Google Docs Add-ons?
Explore the wide variety of tools available for tasks like document analysis and fine-tuning. For example, there is a Screenplay formatter, a rhyme finder, a document to form converter and so much more. There’s even an add-on named Revision history analytics, and with it you can see the proportion of collaborative efforts each user has contributed to a Google Doc. It automatically creates charts and summaries in order to visually understand all users' interactions (or lack thereof) made on the document.
If you have a particular phrase or string that needs to be typed repeatedly, create your own shorthand text to help deal with it. From the “Tools” menu, click “Preferences” and type in a shorthand in a new “replace” field and then add the full-length text to the adjacent field.
You can do other things like disable “Automatically capitalize words”, or “suggest contacts in comments” and any other shortcuts.
Rather than printing out docs before signing them physically, E-signatures save you the multi step process that maybe required when filling multiple documents.
They also save you time - that would have been spent on printing out docs, physically signing them, scanning them back to the PC and then emailing them out.
To create one, go to the 'Insert' menu, select “Drawing”, and then the “Scribble” option. From there you can draw your signature.
Google Docs has speech typing to help users write and edit text with simple voice commands. For example, users can add punctuation by saying “comma,” “period,” or highlight a word by saying “highlight” and “delete” to remove a word.
To use this feature, go to “tools” then “voice typing”. A small window with a microphone icon will appear and when you asked to allow access to your microphone, click “allow.” The microphone will turn red once it’s working and the words you’re speaking will appear on the page.
Rather than switch between tabs you can hyperlink text right from Google Docs using the Search function.
Simply select the preferred text and click on the Hyperlink icon on the taskbar; Google will do a quick search for relevant links but you can use “find more” to refine your search. If you have a preferred URL, paste it in and click “Apply” when you’re done.
Google Docs offers offline document creation and editing for all users. Once you ”Enable offline syncing”, you will be able to download files to your devices and edit them offline. By the time internet connection is re-established, offline Docs will automatically sync and the files will be updated.
On the Docs home page, click the left menu option which is displayed as three horizontal lines, then select settings and enable offline syncing.
This feature makes it easy to navigate through a very lengthy document, allowing you to skip ahead, or fall back, rather than scrolling through the document and guessing where you left off. Just like a table of contents, the outline tool sticks around the left-hand panel of the document as you scroll through.
To use document outline: Select the text you want to make a heading and on the toolbar styles menu, click Normal text. From that menu, click a heading style. This heading will then be added to the outline. You can choose to show/hide the outline like this: Select View > Show Document Outline. The outline tool will appear in the left-hand panel of your Google Doc.
The Google Keep and Docs integration makes it easy to keep notes for a document you are working on. All you need to do is record your notes, lists and drawings in Keep on Android, iOS, Chrome or the web. Then while in Docs on the web, access the Keep notepad via the Tools menu. Your Keep notes will appear in a side panel within Docs.
Here are a few tips to working with Google Keep directly in Docs:
For any enterprise whose aim is global service and reach, you will be pleased to know that Google Docs also supports communication in multiple languages.
To translate a document into another language within Google Docs, go to the “Tools” tab and then select “Translate document”. Alternatively, you can select the text, copy it, then paste it into the Google Translate service on the web (translate.google.com) or in the mobile app.
Previously, it was believed that Google Sheets did not have the functionality that Microsoft Excel provided but, as at 2018, that paradigm has shifted. With Google Sheets you can collaborate with non-Google users without having to convert to Sheets. Amazing!
As a Form builder with Google Sheets integration, we understand how easy it is to collect and manage data with Sheets, and Forms. We’ve even talked about it previously - “How you can get more from Google Sheets add-ons” and “How to work better with Google Sheets”.
Here are some more hacks to help you work better in Google Sheets.
Like most software these days, Google Sheets has a number of keyboard shortcuts that can make you more efficient.
Now you don’t need to cram all of them, just keep note of the basics and call up a list of all possible keyboard shortcuts for Google Sheets. Use cmd + / (⌘ + / ) on a Mac, or ctrl + / on Windows, to bring them up.
It’s not all that easy to insert an image into Google Sheets - if you click “Insert -> Image”, an image appears over the top of your spreadsheet rather than neatly placed in a cell.
To insert an image into a cell, select the desired cell, then type =image("URL of the image you want to insert"). The image will retain its default aspect ratio while adapting to the cell size, but here are some formatting options so you can get the image/cell the size you want:
This trick is especially useful when you are collaborating with others from different parts of the world. Use the “DETECTLANGUAGE( )” formula to identify languages. The formula will return a two letter language code and you can find the full list of language codes can be found here.
You can also translate text from one language to another with the “GOOGLETRANSLATE( )” formula. This formula has three parts – text to translate, the current language of the text, and the language you want to translate into.
Previously, you had to use an add-on to insert a Google Sheets chart to Google Docs but now you can do this without one.
Navigate to Insert > Chart in the document you are working on in Docs; select the “From Sheets” option. With this, you will be able to view of all your Google Sheets (personal, and shared). An error message will pop up if you select a Sheet that doesn’t contain a chart.
If you make changes to the data used in creating the chart, it will update automatically in Google Docs, so there’s no need to manually maintain two charts.
You can create a custom Google Map with data from Sheets. This is very useful for tracking customer location and also spotting areas of convergence relating to your business.
Go to “Add-ons” and download the 'Mapping Sheets' add-on, enter address data into the Sheet (If you’re doing this with a Formplus form, it is even easier). Click 'add-ons' then 'Mapping Sheets' and finally 'start mapping'.
If you are collecting a large amount of data with Sheets, make use of the “Conditional Formatting” feature to highlight bits of data.
Apply a Color Scale to your conditional formatting to emulate a heatmap; set different shades of the same colour or include your own custom colour scale to highlight high and low values. This will make it easier to identify which data to focus on.
To do this, input and select data in Google Sheets, go to the “Format” tab and click “conditional formatting”. A side-panel will open up and if you select “Colour Scale” you'll be able to pick a colour for the “minpoint”, “midpoint” and “maxpoint”. Click done when you finish adding rules.
Your business, no matter the size or function, could find a number of uses for QR codes. They are very useful in offering product details, contact details, event details etc - basically provide more information. Google Sheets lets you generate QR codes with any input you like.
With this formula:
A2 is the cell with the URL or text you want to use to create your QR code.
No more going to meetings and presentations without double checking that spreadsheet. Google Sheets can spell-check entire sheets or individual cells for errors.
Highlight the chosen area and go to “Tools”, from there click “Spelling” and it will open a panel with a familiar spell check interface. If you want to spell check the entire sheet, don’t highlight anything.
Now you can set custom page breaks in a Google sheets spreadsheet.Hit (CTRL + P) or (CMD + P) to print and on the Print settings page, click the blue text that says “Set custom page breaks.”
A preview pops up to show you how Google Sheets thinks your pages should be broken. Hover your mouse to adjust the default page breaks; when you’re done confirm the page breaks and then print it the way you want.
Google recently introduced the ability to add checkboxes to cells option to Sheets. For those who need to check multiple checkboxes at once, you’ll discover that it is time consuming and counter productive.
Rather than click until all the boxes are checked, you can check multiple checkboxes with the space bar. Highlight your preferred range of checkboxes and press the spacebar. All checkboxes within that range will be checked as true.
Let’s say you need to format new data imports or build the same chart across multiple sheets of data. Rather than manually repeat the same steps over a couple of hours, the Google Sheets macro recorder lets you record those actions and play them back on command.
From the Tools menu, select Macros > Record Macros. Perform the function(s) you want to record. The Record Macro tool then records each click you make (you can practice or write down the steps before you start recording). Click Save when you’re done, name the new macro, and click Save again. Sheets will then add the new macro as an option on the Record maco menu.
You can also customize how your spreadsheet appears when you print it. This means you can print a spreadsheet, single sheets, or specific cells, on the exact size of paper you prefer.
To change orientation in Sheets, navigate to “Orientation” on the print settings page and choose either Landscape or Portrait. Under “Paper size,” choose the size of paper you want to print on. If you would prefer to add custom paper size, choose custom size and enter a height and width.
We’ve previously shared some tips and hacks on - "How you can collaborate better in Google Drive and Dropbox" and also "How you can manage files better in Drive". All the points are still valid and you should totally check those articles out so you can work smarter.
Rather than download to your computer before uploading to Google Drive, use the “Save to Google Drive” Chrome Extension to save stuff directly to a specific Google Drive folder. It's super handy and helps to keep your computer clutter free.
There is no need to retype text from PDFs or images you need to copy. Google Drive has an option to open them with Google Docs with an automatic optical character recognition.
Within a few seconds of doing this, you will get a document with both the original file and the text from it ready to format and use wherever you need it.
It is possible to comment directly on other file types without converting them into Docs, Sheets or Slides. All of your Microsoft Office files, PDFs and images can be worked without necessarily converting them.
For instance, if you are on an external team where everyone is working on multiple file formats,, you can comment on those files in Drive the way you're used to in Google Docs.
Go to the Drive preview pane, comment on files, assign tasks, or mention coworkers and the people you work with can do the same, even if they’re not using G Suite. Once a mentioned person opens a file on her Windows laptop using MS Word, they will be able to see your comment in the file and reply directly from MS Word.
The activity pane shows when last a document was edited. While in Google Drive, click “i” to access the info pane icon in the toolbar. You can also press i on your keyboard to open the side panel.
Click on “Activity at the top to see a record of the last person to edit a document or the change that was to the document and when it was done. This can be helpful when collaborating with others.
Typically, Google Apps - Drive, Docs, Gmail - and the data they collect are stored in the cloud. That’s why you need to have internet access to be able to use them.
One way to circumvent this is to setup offline mode in the Settings section of Google Drive. Go to “Settings” and check the box that has “Sync Google Docs, Sheets, Slides & Drawings files to this computer so that you can edit offline”. You will then install an extension that will allow you use your Chrome browser to to access your Google drive even without internet access.
There is the tendency to start searching for files once you sign in to drive.google.com but there’s no need to do that every time. Especially if it's for a file you recently worked on.
Make a habit of clicking on Recent once you sign in. This will increase your productivity as you will spend less time searching for files you could have viewed at a glance.
As with most Google apps, Google Drive has keyboard shortcuts and adopting their use will save you a lot of time and clicks.
These shortcuts can be accessed by clicking the “Ctrl” and “/” keys on a Windows computer (any browser) or “Cmd” and “/” on a Mac computer.
Just press “V”.
If you prefer to view items in Google Drive at a glance, the ‘V’ key can be used to toggle from grid view to the list view. Now, if you prefer to preview items before selection, the grid view will work well for you and you can also use the ‘V’ key to switch things.
Quick tip: click “Q” to adjust the spacing while viewing items as lists.
Formplus users can create a new form in Google Drive. On the Left Navigation bar, click the “New” button and select “More” from the drop down that appears.
Once you click “Form+” on the second drop down, you will be redirected to the first step of the form builder where you can create a form from scratch. It is in the builder that you can; drag and drop fields, add file upload fields, set file validation, create multi-page forms among other things. Once you are done building the form, you can go on to customize it the “Customize” section as well as set up email notifications and add logic to forms.
If you don’t have a Formplus account, you would need to sign up to create forms from your Google Drive account. Once you sign up, you can subsequently create forms from Google Drive.
Back in April, Google released the first major Gmail redesign in years and with it came a number of many features. It might seem a little much at first glance, but with a few lessons, you should be ready to maximize the new Gmail’s potentials.
In the new Gmail, you can work offline and then sync your account as soon as an internet connection becomes available.
Once you’re offline, you'll be able to write emails, archive or delete stuff offline and then choose to download and keep this data offline data on your computer even when/if you log out.
Email Snooze is a genuine time-waster rather than let messages linger and pile up in your inbox, use the snooze function to deal with everything as it comes in.
Time yourself, emails that don’t require a response or action from you, archive it immediately; emails that would take less than 1 minute response time, make an effort to respond immediately; and emails that would require some response or action and you can’t do it immediately, snooze it to a day and time when you will be able to handle it.
Snoozing an email makes it vanish from your inbox and then reappear at a latter date and time, thus decluttering and organizing your inbox. You can also snooze multiple messages at the same time.
From your inbox, click the boxes to the left of any messages you want to include, then click the clock-shaped icon in the horizontal row of icons that appears at the top of the screen and select the day and time you want.
The Nudging feature is another tool that could help you work smarter. Google uses proactive AI tools to help you manage your inbox by suggesting or "nudging" you to respond to an email that's been sitting in your inbox for a few days.
It is displayed in bold text to catch your eye and give you a chance to respond to or clear emails you may have ignored.
The new Gmail lets you send confidential messages; by allowing you recall messages after they have been sent and setting an expiry date/time for messages. It works by sending the recipient a link to the actual content, not the email itself. You should note that the recipient could circumvent this process by capturing and saving a screenshot.
To enable this, when composing a message, look out for the timed padlock icon to customize your options.
Have you ever sent out an email mistakenly and you were worried that the recipient might forward or download it. You can enable the feature that allows you prevent others from forwarding, copying, downloading, or printing your message.
Gmail also lets you protect sensitive messages with a two-factor authentication code — delivered via text to a specified number — to make sure only the intended recipient is able to open it.
Want to make your Gmail darker? You can actually switch it up in your settings.
Click the gear icon in the upper-right corner and select "Themes." In there, you'll find colorful options to spice up your inbox along with some muted options, like plain dark, high-contrast, and the soothing lavender.
You can also select a photo to be used as a theme, when you click “My Photos” at the bottom-left corner.
The right-side panel in the new Gmail interface is so versatile; apart from Calendar, Keep, and Tasks. When you click the “+” (plus) sign beneath the apps' icons, you can add inbox-based services like as Trello, Wrike, and QuickBooks.
Google understands that Gmail is their most popular app for majority of its users, it is quite indispensable. With that thought in mind, they added a number of G Suite apps into Gmail.
The side panel on the right of the new Gmail lets you pull up Google Calendar, Google Keep, or Google Tasks right in your inbox; you can manage information from each of those apps without opening or switching tabs.
When you click on any of the colorful app icons, a panel opens up letting you quickly create or edit Calendar invites, save ideas and notes in Keep, or manage to-do items in Tasks without having to leave Gmail. Those cons will then pop up beneath emails in your inbox as well any time an event, task, etc. is included in a message.
There are a variety of features in Gmail that make it even easier to deal with: