Search results
Results from the WOW.Com Content Network
Another alternative is to copy the entire table from the displayed page, paste the text into a spreadsheet, move the columns as you will. Then reconstruct the table lines with a formula. This formula handles a three column table, reconstructing a single line.
Currently, there does not seem to be a way to copy those tables to a wiki and keep styling such as colors (background or text color). It is possible to convert PDF tables to Excel and keep the colors. Or to HTML tables and keep the colors. But there does not seem to be a way to copy any of those colored tables (PDF, Excel, HTML, etc.) to a wiki.
For more complex table structures, Visual editor offers cell-merging operations; see details here.. In addition, it is usually possible to add or import a table that exists elsewhere (e.g., in a spreadsheet, on another website) directly into the visual editor by:
Copy the table right off the page (not the wikitext) and paste it into Excel2Wiki. Remove the table caption text for now. Check the following boxes: format first row as header; format first column as header; Check or uncheck "sortable" depending on your needs. Then click "Convert". Copy the wikitext results back to the wiki.
For advice on writing style and formatting in a bullet-point format, see Wikipedia:Styletips; For summaries of some Wikipedia protocols and conventions, see Wikipedia:Dos and don'ts; If you don't want to use wikitext markup, try Wikipedia:VisualEditor instead; To ask a question, see Wikipedia:Questions to locate the appropriate venue(s)
In the options menu decide whether you want the rows or columns totaled. Click OK. The table will convert to the new format with the years as column headers. To avoid problems copy the table to a new sheet before further editing. See: "Only Copy Visible Cells" in Calc help. For more help see: LibreOffice: Pivot Tables and LibreOffice Help ...
Get AOL Mail for FREE! Manage your email like never before with travel, photo & document views. Personalize your inbox with themes & tabs. You've Got Mail!
Tables are ideal for presenting information in a row-and-column format. You create Wikipedia tables using wiki markup, which begins with "{|" and ends with "|}". Since you'll edit tables much more often than create them, this section begins with editing. (To see how to create a wikicode table, skip to the section about creating tables.)