by Allen Wyatt
(last updated April 3, 2014)
One of the key benefits to working with Sheets is that you can easily collaborate with others. However, not everyone has access to the Internet (hard to believe, huh?), or you might need to simply share a spreadsheet with someone in a different file format.
Sheets makes it easy to download a spreadsheet and do a file conversion at the same time. Here's how you do it:
At this point, Sheets starts the download, using a filename that matches the name of your spreadsheet and an extension that reflects your choice in step 2.
Speaking of step 2, there are a number of different target formats you can choose for your downloaded spreadsheet. As of this writing, Sheets provides these options:
Note that the first three options result in the data on all sheets being downloaded, but the final three do not. Also, it should be noted that the last option (web page) does not produce a page that is interactive or changeable; it is essentially a static representation of the current sheet.
When you create a chart, Sheets helpfully adds a legend to better explain the data that is in the chart. You may not want ...Discover More
Want to make a particular cell or range of cells stand out? One way to do it is by changing the border color of the ...Discover More
Comments can help document what is going on in a spreadsheet. Here's how to easily add comments to individual cells.Discover More