Starting in early 2013, we'll be turning off Gadgets in Google Spreadsheets. For more information, see our help article.
Turning gadgets into sheets in a spreadsheet is really easy. Here's how to do it:
- Click the grey triangle in the upper-right corner of your gadget to open a drop-down menu.
- Select Move to own sheet from the menu.
- Enjoy! Your gadget will now become a sheet in a spreadsheet.
Note: to help tell which sheets in the spreadsheet are sheets, and which are gadgets, these last ones are named 'Gadget1', "Gadget2', etc. by default.