You can now rotate text easily in the cells of Google Sheets. This feature can be particularly handy if you need to fit long header titles into narrow columns, or when you simply want to spruce up the presentation of your data.
A while back I wrote this post about splitting data into multiple columns in Google Sheets.
A small update has made this task a little easier. When you paste data into a sheet, a small contextual menu now appears. Clicking on this offers the option to Split text into columns:
Google’s latest update makes it simpler to comment on your own or your colleagues’ Docs, Sheets, and Slides files on both the web and mobile platforms. Now, if you highlight some content, an icon appears at the right-hand page edge:
Some time ago I posted about templates, and how to use them in Google Drive. Google has now introduced a new template gallery for the desktop versions of Docs, Sheets and Slides, offering a new interface design and lots of new template designs.
When you copy and paste some content in a Google Sheet, the formatting of the pasted content is maintained by default (unless you’re using the Paste special function). Google has now added an extra feature that allows you to instead paste just the values contained in the content, or just the format of the pasted content.
Various previous posts have dealt with cell formatting in Google Sheets..
Google has now upgraded this feature so it’s now possible to select a portion of the text within a cell and to apply formatting to only those characters, instead of to the entire cell. This new feature is available both on the web and in the Sheets app for Android.
I’ve discussed adding charts to Google Sheets in various previous posts. Although the charts generator in Sheets is powerful, it can be a bit of a chore to create a chart just to quickly visualize some of your sheet data.
In this previous post (and others) I discussed how to protect spreadsheet cells to prevent your collaborators from messing up your sheets with inappropriate edits.
Google has just made this a little more flexible by allowing you to add a warning text to selected ranges or cells within a sheet that can be edited by collaborators.
As I’ve discussed previously (e.g. in this post) f you want to make a Google Sheets spreadsheet available for a large audience to see, you can publish the spreadsheet as a web page.
When the file is published, the publisher obtains a URL that can be sent to whomever they choose, or embedded into a website.
Google has added a handy ability to Google Sheets; you can now view the result of any formula (including any potential errors) in real time, as you create the formula.
Simply enter your formula and watch the calculated result pop up above it in a ‘tool tip’ style container: