By knowing the main tips and tricks of Google Sheets, you will undoubtedly increase your productivity and have even more complete and organized spreadsheets.
Fernanda Rodrigues
Jun 1, 21 | 7 min read
google sheets
Reading time: 7 minutes
You may use spreadsheets every day in your marketing routine , but you probably haven’t explored even a third of the features that Google Sheets offers .
In many cases, even those who are already familiar with many of Sheets’ features still have a world of possibilities to discover and use.
The good news is that you don’t need to be an expert in formulas or spreadsheets to explore the dozens of features this app offers. In this post, we’ve separated 20 Google Sheets hacks for you to learn and apply, without needing to be an expert!
1. Create combinations for frequent tasks
Do you usually do the same tasks in Google Sheets?
To optimize your time, you can use keyboard shortcuts for tasks you perform frequently.
2. Use Macros for your frequent tasks too
In addition to combinations, another Google Sheets tool that helps you optimize your time with frequent tasks is Macros.
With this feature, you can record the actions you perform repeatedly and then play back the saved recording to repeat the tasks.
If you are interested in this tool, go to Tools > Macros > Record Macro .
google sheets
3. Translate texts without the need for other applications
One feature that not many people know about mali email list 100000 contact leads Google Sheets is that it can be integrated with Google Translator, allowing you to translate any text you want in your spreadsheet.
To activate this feature, simply type =GOOGLETRANSLATE (“phrase in current language”, “current language”, “language you want to translate to”) .
Look at the following example, in which we want to translate a text from Spanish to English:
=GOOGLETRANSLATE(“hello”, “es”, “en”)
4. Transfer data from another Google Sheets spreadsheet
Another feature that can save you a lot of time is the integration between Google Sheets spreadsheets.
This way, you avoid having to copy and paste information from one file to another, and this data is sent automatically.
The functionality that enables this is called IMPORTRANGE. To test it, use the following example:
=IMPORTRANGE (“Url of the spreadsheet you want”, “Sheet and cell reference”) .
Here’s an example:
5. Connect your spreadsheet to other applications
In addition to connecting one spreadsheet to another, you can also connect your Google Sheets spreadsheet to other online applications.
This means you can pull data from sources like Instagram and Twitter.
To do this, you can use apps like Zapier or IFTTT.
6. Know the formulas within the app
As you may already know, Google Sheets allows you to apply different formulas to your data.
We know that there are many formulas and it is difficult to know or use them all, but you can get an idea of the possibilities you have by writing the equal sign and a parenthesis .
Example:
google sheets
7. Invite collaborators
One of the main advantages of using Google Sheets
is that you can add collaborators to your spreadsheet who can view, comment on, or edit the file in real time.
In addition to providing this flexibility for each collaborator, you can also see what each one is doing in the document and have access to an edit history.
To share your spreadsheet with more people, just click “share” and add the emails of those you want to participate in the document.
google sheets
8. Lock cells to prevent editing
While Google Sheets allows multiple people to 8 keys to improving your website’s seo positioning collaborate on the same file, you don’t always want everyone to have access to all types of editing.
For more control over these permissions, you can lock specific cells and select who you want to allow to edit them.
Set this permission by right-clicking on the data you want to restrict and then selecting “protect range”.
google sheets
In addition to protecting specific data, you can also protect an entire tab by clicking “sheet”.
google sheets
9. Make a checklist for your team
Another great feature for those using Google betting email list Sheets with teams is the ability to create an activity checklist .