Warning: Division by zero in /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php on line 861

Warning: Division by zero in /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php on line 861

Warning: Division by zero in /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php on line 861

Warning: Division by zero in /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php on line 861

Warning: Division by zero in /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php on line 861

Warning: Division by zero in /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php on line 861

Warning: Division by zero in /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php on line 861

Warning: Division by zero in /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php on line 861

Warning: Cannot modify header information - headers already sent by (output started at /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php:861) in /home/excelwiki/domains/excelwiki.com/public_html/pmwiki.php on line 702
Excel To Wiki - Excel Wiki

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-Aug5-Sep5-Oct5-Nov5-Dec6-Jan
Rate6.256.56.56.56.756.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     
 385693860038630386613869138358
Rate6.256.56.56.56.756.75
% Change =+D8/C8-1=+E8/D8-1=+F8/E8-1=+G8/F8-1=+H8/G8-1