The Excel Spreadsheet Excelclopedia
Excel To Wiki
Simple Excel spreadsheet ranges can be copied into Excel Wiki and used as examples to support content.
1) Copy a range from an Excel spreadsheet and paste it into the Edit window
2) Click on the Excel icon
at the top of the Edit window. This will convert the Excel range into a table format.
3) Click preview or scroll to the bottom of the Edit Page to see a preview of the transformed range.
4) Provide a User Name and press Save.
Example Output:
| US Prime Rate Forecast | ||||||
| 5-Aug | 5-Sep | 5-Oct | 5-Nov | 5-Dec | 6-Jan | |
| Rate | 6.25 | 6.5 | 6.5 | 6.5 | 6.75 | 6.75 |
| % Change | 4.00% | 0.00% | 0.00% | 3.85% | 0.00% |
Limitations:
- the table is not interactive
- formatting and formulas are not displayed.
- column widths are adjusted to fit content
To display formulas:
1) In Excel click on CTRL and ` (the ` is above the tilde key (~)... the top left key on most keyboards). This will display cell formulas on the worksheet.
2) Copy and paste into Excel Wiki.
Example:
| US Prime Rate Forecast | ||||||
| 38569 | 38600 | 38630 | 38661 | 38691 | 38358 | |
| Rate | 6.25 | 6.5 | 6.5 | 6.5 | 6.75 | 6.75 |
| % Change | =+D8/C8-1 | =+E8/D8-1 | =+F8/E8-1 | =+G8/F8-1 | =+H8/G8-1 |
Categories: Editing Help and Guidelines
Printable View