Continuing from last time 🔈👉 Registering a Google Account
🔔 Introduction
After learning how to register a Google account, everyone will surely be eager to further learn how to use Google Sheets.
During the mask period, companies generally encouraged everyone to work from home. While working, it's inevitable to encounter issues when many people use the same table: network delays causing data to be modified, others secretly altering your content, or inserting screenshots into the table.
📕 Content
🧵
The princess occasionally encounters bad people while filling out forms. If ignored, the content filled by the princess will be tampered with.
♦ Right-click on the row or cell you want to 'lock'. Click 'View more row actions', then click 'Protect range'.
♦ A new window will pop up on the right side of the table, click 'Set permissions', then click 'Restrict editing to' 'Only myself' (⚠ Do not trust anyone, only trust yourself. After locking, only you and the table creator can edit).
♦ What is displayed can be edited by yourself, but what the bad guys see cannot be edited.
🧵
You might think it’s troublesome to put your address photo into the table!
♦ Click on the table where you want to insert the image, click 'Insert', click 'Image', click 'Insert image in cell'.
♦ Choose which channel's image you want to upload; successfully uploaded images will appear in the cell.
🧵
Of course, the princess has prepared a full set of methods for everyone. How can you complete the above operations on mobile?
♦ Android needs to go to 'Google Play', while iOS needs to go to 'App Store'
♦ Download a 'Google Chrome' browser.
♦ Copy the table URL and open it in the browser, click 'three dots', and select 'Desktop site'. It will automatically switch to PC mode (⚠ The same operation for Android and iOS).
♦ On PC, right-click to 'lock the table', while on mobile, just long press to achieve 'lock the table'.
🪢 Princess's Tip 💡
♦ If you don't want data to be modified due to network delays, it is recommended to start 'locking the table' as soon as you enter.
♦ It's not only Google Chrome that can be used on PC; Microsoft Edge can also be used, while other browsers are not very reliable.
♦ Of course, operating on a mobile phone is not very convenient, but it can be used in emergencies without asking for help from others. The operating steps are the same for Android and iOS.
I am the princess, see you next time! 😘