Search the Confluence 4.1.x Documentation:

Index
Downloads (PDF, HTML & XML formats)
Other versions

This documentation relates to Confluence 4.1.x
If you are using an earlier version, please view the previous versions of the Confluence documentation and select the relevant version.
Skip to end of metadata
Go to start of metadata

The Confluence editor provides several table editing features.

Inserting a Table

To create a table:

  1. While editing the page, place your cursor at the point where you want to insert the table.
  2. Click Table on the toolbar.
  3. Click in a cell to set the number of columns and rows for your table.

Table Operations

While editing a page, the following table operations are available from the toolbar.

Table operation

Toolbar button

Insert an empty row above the current one

 

Insert an empty row below the current one

 

Remove the current row

 

Cut the current row and copy it to the Clipboard

 

Copy the current row to the Clipboard

 

Paste the row from the Clipboard to the current row

 

Insert an empty column to the left of the current one

 

Insert an empty column to the right of the current one

 

Remove the current column

 

Merge the selected cells

 

Split the selected merged cells

 

Highlight the current row

 

Highlight the current column

 

Highlight the current cell

 

Remove the table

 

Related Topics

Take me back to the Confluence User's Guide.

Labels:
  1. May 15, 2008

    Anonymous

    Hi, 

    I wanted to copy a table created in word to wiki. When I copied, the whole format changed, and also, it doesnt allow merge tables which is such a disappointment.

    1. Jun 09, 2008

      Hi there,

      There are discussions available in our Issue Tracker system related to the reported problems, please see:

      Feel free to add yourself as a watcher so that you will be notified if there are updates on the issue.

      Cheers,
      Tony

  2. Jun 04, 2008

    Anonymous

    Is there a way to further format a table? For example:

    • Center text within a column?
    • Highlight or add color to certain rows?
    • Change the size of the font in certain cells?

    If not, can this be added as an enhancement request? 

    Thanks!

    1. Jun 09, 2008

      Hi,

      There are some other macros that you can use to achieve the above such as:

      Hope the information helps.

      Cheers,
      Tony

      1. Jul 01, 2009

        Note, though, that the highlight and color macros aren't native to Confluence, and highlight only serves to color text background, not the entire background color of a row or column.

        1. Sep 14, 2009

          Anonymous

          Pls add this functionality. like highlighting certain rows.

  3. Jul 21, 2009

    Hi,

    As far as I know, this feature is not currently available in Confluence. However, I have found a similar feature request. Please add yourself as a watcher, vote for this feature and add your own comments to this feature request. For further details on how we include new features and improvements, you might want to read this page

    Cheers
    JSashi

  4. Oct 16, 2009

    Anonymous

    Hi

    How can i sort a table contents by column 1, column 2, column 3...... by using Rich Text method.

    Regards,

    Mouttou

    1. Oct 19, 2009

      Hi Mouttou,

      How can i sort a table contents by column 1, column 2, column 3...... by using Rich Text method.

      As far as I know, the feature requested is not available yet. However, I found a feature request in JIRA:

      Please add your comments to the discussion, vote on it and add yourself as a watcher for future updates. Also, please bear in mind the following document on how we schedule features for inclusion in our products: Implementation of New Features and Improvements.


      Hope that helps.
      Best rgds,
      Zed

  5. Dec 10, 2009

    Anonymous

    Hi,

    Is there any way to resize columns of a table instead of just the whole table?

    Thank you!

    Cosmina

    1. Jan 04, 2010

      Hello Cosmina,

      Currently, this is not supported. You might want to raise an improvement request in our issue tracker if you are keen on it.

      Alternatively, you may use the Column Macro and Section Macro which provide column-specific width support.

      Hope this helps.

      Cheers,
      Azwan

  6. Feb 17, 2010

    Anonymous

    Hi

    could you please advise me on how to change the table colour?

    thanks

    Sajeev

    1. Feb 17, 2010

      Hi Sajeev,

      As far as I know, this feature is not currently available in Confluence. However, I have found a similar feature request. Please add yourself as a watcher, vote for this feature and add your own comments to this feature request. For further details on how we include new features and improvements, you might want to read this page.

      As a workaround, you could change the cell colors by modifying the Custom HTML which you can access at Dashboard > Administration > Look and Feel > Custom HTML. Use the following code within the "At end of the HEAD" section:

      Please bear in mind that the above code will change all table colors globally. Hope this helps.

      Cheers
      JSashi

      1. Feb 17, 2010

        Anonymous

        Thanks a lot Sashi.

  7. Mar 24, 2010

    Anonymous

    Hi,

         When I combine the MySQL and Confluence3.1, I meet the trouble.

    In macro browser, I can't use to insert info, gallery,tasklist,widget,

    table and other macros.

         When I insert macro, the alert is "There has been an error loading

    the macro browser.Please try again or see your system administrator".

         How should I do?

    Thank you.

                                                  Monica

    1. Mar 24, 2010

      Hi Monica,

      It might be this bug.

      See this KB article for more info.

      If you still need help, raise a support request

      Cheers,
      Mark

  8. Aug 06, 2010

    Is it possible to cut and paste table columns as you can do with rows? I've not been able to determine a way, but sure would be helpful. :)

    1. Aug 20, 2010

      Hi Julie,

      I am afraid that this is not currently possible.However, I have found a similar improvement request. Please add yourself as a watcher, vote for this improvement and add your own comments to this request. For further details on how we include new features and improvements, you might want to read this page

      Cheers
      JSashi

  9. Aug 16, 2010

    Anonymous

    Confluence is not drawing borders around cells in table as shown in the documentation.  Any ideas what the problem could be?

    1. Aug 19, 2010

      Hi,

      I am sorry I could not reproduce this error. I would suggest you to check whether is there any custom stylesheet or HTML that could cause this error.

      If that does not helps, please raise a support ticket at the following link:

      Please explain more on the issue you are facing, for example the Confluence version, which browser you are using etc.

      Hope this helps.

      Regards,
      HengHwa

      1. Feb 07, 2012

        HengHwa, he is probably talking about tables that are placed inside of a {panel} macro. For some reason, no version of Confluence has ever rendered table/cell borders when the table is placed inside of a {panel} macro. (and possibly some other macros that produce a colored background, but I can't recall which other such ones I've noticed.)

  10. Aug 31, 2010

    I'd like to use a form to allow users to edit a wiki table. Ideally, users would be presented with the extant table rows, a blank set of form entries or pop-ups (for row fields that take one of a set of fixed values), and a button to submit the entered data as a row to the table.

    How can I do this?

    1. Sep 01, 2010

      It sounds me that this feature is provided by the Scaffolding Plugin. You might also want to check out the Dynamic Table plugin.

      1. Sep 30, 2010

        Thanks; I'm using the Scaffolding Plugin.

        How does one set up a table with Scaffolding that allows the reader to sort the rows by clicking table column headers?

        I know how to do this with a table-plus but I don't know how to do this with Scaffolding.

        I'm currently using the following:

        {table-data:Licenses}
        || Software package || Version || License code or serial number || Platform || Quantity (seats) || Notes ||
        | {text-data:SoftwarePackage|initialRows=12} | {text-data:Version} | {text-data:License} | {list-data:Platform}{list-option:MacOS}MacOS{list-option}{list-option:Windows}Windows{list-option}{list-option:GNU/Linux}GNU/Linux{list-option}{list-data} | {text-data:Quantity} | {text-data:Notes}_none_{text-data} |
        {table-data}
        

        And how does one specify CSS with Scaffolding tables?  I'd like to make it so that one column in the table has white-space: nowrap.

        Thanks for your help.

        1. Aug 26, 2011

          Anonymous

          Just wrap the table-data with a table-plus, works a treat, as does table-filter. Auto total on a table-data that's wrapped in table-plus and table-filter will ignore the first row, irrespective of macro parameters. 

  11. Sep 28, 2011

    Anonymous

    Is there a way to change an existing table cell <td> into table header cell <th>?

    1. Sep 28, 2011

      Anonymous

      Related issue: https://jira.atlassian.com/browse/CONF-20310

      Marked as "resolved" at 16 September 2011.

  12. Sep 28, 2011

    Is there any way to make a column in the table of a fixed width?

  13. Oct 11, 2011

    Anonymous

    him im trying to populate this table 

    {checklist:name=The pets names|parent=Animals|label=pets}
    {checklist-label:Mammal?|label=mammal}
    {checklist-metadata:Comments}
    {checklist-input:Common pet names|cols=20}
    {checklist}

    having no such luck 

    is there away of doing this? im trying to add it to my wiki page

     

  14. Oct 31, 2011

    Anonymous

    We need better table support across the board.  Basically, the table in confluence should at least support the features that basic html gives you.  I should be able to specify a background color, cell width, wrapping etc.

  15. Nov 09, 2011

    Anonymous

    How do I copy a table from wiki syntax to Confluence? Seems like I have to press enter after each line to trigger the editor parsing (save/preview does not work as expected), but that doesn't give me the table I want (new line inserted between each row in the table). I'm trying to copy some rather large tables from docuwiki and JIRA.

    1. Nov 09, 2011

      If you are using Confluence 4.0, you can use the 'Insert Wiki Markup' dialog to paste in the entire table.

      You can open the dialog either from the 'Insert' menu or using keyboard shortcut Ctrl+Shift+D.

      1. Nov 10, 2011

        Anonymous

        Yes, that worked fine! Feel I should have figured out that one...anyways: Thanks!

        (Wouldn't hurt to mention this in a section on this page tho).

  16. Nov 16, 2011

    Anonymous

    Is it possible to link multiple tables within Conflence so that when an update is made to the data in one table, that update would be reflected in all of the tables?

  17. Nov 17, 2011

    Anonymous

    Is there a way to center a table on page width? I am able to center test on cells but I am not able to center the pable on page width.

  18. Nov 18, 2011

    Anonymous

    Is there way that I can use this in template?

  19. Nov 23, 2011

    Hi,

    We're using the table plugin with Confluence 4.0, but our biggest problem is that we can't edit our exisiting tables. We have to go through and re-write every table by hand. Do you have a solution how we can just go through and edit the table header?

    Thanks for the info.

  20. Dec 07, 2011

    Anonymous

    Hi,

    I am trying to populate a table with the values coming from a form. Is that possible in Confluence? Is there a plugin for that.

    Thanks,

    Bogdan

  21. Dec 15, 2011

    Hi there,

    how do I convert a table into normal text? Any ideas? Currently I'm pasting the table into a text editor, copy it again from there, and paste it into confluence. (sad)

    Thanks for your help!

  22. Dec 15, 2011

    Is there a way to convert an already-entered table back into wiki markup, so you can make changes that are apparently not possible in the WYSIWYG editor? Working with the editor is about as painful a way to do tables as I have seen anywhere.

  23. Dec 16, 2011

    Anonymous

    How to remove table borders in confluence 4?

  24. Dec 19, 2011

    Anonymous

    How can i align the data in the dynamic table content ?

  25. Jan 05, 2012

    Anonymous

    Is there a way to hide and show the contents of a column in a table? I have a column that contains comments and only want to see the comments if the user chooses to do so. Otherwise, the size of this column affects the rest of the table display.

  26. Jan 18, 2012

    Anonymous

    A useful hack can be to add an additional row at the end of the table, and add dummy urls in each cell, of varying length.  It seems that confluence refuses to 'fold' these, so they give you some control over the column width.  changing their colour means you can then hide them if required.  Found this out by accident when copying and pasting a table from an excel sheet containing an url... 

    1. Feb 07, 2012

      Wow! I had not thought of this hack. Excellent advice! I am shamelessly stealing it and adding it to my "how-to" just a bit further below, because I want to ensure I bring this tidbit back into our internal "Confluence tips" if we decide to migrate to 4.x.

      Edit: I found a better way. It seems that any contiguous string with no spaces in it will not be wrapped by the script that renders the table columns. Even if you drag the border of the browser window such that the table is now wider than the window itself. So no need for URLs: just any random string of characters will suffice. Technique shown further below.

  27. Jan 19, 2012

    Anonymous

    hi...

        am having one requirement... can we give link to an entire row of a tabe... how do we give..

    Thank you for your answers

  28. Feb 07, 2012

    I suggest you beef up this topic (or create a sub-topic) that explains and demonstrates some specific techniques that won't be intuitive or easy to figure out. Over in the 4.0 feedback thread there was some thrashing about this, and in our own internal test plans for 4.x migration (from 3.5.x) we also had to scratch our heads and figure out some new ways of achieving certain rendered table outputs.  Well, here ya go, feel free to plunder for your content as you see fit.

     

    Atlassian moderators/writers: Please don't remove this comment until I remove this notice. If my company eventually migrates to 4.x (still uncertain), I will want to copy this content back into our own "Confluence tips" space. Because that space is currently 3.5.x there is no way for me to source this information there, and our 4.1 test environment is volatile. Basically, I'm using this comment as temporary source code, lol. (smile)

     

    Balanced tables versus unbalanced tables

    balanced table is the standard rectangular grid with symetrical rows and columns. This is the type of table that the 4.x editor will make by default, especially when you paste a group of cells into another cell.

    Original balanced table
     
    ABC
    123
    456
    789

    Now select the entire table, then copy it with Ctrl-C and paste it into cell 9 with Ctrl-V...

     

     

    New table is still balanced

     

    ABC  
    123  
    456  
    78ABC
      123
      456
      789

     

    Note that if you merge the blank cells by using the new 4.x editor's Merge table cells button, the resulting table is still balanced. (In the following example, the merged cells' content was then center-justified by using the new Align Center button in the editor.)
     

    ABC  
    123

    456

    78ABC






    123
    456
    789

    Also note that to simulate sub-headings within a table, you can select individual cells and use the Cell highlightbutton in the editor.

    ABC  
    123  
    456  
    78ABC
      123
      456
      789

     

    You can also add shading to entire rows and columns with the Row highlight and Column highlight buttons.

    Important and Urgent Important but Not Urgent
    Task A Task C
    Task B 

    Task D

    Not Important but Urgent Not Important and Not Urgent
    Task E Task F
    Task G Task H

    An unbalanced table has uneven borders and asymmetrical rows and columns. Creating this type of table requires some manual work.

    A

    B

    C

    1

    2

    3

    4

    5

    6

    7

    8

    1

    2

    3

     

     

    4

    5

    6

     

     

    7

    8

    9

     

    To create this unbalanced table, you must use Insert > Wiki Markup and then enter the following markup syntax. When you click Insert in the Wiki Markup window, you get the result shown at the left. However, this is a one-way trip; once you click Insert, you can make further structural changes only by working directly in the XML storage format via the new Advanced Editor.

     

    Tables within tables

    To create tables within tables, the basic pattern is to use the Table button (or its corresponding shortcut Ctrl-Shift-I) inside the exact cell where you want to create the sub-table. For example, assuming the following top-level table...

    AB
    12

    ...If you want to place a sub-table in cell 2, select the contents of cell 2 and then use the Table button (or press Ctrl-Shift-I) and specify the size of the sub-table. Then fill in the contents of the sub-table like so:

    AB
    1
    sAsBsC
    s1s2s3
    s4s5s6

    If you then wanted to add a similar sub-table in cell 1, you must likewise manually add a new table into cell 1 by selecting cell 1, inserting the new table, and then either manually filling in the columns of the new sub-table or else copy and paste the original sub-table by placing your cursor inside the top-left row of the newly-inserted sub-table (but not selecting the entire cell) and then pasting the copied sub-table.

    Important: To copy the entire contents of one table (or sub-table) into another, the two (sub)tables must be exactly the same number of rows and columns, and you must not select the entire cell or table of the target table when you do your paste. You can easily undo (Ctrl-Z) if you mess up the paste and get an unexpected result. To get a successful paste, just place your cursor inside the top left cell of the target table.

    AB
    sAsBsC
    s1s2s3
    s4s5s6
    sAsBsC
    s1s2s3
    s4s5s6

    A hack to control the width of columns in tables

    Atlassian will hopefully someday add the ability to specify exact column widths in tables. In the meantime, you can use a hack to force column widths:

    1. Add a row at the bottom of the table.
    2. In each cell of the bottom row, add a continuous string of characters with no spaces. In my example below, I just drummed my right fingers on the four "home" keys of my keyboard.
    3. Adjust the length of each string to "force" the column width you want for each column. Confluence will not auto-wrap unbroken strings like this, so you can widen or narrow a column by adding more or fewer characters to each string.
    4. To hide the strings when you're finished, select each one and then use the Colour button to make the text of the string the same color as the background of the cell.

    Here's an example, with only the string at the bottom of column C colored white to make it invisible.

    ABCD
    1234
    5678
    9101112
    lkj;ljlkj;lkj;lkj;lkj;lkj;l;lkj;lkj;lkj;lkj;lkjl;kj;kj;kj;lkj;;j;kj;j;lkj;lkj;lkj;lkj;lkj;lkj;lkj;lj;lkj;lkj;lkj;lkj;lkj;lkj;lkj;lkj;lkj;lkj;lk

    If you don't want the "empty" row at the bottom of the table, a variation of this technique is to put a line break (Shift-Enter) in each cell of the table's bottom row and put the string after the line break. In this example, all such strings were added to cells 9-12 and then colored white to hide them.

    ABCD
    1234
    5678
    9
    lkj;ljlkj;lkj;lkj;lkj;lkj;l;lkj;lkj;lkj;lkj;lkj 
    10
    l;kj;kj;kj;lkj; 
    11
    ;j;kj;j;lkj;lkj;lkj;lkj;lkj 
    12
    ;lkj;lkj;lj;lkj;lkj;lkj;lkj;lkj;lkj;lkj;lkj;lkj;lkj;lk 
    1. Feb 07, 2012

      Hallo Shannon

      That's pretty cool information. Would you like to sign the Atlassian Contributor License Agreement and edit the docs directly? (smile)

      Cheers, Sarah

      1. Feb 08, 2012

        Thanks Sarah, and I was tempted. But frankly clause 8 in the agreement is untenable. It essentially says I can be directly sued for damages if people suffer ill-consequences from using my contributed content. I'd prefer to submit my ideas in comment form (like this one) because the context is clearly one of user-community feedback and helpful suggestions rather than being perceived as first-class "how to" doc from the company that produces the product. Remove clause 8 from the agreement and you'll probably get more willing outside contributors.