Collaborate

You are here: Beginners Course \ Collaborate

🤗Meet your Friends!

When you work in the same Google Sheet, Slide, or Document, you may see where your peer's cursor is.

Here're a few tips for you:

👐🏼Share

Share Spreadsheet with anyone by their email.

Click [Share] & try the gear ⚙️ to see advanced security options.


💭Comment

Select a cell & use [Ctrl]+[Alt]+[M] to create a comment inside a cell.

Add @ in the comment & add email address to send notification

Use Comment Icon near the |Sheet name| to see all comments

🎤Show

During a meeting, use [Ctrl] + Mouse wheel 🎡 on the top of Sheet's screen to ZOOM fast.

Press [F11] to use FullScreen Browser mode. This will let you show more info on screen.


Zoom/Meet? Or Mobile + Sheet? Make a usual phone call and enter the same Sheet in case of a slow internet connection.

🦊Follow

During demonstration click the user's avatar 🤓 to see where their cursor is.

👷🏼Cowork

Use Filter Views...

The great power of Spreadsheets is filtering. You need to see part of your data on screen at a time. The old way to do that was a regular filter. Now we have a better thing — filter views:

  1. Filter Views are a special "regime" of a Sheet. Only you see your newly created view, no other user is affected.

  2. Filter Views are saved automatically and have their names. You can create saved filers for each case.

  3. Filter Views have unique URLs. This means you can copy the URL, and share it with a peer.

As the interface may change, the best way to learn it is through the official guide. Please learn more on how to create a Filter View here:

https://support.google.com/a/users/answer/9308952?hl=en

And see my sample Filter View:

https://docs.google.com/spreadsheets/d/1zB0RTmAHZ5p6uXQR11b-oLodzdAwjVvTfVIcWTa0cGM/edit#gid=122726536&fvid=696130992

That's all we wanted to show for beginners. Sheets have a lot more fun: formulas, formats, scripts, add-ons, etc. If you want to learn that, you're not a beginner anymore. At this step, your next level is:

Level 4. 🌟 Super-Star

What's next:

  1. Return to the main screen.