Google Sheets are gaining a lot of popularity among business owners which helps them to easily manage their data and create complex reports in just a few minutes. It has simplified common spreadsheet tasks, saving a lot of time. The Features and benefits derived from this are innumerable. In this particular blog, I am going to share seven Google Sheet tips that a lot of people would be unaware of and can help in data sharing and management in a better way.
These Google Sheet tips are very useful for business owners to deal with large amounts of confidential data in a secure way.
What are the 7 useful Google Sheet tips?
Here you go, one by one:
How can you restrict your teammates from doing the same? Let's see how, in the Google Sheet, there's a button on the top right corner called ‘Share’ which shows it's only private to me.
On clicking, it opens the option of sharing with people and groups. Now, this is where you write the email address of your teammates, and when you do that, it gives, you three types of sharing rights:
Further, with each and every type of sharing right, there's a setting button at the top.
For example, if you share it as a viewer where you will get an option that viewers and commenters can download, print, and copy. If you disable this option, your teammates will not be able to download, print or copy the Google Sheets, making it secured for you.
If you share it as an editor, then the editor gets the right to change the permissions and can share it with others. If you want to restrict that teammate from further sharing, then you uncheck this as well.
Yes, you can use Google Sheets even without the internet. For that, click on the File tab in the main header menu, and select the option ‘Make available offline.
Now, when you click on this, it changes the status of all Google documents from online to offline. So, when offline, it will save that data on the laptop, and once you get the internet connectivity back, it syncs that offline data to the Google Cloud.
So, if you want to work without the internet, make sure you switch on this option even before the internet goes off.
But, how to use it? Look at the right side of the tab ‘Help’, it shows, ‘The last edit was xx minutes ago and if you hover on it, it shows ‘Open version history’.
It will show you all the changes made by your teammates either today or yesterday, a day before yesterday, or even one week before. And when you see other versions here, you click on any of the versions to restore it.
So, for example, if your teammate deletes the data, you can check the previous versions to take the data back again.
In your existing Google Sheet, click on the tab ‘Tools’, you will get an option ‘Create a form’.
Now, when you click on that, it opens a Google form with an alert, ‘New form created, add your questions here. So when you click here, it opens a new Google form altogether which you have created from a Google Sheet itself.
You can add the desired questions in the form.
Now, go back to the previous spreadsheet, you will see a new sheet automatically added to it named ‘Form Responses 1’ which is connected to the Form.
Now, try filling up the form by previewing it and you will see that the sheet will automatically capture all the data filled in the form on submission.
For example, if you have two workbooks and you want to copy one sheet to another worksheet, you need to right-click on the sheet name, it shows the option called ‘Copy to’ and hovering on it gives two options - either a new spreadsheet or existing spreadsheet.
So when you click on Existing Spreadsheet, you click on Recent, it will show you all the Google Sheets, which you are already having in your Google Drive.
Select the Google Sheet you want to copy it in and it will start copying the worksheet to a different sheet in that file altogether.
Move Google Sheet to folder: A lot of times when we create Google Sheets, it all gets scattered in our Google Drive and we are not able to find out which Google Sheet is in which folder. Now, how can you move Google Sheet to any specific folder in Google Drive?
Follow these steps:
Whenever we fill a google form with a set of questions, the responses get filled in the Google sheet attached to it in the same order of questions. But, Sometimes we need the responses to be in some other order for comparison or some other reason. Is that possible?
Yes, it can simply be done without re-aligning the questions in the form. What you have to do is simply drag that column by selecting from its header and position it wherever you want. The order of responses will change in the sheet without any change in the form.
You can realign your columns based on your requirement and the data will be picked from Google Forms in the same way that it was picked up before you realigned the columns.
Follow these seven tips to efficiently use Google Sheets in your business. It will definitely help you save your time and efforts at the same time giving you data security & easy data management.
For more valuable content, subscribe to our YT channel - https://www.youtube.com/c/KewalKishan
Join me for a 2-hour live session -
Sign up now to get the following tools: