Spreadsheet Magic

I often get asked about Google Spreadsheets so I thought I'd make one with a few of the cooler things they can do built into it. The first step to share is how to give others a copy of your spreadsheet if you don't want to put it in the Template gallery.

First publish the link and copy the address.

Then put that link on your website and change the end of the spreadsheets address, replacing everything after the & with newcopy so,

this

http://spreadsheets.google.com/pub?key=0AtzHWa9HNKsUdG9vWTktbEpRQUlkV3F0TTFVcWJTblE&hl=en&output=html

becomes

http://spreadsheets.google.com/pub?key=0AtzHWa9HNKsUdG9vWTktbEpRQUlkV3F0TTFVcWJTblE&hl=en&newcopy

Click here for a copy of Spreadsheet Magic.

There are more from templates here: http://sites.google.com/site/kernkelley/forms