Help:Table


 * For a basic introduction, see the Introduction to tables on Wikipedia. For style considerations, see Manual of Style/Tables, also on Wikipedia.

A table is an arrangement of columns and rows used to organize and position data. Tables can be created on wiki pages using special wikitext syntax, and there are many different styles and tricks that can be used to customise them.

Tables on finiki
The Wikipedia standard for tables uses  and can get automatically generated by using the table button on the Edit toolbar, which results in: The same table using the Table, which is intended is used to standardize the appearance of Excel to Wiki generated tables, results in:

Clearly there is an inconsistency in the format depending on which method is used. Editors are reminded to exercise careful consideration before choosing which method is used. For consistency reasons, the general guideline for finiki is to follow Wikipedia's Manual of Style. Any exceptions are covered in finiki:Manual of Style.

Centering the columns of a table
If you want to have columns centered in a table, then add  after   which results in:

Or for aligning some specific cells left and right:

Sortable tables
Tables can be made sortable by adding the CSS sortable; for details see Help:Sorting. Since this can be very useful, it is wise to keep the possibilities and limitations of this feature in mind when designing a table.

Sortable wikitables look like this:

Row highlighting
allows for row highlighting. This makes it easier to follow the data and info across a row, especially in wider tables. Scroll your cursor over the tables below to see the light blue banding in the tables with.

From Excel to a sortable wikitable
To start in Excel and end up with a sortable wikitable in finiki, follow these instructions:


 * 1) Prepare your table in MS Excel. Don't bother with any formatting: it will be lost
 * 2) Copy the relevant cells in the buffer (Ctrl-c)
 * 3) Paste the contents (Ctrl-v) in Excel to Wiki
 * 4) Delete the unneeded blank line at the end
 * 5) Unselect “format header”, click on “convert”
 * 6) Copy the converted result in the buffer (Ctrl-c) and paste it (Ctrl-v) in finiki
 * 7) Replace  by , and add   if needed
 * 8) For the first line of the table, replace  by   as shown here
 * 9) Voilà!

How to deal with long column titles
Use line breaks, such as in the following table:


 * {| class="wikitable" style="text-align:center"

! ! Annualized standard deviation (%) ! Maximum annualized return (%) ! Minimum annualized return (%)
 * One year rolling||5.8||29.0||-19.1
 * 5 years rolling||2.9||4.8||-9.5
 * 10 years rolling||2.0||3.7||-4.8
 * 20 years rolling||0.9||1.8||-1.6
 * }
 * 10 years rolling||2.0||3.7||-4.8
 * 20 years rolling||0.9||1.8||-1.6
 * }
 * }

Other table tips
Tables are also helpful to format figures and notes. For example, this table aligns two figures side-by-side (from Risk and return): 

Here's an example to embed table notes. This table utilizes the "rowspan" and "colspan" properties (from Risk and return):

