Those who use Google Sheets regularly should know how easy it is to resize cells, columns, and rows. But sometimes, amid all the chaos in the spreadsheet, it’s time to find a balance.
If you see that you have a lot of different-sized cells and want to make them the same size, you should know that there is a straightforward method to help you. All you have to do is change a few settings, and you’re all set.
Also, in the end, I’ll tell you a little about what Google Sheets changes history is and how to protect your data from unauthorized editing.
So now, let’s take a closer look at how to make your columns the same size in Google Sheets.
How to resize columns in Google Sheets
Well, if you want to make your columns the same size in your spreadsheet, you can follow these steps:
- First, select the columns you want to bring to the same width.
- Then right-click on one of the highlighted columns and select Resize columns.
- When the new dialog box appears, enter the column width. The default column width in Google Sheets is 120 pixels. So let’s enter this number.
- Finally, click OK.
Once you have completed these steps, the width you set in pixels will apply to all the columns you selected.
That’s it. As you can see, there’s nothing complicated about resizing columns in Google Sheets. Moreover, these steps are really easy to remember.
What is the history of changes in Google Sheets?
Google Sheets automatically saves the current version and the entire history of changes. Click the Last edit link on the taskbar’s right to open it.
In history mode, you cannot edit the table, but you can select, view, and restore any of the previous versions if desired.
Sometimes you can’t restore a previous version – it’s not your table, and you didn’t edit it. If you click Restore, you will delete all changes made by another person after a certain point.
Working with the previous version in history mode is also tricky – you cannot correctly select and copy data, let alone use filters and formulas. In this case, Google Sheets has the option to copy an earlier version.
When you click, the program will create a copy of the table in the form you want.
What is the shared access in Google Sheets?
One of the undeniable advantages of Google Sheets over Excel is the ability to share content with other people easily. To open your file to your colleagues, click the green Share button in the upper right corner and and allow access to anyone with a link to the document.
You can give access to the file to individual users, those with a link, or the whole Internet. There are also different levels: Edit, Comment, and View.
If you link to third-party websites in the tables and don’t want others to see the file’s contents, don’t open the link. The website owners you are linking to can get a link to the file from clickstream reports and open it.
How to protect data from editing in Google Sheets
You can prohibit colleagues from editing data in the whole table, on individual sheets, ranges, or even cells. You can set up access levels to disallow editing the entire table, and there is a separate tool for cells and ranges.
- Open the Data menu and click on Protected sheets and ranges.
- In the form that opens on the right, click Add a sheet or range. If you want to close a range from editing, click the table icon on the appropriate tab and select the desired cells on the sheet.
- After that, enter a description.
- Finally, click Set permissions and configure access.
You can specify a limited list of users who have the right to edit the selected sheets and cells or limit yourself to a warning. In the latter case, the program will display a warning message when you try to edit a protected range.