Difference between revisions of "Spreadsheet Tricks"

From TeleCafeWiki
Jump to navigation Jump to search
(Removed EditGrid & Pirate Pad embeds. Added section: Quick Edit Sheets)
(An alternative to Excel comments)
Line 1: Line 1:
 
{{RightTOC}} <!-- See: Manual:$wgRawHtml -->
 
{{RightTOC}} <!-- See: Manual:$wgRawHtml -->
 +
== Miscellaneous ==
 +
* [http://www.techrepublic.com/blog/microsoft-office/an-alternative-to-excel-comments/ An alternative to Excel comments]
 +
: Use Excel's data validation feature to share meaningful information about specific cells with users.
 +
 
=== Array Formula In Google Spreadsheet ===
 
=== Array Formula In Google Spreadsheet ===
 
<html><iframe width='950' height='300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ap9dh6jmi4yndEp1Q1M4cXk0QTFOTmpRWW5mb25kNkE&output=html&widget=true'></iframe></html><br />
 
<html><iframe width='950' height='300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ap9dh6jmi4yndEp1Q1M4cXk0QTFOTmpRWW5mb25kNkE&output=html&widget=true'></iframe></html><br />

Revision as of 09:34, 6 February 2014

Miscellaneous

Use Excel's data validation feature to share meaningful information about specific cells with users.

Array Formula In Google Spreadsheet

<html><iframe width='950' height='300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ap9dh6jmi4yndEp1Q1M4cXk0QTFOTmpRWW5mb25kNkE&output=html&widget=true'></iframe></html>

Embedding Spreadsheets & Parts of Spreadsheets

Embed SkyDrive Spreadsheet

<html><iframe width="650" height="450" frameborder="0" scrolling="no" src="https://skydrive.live.com/embed?cid=0D58D956AB4BC9E0&resid=D58D956AB4BC9E0%21117&authkey=AH7Glp3oB3WJ4Ag&em=2&AllowTyping=True&wdDownloadButton=True"></iframe></html>
iFrame code for the spreadsheet on SkyDrive

Embed Google Spreadsheet

<html><iframe width='500' height='350' frameborder='0' src='https://docs.google.com/spreadsheet/ccc?key=0Aumujjc9cTZhdE92TExvcjU5NVZBbFk2Ul82dFI1ZUE&single=true&gid=0&range=J2%3AQ12&output=html&widget=true'></iframe></html>

Sources
See Also

Quick Edit Sheets

Ethersheet is an open source tool to make collaborating on spreadsheets fast, easy and secure. You can also download the code on GitHub.
Unfortunately, EditGrid's service is ending May 1, 2014.[1]

Other Edit Pads (Non-Spreadsheet)

References