By default, the cells in every new spreadsheet are always the same size. Once you start entering information into the spreadsheet, you can easily adjust the rows and columns to better match your data.
Table elements – rows, columns, and cells – can be added, removed, and hidden through the “Edit” menu or the context menu, which is opened by right-clicking on the highlighted element. For some actions, you have to choose what happens to the surrounding elements after deletion or insertion – where the data, rows, and columns will move.
Each row and column of a new spreadsheet always has the same height and width. When you start working with spreadsheets, you’ll find that these default sizes don’t always fit perfectly with the cell content.
So, here’s how to make Google Sheets columns to be the same size.
How to make columns the same width in Google Sheets
So, first of all, click on the top of the first column you want to select and, while holding down the mouse button, drag the cursor to the right until all the columns you want to select are highlighted, then release the mouse button.
Now, if you want to evenly arrange columns in Google Sheets, you have to follow these steps:
- Select the columns that you want to bring to the same width.
- Then, right-click on one of the selected columns.
- The menu pops up. Click “Resize column…”
- When the new menu appears, enter the new column width by typing a number of pixels. For reference, in Google Sheets, the default column width is 100 pixels.
- Finally, click “OK”.
Once you have completed these steps, the width you set in pixels will be applied to all the columns you previously selected.
What is history of changes in Google Sheets
Google Sheets automatically saves not only the current version but also the entire history of changes. To open it, click the “Last change was…” line to the right of the Main Menu.
In history mode, you cannot edit the table, but you can select, view and, if desired, restore any of the previous versions.
Sometimes you can’t restore a previous version – it’s not your table and you didn’t edit it. If you click “Restore”, all changes made by another person after a certain point will be deleted. Working with the previous version in history mode is also difficult – you cannot even properly select and copy data, let alone use filters and formulas. In this case, Google Sheets has an 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 shared access in Google Sheets
One of the undeniable advantages of Google Spreadsheets over Excel is the ability to work together. To open your file to your colleagues, click the green “Share” button in the upper right corner and set the settings.
You can give access to the file to individual users, to those who have a link, or to the whole Internet. There are also different levels: “Edit”, “Comment”, “View”.
If you link to third-party sites in the tables and you don’t want others to see the contents of the file, don’t open the link. The owners of the sites 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.
Right-click the context menu, select “View more cell actions” and choose “Protect Range” or 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”. Enter a description.
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. To protect an entire sheet, go to another tab and select it in the list. Click “Set Permissions” and configure access.
You can specify a limited list of users who have the right to edit the specified 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.