When Google came up Google Docs and Google Sheets, it started a completely new way people collaborate online to create and work on documents and sheets in groups. The extremely user-friendly interface for collaborating completely changed the way people work today.

A lot of StartUp businesses today manage all their data using Google Sheets. Mainly it helps them to work in teams together on the same Sheet, at the same time. Each one can also visually very easily see what the others are doing right now in the sheet.

Sharing is a very well known feature in Google Sheets, so I will not elaborate further on that. But what you may not know is that you can actually Share in such a way, that a person with whom you share your sheet with, can edit only a part of that Sheet, and not everything!

1) Sharing with limited rights to edit for certain people

You can select your ranges and restrict editing rights to certain people.

First, share the sheet with all who you want to allow to edit.

  • Click on Share, add the email id’s.
  • Then, restrict editing rights.
  • Select the Range that don’t want to allow to edit.
  • Under Data menu, click on Protected Sheets & Ranges.
  • Click on the + sign
  • Ensure the correct Range is selected
  • Click on Set permissions
  • Select Custom and enter the email id’s who you want to restrict
Sharing with limited rights

Sharing with limited rights

2) Pivot Tables refresh automatically

In Google Sheets, there is no need to Refresh pivot tables when the underlying data changes. It updates automatically, instantly. This is a big relief over Excel.

3) =Googlefinance function

Google really understands the power of the internet and connected Google Finance to Google Sheets directly!

For investors in the stock market and other areas, data from Google Finance can be picked up directly into a Google Sheet using the =Googlefinance function.

Enter a scrip code in cell A1, say 500325, and use the below formulae: –

  • =Googlefinance(A1)
    • The current market price of Reliance Industries Ltd. will show, and will update automatically
  • =Googlefinance(A1,”name”)
    • The name of the scrip will appear, in this case, Reliance Industries Limited
  • =Googlefinance(A1,”high52”)
    • 52 week high price will show
  • And so on….

4) Keyboard shortcuts list

You can get a list of most commonly usable keyboard shortcuts directly from the Help menu, or use the keyboard shortcut Ctrl + / to get the list instantly!

This comes in very handy, and you don’t have to always search for shortcuts on the internet.

5) Revision History

This is again a mind-blowing feature when collaborating with others.

Under the File menu, click on See Revision History.

A list of all changes will appear, and you can anytime take your document back-in-time to an earlier version.

 

Excel on the other hand, has many more unbelievable features, which many of us don’t even use! Let’s take What-if-analysis for an example. The kind of analysis you can do using this tool is incredible! Google Sheets doesn’t have this yet.

Having said that, Google Sheets is catching up really well and will be instrumental in always improving the way people collaborate to create documents, sheets, presentations, etc.