![g docs auto size cells g docs auto size cells](https://www.shorttutorials.com/google-docs-spreadsheet/images/border-colors-google-spreadsheet1.jpg)
From there you’ll need to select the ‘Editing’ tab and then enable the new Sheets.
![g docs auto size cells g docs auto size cells](https://www.labnol.org/static/7a331502272f16cf1424dfc716bae25e/6d80e/embed-google-slides.png)
To upgrade to the new Google Sheets, click on the settings gear inside Google Drive and click settings.
#G docs auto size cells update#
Keep in mind this update is only available in the new Google Sheets, so consider this a great reason to upgrade your account. To select non-adjacent cells, simply hold down the command key (for Mac users, PC users hold down the CTRL key) while making your selections. With this update you can cut out that second step entirely, which can save a ton of time in the long run. For example, formatting in Google Sheets can be a little time consuming if you have to apply the changes to one group of cells, then apply the exact same changes to another group. But for those of you who spend a lot of time working with spreadsheets, you know how valuable this update is. Many of you will be happy to know that Google quietly announced an update to the new Google Sheets that finally allows you to do this.įor those of you who aren’t power-spreadsheet users, it may not seem like a big deal to be able to select multiple cells at once. Press Ctrl and click on all the rows and columns you want to select at one time. You can select multiple rows or columns, but not both at the same time. To do this, click on the letter or number at the beginning of each column or row to select it. While many of these features can be replicated with workarounds, one major problem (with no real solution) was the inability to select multiple, non-adjacent cells. First, select the range of cells you want to transform. One of the biggest concerns we’ve heard about Google Sheets is that it lacks a lot of the basic features contained in Microsoft Excel.