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.
If you want to turn a range of cells by 90 degrees within a spreadsheet, you need to understand how Sheets can handle the ...Discover More
Need to separate the contents of one cell into multiple cells? It's easy to do when you use the SPLIT function, as ...Discover More
Conditional formatting is a powerful tool you can use to dynamically adjust the formatting in your worksheet. This tip ...Discover More