Collaboration is without doubt one of the major promoting factors behind Google Sheets. It’s a fantastic motive to make the change from anybody who needs higher collaboration choices than these present in Excel and Numbers. Sadly, collaboration additionally means individuals can alter issues that you just may need put a whole lot of thought into fairly than simply getting into the numbers they’re imagined to enter once you share the doc.
By default, Google units row top and column width to 21 pixels and 120 pixels, respectively. The proprietor of this Sheet, nevertheless, can change these values to something they want (inside motive). In case you’re having hassle becoming full numbers or names, for instance, you may alter these settings to show the meant info.
Sadly, others can “repair” your changes, main you to surprise why you spent a lot time on it within the first place. Whereas there’s no choice to lock row and column sizes, per se, you may lock the doc as a complete to maintain individuals from making these changes.
Locking column and row sizes in Google Sheets
1. Step one to lock formatting in your Google is to go to Information > Protected sheets and ranges. The Protected sheets and ranges menu will seem on the fitting facet of your window.
2. Within the menu above, click on Add a sheet or vary. Fill within the Sheets or Ranges whose rows and columns you need to lock.
3. Subsequent, click on the Set permissions button. A small window will seem that permits you to customise who can edit your sheets.
4. Lastly, click on Finished. Viewers will now be prevented from altering your row and column sizes.