{"id":7595,"date":"2022-05-03T13:13:46","date_gmt":"2022-05-03T11:13:46","guid":{"rendered":"https:\/\/actonic.de\/blog\/2022\/05\/03\/confluence-tabellen-sortieren-wie-ein-profi\/"},"modified":"2023-03-29T11:52:22","modified_gmt":"2023-03-29T09:52:22","slug":"confluence-table-sorting","status":"publish","type":"post","link":"https:\/\/actonic.de\/en\/confluence-table-sorting\/","title":{"rendered":"Confluence table sorting like a pro"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]With the Inline Table Editing add-on<\/strong><\/a>, you can. In this article, we’ll show you why you’ll love Confluence tables with this macro![\/vc_column_text][vc_video link=”https:\/\/www.youtube.com\/watch?v=os3Mj04G6hA&ab_channel=Actonic” align=”center”][vc_column_text]<\/p>\n

The problem with Confluence table sorting<\/h2>\n

Let’s take an ordinary table in Confluence. By default, it looks like this:<\/p>\n

[\/vc_column_text][vc_single_image image=”7573″ img_size=”full” alignment=”center” onclick=”link_image”][vc_column_text]<\/p>\n

Not particularly spectacular.<\/p>\n

To edit it in a conventional way, we must go through several steps.<\/p>\n

    \n
  1. \n

    Switch to the<\/span> edit mode<\/p>\n<\/li>\n

  2. \n

    Click into the cell \u2013 then an arrow appears<\/p>\n<\/li>\n

  3. \n

    Select the supposed sorting arrow and notice: Unfortunately, nothing can be sorted here<\/p>\n<\/li>\n<\/ol>\n

    [\/vc_column_text][vc_single_image image=”7575″ img_size=”full” alignment=”center” onclick=”link_image”][vc_column_text]<\/p>\n

    Because what seems like an option <\/span>for sorting, as we are used to it <\/span>from Excel, is only a dropdown menu that shows some functions. But these are not sufficient for daily work.<\/p>\n

    After all, we want to work with Confluence tables like we do with Excel! Confluence table sorting, data filtering or column reordering should work as time-saving and intuitive as possible.<\/p>\n

    The solution: Inline Table Editing<\/h2>\n

    And we can. Although Confluence does not offer any sorting or filtering functions for tables by default, with the Inline Table Editing<\/strong><\/a> add-on we can solve all table sorting problems at a stroke.<\/p>\n

    [\/vc_column_text][vc_column_text el_class=”info-box-general”]For detailed instructions on how to apply the macro to a table and use the numerous other function<\/span>s, it is best to read our article: Excel style in Confluence: filter tables, organize columns, calculate values.<\/a>[\/vc_column_text][vc_column_text]This makes the same table look completely different \u2013 even in view mode.[\/vc_column_text][vc_single_image image=”7577″ img_size=”full” alignment=”center” onclick=”link_image”][vc_column_text]<\/p>\n

    If you want to sort a Confluence table with Inline Table Editing, you have to do the following steps:<\/p>\n

      \n
    1. \n

      Click into the cell\/column<\/p>\n<\/li>\n<\/ol>\n

      Done.<\/span><\/p>\n

      You do not even need to switch to edit mode<\/span> anymore. You can make all changes directly in the view mode<\/strong>. Because you know the problem: In a complex table, you want to edit a single cell. As soon as you switch to edit mode, you end up at the top of the page and have to search for the corresponding cell again<\/span> all over again. This robs time and is the basis for many manual errors.<\/p>\n

      Confluence table sorting made easy<\/h3>\n

      With Inline Table Editing, the column header arrows keep their promise. A single click in view mode opens up numerous filtering options.<\/p>\n

      [\/vc_column_text][vc_single_image image=”7579″ img_size=”full” alignment=”center” onclick=”link_image”][vc_column_text]<\/p>\n

      Rearrange table columns<\/h3>\n

      Have you remembered after<\/span> updating that you have mixed up a few columns? No problem. Simply select the desired data and rearrange them using drag-and-drop. The numbering changes automatically.<\/span><\/p>\n

      [\/vc_column_text][vc_single_image image=”7594″ img_size=”full” alignment=”center” onclick=”link_image”][vc_column_text]<\/p>\n

      Sorting Confluence tables from A to Z<\/h3>\n

      A single click on the table header sorts the values from A to Z<\/strong>, from Z to A<\/strong> or back to how they were set from the beginning.<\/p>\n

      [\/vc_column_text][vc_single_image image=”7581″ img_size=”full” alignment=”center” onclick=”link_image”][vc_column_text]<\/p>\n

      Move table columns<\/h3>\n

      Table created, but columns ordered incorrectly? Using Inline Table Editing,<\/strong> you can correct that with one click. Not even Excel can do that!<\/p>\n

      [\/vc_column_text][vc_single_image image=”7583″ img_size=”full” alignment=”center” onclick=”link_image”][vc_column_text]<\/p>\n

      Sorting tables with filters<\/h3>\n

      To get a more detailed overview of your Confluence table, filters are the best choice. Here, you can filter the table data based on some predefined conditions. In the example, let’s display all the data that is in the “West” region.<\/p>\n

      [\/vc_column_text][vc_single_image image=”7585″ img_size=”full” alignment=”center” onclick=”link_image”][vc_column_text]<\/p>\n

      Sorting Confluence tables easier than ever before<\/h3>\n

      Inline Table Editing<\/strong> combines powerful Excel features with the intuitive handling of Confluence to give you a completely new and efficient user experience. There are many tools in the Atlassian Marketplace to sort Confluence tables. There are also some that you can use to filter data. But if you want to save time<\/strong> and use one tool for all editing cases<\/strong> that allows you <\/span>to make changes directly in view mode, Inline Table Editing<\/strong> is the ultimate answer.<\/span><\/p>\n

      These are the benefits the app brings:<\/strong><\/p>\n

        \n
      • \n

        Confluence table sorting made easy<\/p>\n<\/li>\n

      • \n

        Performance booster: lightning-fast changes directly in view mode<\/p>\n<\/li>\n

      • \n

        Full compatibility with Excel: copy your content without losing the formulas<\/p>\n<\/li>\n

      • \n

        Over 300 built-in mathematical functions<\/p>\n<\/li>\n

      • \n

        More features like: merge cells, set column width, calculate data<\/p>\n<\/li>\n

      • \n

        Convenient export to CSV<\/p>\n<\/li>\n<\/ul>\n

        Try the app now and overcome all previous Confluence table limitations!<\/p>\n

        [\/vc_column_text][vc_empty_space height=”52px”][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

        Sorting Confluence tables unfortunately does not always work as expected. Filtering data in Confluence, rearranging columns or moving entire cells is often anything but intuitive. We\u2019ll show you how to do it easily!<\/p>\n","protected":false},"author":15,"featured_media":7591,"comment_status":"open","ping_status":"open","sticky":false,"template":"single_cta.php","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[242],"tags":[342,281,296],"class_list":["post-7595","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles-atlassian-best-practises","tag-atlassian-best-practises","tag-confluence-en","tag-inline-table-editing-en"],"acf":[],"yoast_head":"\nConfluence table sorting like a pro - Actonic \u2013 Unfolding your potential<\/title>\n<meta name=\"description\" content=\"Confluence tables sorting \u2b50 easily and quickly filter and reorder data \u2705 with this unique tip \u2705 read now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/actonic.de\/en\/confluence-table-sorting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Confluence table sorting like a pro\" \/>\n<meta property=\"og:description\" content=\"Confluence tables sorting \u2b50 easily and quickly filter and reorder data \u2705 with this unique tip \u2705 read now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/actonic.de\/en\/confluence-table-sorting\/\" \/>\n<meta property=\"og:site_name\" content=\"Actonic \u2013 Unfolding your potential\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-03T11:13:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-29T09:52:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/actonic.de\/wp-content\/uploads\/2022\/05\/Confluence-Table-sorting-EN.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"585\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Patricia Modispacher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Patricia Modispacher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/\"},\"author\":{\"name\":\"Patricia Modispacher\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#\\\/schema\\\/person\\\/c700b8aadff4de9c01f096c78149a808\"},\"headline\":\"Confluence table sorting like a pro\",\"datePublished\":\"2022-05-03T11:13:46+00:00\",\"dateModified\":\"2023-03-29T09:52:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/\"},\"wordCount\":856,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Confluence-Table-sorting-EN.jpg\",\"keywords\":[\"Atlassian Best Practices\",\"Confluence\",\"Inline Table Editing\"],\"articleSection\":[\"Atlassian Best Practises\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/\",\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/\",\"name\":\"Confluence table sorting like a pro - Actonic \u2013 Unfolding your potential\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Confluence-Table-sorting-EN.jpg\",\"datePublished\":\"2022-05-03T11:13:46+00:00\",\"dateModified\":\"2023-03-29T09:52:22+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#\\\/schema\\\/person\\\/c700b8aadff4de9c01f096c78149a808\"},\"description\":\"Confluence tables sorting \u2b50 easily and quickly filter and reorder data \u2705 with this unique tip \u2705 read now!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/#primaryimage\",\"url\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Confluence-Table-sorting-EN.jpg\",\"contentUrl\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Confluence-Table-sorting-EN.jpg\",\"width\":1200,\"height\":585},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/confluence-table-sorting\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/actonic.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Confluence table sorting like a pro\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/\",\"name\":\"Actonic \u2013 Unfolding your potential\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/actonic.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#\\\/schema\\\/person\\\/c700b8aadff4de9c01f096c78149a808\",\"name\":\"Patricia Modispacher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g\",\"caption\":\"Patricia Modispacher\"},\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/author\\\/patricia-modispacher\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Confluence table sorting like a pro - Actonic \u2013 Unfolding your potential","description":"Confluence tables sorting \u2b50 easily and quickly filter and reorder data \u2705 with this unique tip \u2705 read now!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/actonic.de\/en\/confluence-table-sorting\/","og_locale":"en_US","og_type":"article","og_title":"Confluence table sorting like a pro","og_description":"Confluence tables sorting \u2b50 easily and quickly filter and reorder data \u2705 with this unique tip \u2705 read now!","og_url":"https:\/\/actonic.de\/en\/confluence-table-sorting\/","og_site_name":"Actonic \u2013 Unfolding your potential","article_published_time":"2022-05-03T11:13:46+00:00","article_modified_time":"2023-03-29T09:52:22+00:00","og_image":[{"width":1200,"height":585,"url":"https:\/\/actonic.de\/wp-content\/uploads\/2022\/05\/Confluence-Table-sorting-EN.jpg","type":"image\/jpeg"}],"author":"Patricia Modispacher","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Patricia Modispacher","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/#article","isPartOf":{"@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/"},"author":{"name":"Patricia Modispacher","@id":"https:\/\/actonic.de\/en\/#\/schema\/person\/c700b8aadff4de9c01f096c78149a808"},"headline":"Confluence table sorting like a pro","datePublished":"2022-05-03T11:13:46+00:00","dateModified":"2023-03-29T09:52:22+00:00","mainEntityOfPage":{"@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/"},"wordCount":856,"commentCount":0,"image":{"@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/#primaryimage"},"thumbnailUrl":"https:\/\/actonic.de\/wp-content\/uploads\/2022\/05\/Confluence-Table-sorting-EN.jpg","keywords":["Atlassian Best Practices","Confluence","Inline Table Editing"],"articleSection":["Atlassian Best Practises"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/actonic.de\/en\/confluence-table-sorting\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/","url":"https:\/\/actonic.de\/en\/confluence-table-sorting\/","name":"Confluence table sorting like a pro - Actonic \u2013 Unfolding your potential","isPartOf":{"@id":"https:\/\/actonic.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/#primaryimage"},"image":{"@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/#primaryimage"},"thumbnailUrl":"https:\/\/actonic.de\/wp-content\/uploads\/2022\/05\/Confluence-Table-sorting-EN.jpg","datePublished":"2022-05-03T11:13:46+00:00","dateModified":"2023-03-29T09:52:22+00:00","author":{"@id":"https:\/\/actonic.de\/en\/#\/schema\/person\/c700b8aadff4de9c01f096c78149a808"},"description":"Confluence tables sorting \u2b50 easily and quickly filter and reorder data \u2705 with this unique tip \u2705 read now!","breadcrumb":{"@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/actonic.de\/en\/confluence-table-sorting\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/#primaryimage","url":"https:\/\/actonic.de\/wp-content\/uploads\/2022\/05\/Confluence-Table-sorting-EN.jpg","contentUrl":"https:\/\/actonic.de\/wp-content\/uploads\/2022\/05\/Confluence-Table-sorting-EN.jpg","width":1200,"height":585},{"@type":"BreadcrumbList","@id":"https:\/\/actonic.de\/en\/confluence-table-sorting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/actonic.de\/en\/"},{"@type":"ListItem","position":2,"name":"Confluence table sorting like a pro"}]},{"@type":"WebSite","@id":"https:\/\/actonic.de\/en\/#website","url":"https:\/\/actonic.de\/en\/","name":"Actonic \u2013 Unfolding your potential","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/actonic.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/actonic.de\/en\/#\/schema\/person\/c700b8aadff4de9c01f096c78149a808","name":"Patricia Modispacher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g","caption":"Patricia Modispacher"},"url":"https:\/\/actonic.de\/en\/author\/patricia-modispacher\/"}]}},"jetpack_featured_media_url":"https:\/\/actonic.de\/wp-content\/uploads\/2022\/05\/Confluence-Table-sorting-EN.jpg","_links":{"self":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/posts\/7595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/comments?post=7595"}],"version-history":[{"count":0,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/posts\/7595\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/media\/7591"}],"wp:attachment":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/media?parent=7595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/categories?post=7595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/tags?post=7595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}