page properties report macro column width

• Jira Software
• Jira Work Management
• Jira Service Management
• Atlassian Access
• Company News
• Continuous Delivery
• Inside Atlassian
• IT Service Management
• Work Management

Best practices for working with tables in Confluence

Follow these tips to get information across faster and with more clarity using Tables in Confluence.

Contributing Writer

Get stories about tech and teams in your inbox

For most office workers, it’s difficult to imagine a workday without tables. They help us track and communicate progress, assets, budgets – virtually any information that needs to be calculated, stored or sorted.

If Confluence is your primary work environment, you’ve probably used the tables feature – but it might be more robust than you think. Aside from the standard grid of information, you can also organize and compute data by using Confluence’s suite of associated apps . By doing so, you’ll realize that there’s no need to use any other tools for depicting and processing tables, especially since native Confluence features already allow you to create tables, customize them, and make them engaging and interactive.

Confluence has lots of powerful tools that will help you organize your tables neatly and conveniently. You can manage product requirements, resourcing plans, or other project information using a wide array of macros , such as Page Properties and Page Properties Report or Task Reporting Table. Plus, with pre-defined blueprints , it will take you no time at all.

Let’s dig deeper into the best practices for working with tables in Confluence and see everything in action from basic features to more advanced techniques.

Structure your data for faster comprehension using Confluence’s native customization tools

Create engaging Confluence pages in 4 easy steps

After you create a table in Confluence, there are many things you can do to make it look exactly the way you want.

Format your table’s layout to get all the information in one view

Tables can help communicate lots of information in one glance but only if the cells display all the information in a comprehensible way. Define your table layout using the following tips. 

• Use the button with two horizontal arrows to make the table as wide as the page or adjust it to the center. You can choose one of three table sizes.
• Set the width of each column. Hover over the borders of a column, and drag until it reaches the right size.
• To make columns the same width, select them and click the down arrow. Select the “Distribute columns” option.

Communicate faster visually with cell formatting

You can help people find specific topics or groups of information at a glance using color coding or images. Here are a few native Confluence tools to help you get started:

• Merge several cells by selecting them, clicking the down arrow, and choosing “merge cells.” You can also split the cells but only if they were merged before.
• Organize your tables with headers by clicking on “Table Options” at the bottom of the table and choosing whether you want to set a header row or a header column. There is also the extra option of adding a numbered column that is useful in case you have a large list in your table – simply choose “Numbered column,” and it will appear on the left side of the table.
• Use different colors to highlight certain cells. Select the cell(s) and click the down arrow, then choose your color in “Cell background.”

Familiarize yourself with native tools to communicate effectively with Confluence tables

Confluence has plenty of other fun tools to help you create clear, scannable information: 

• Fill your table up with statuses. Add the Status macro by typing “ /status ” in the cell or selecting it from the macros at the top toolbar. Name your status and choose its color.
• Specify dates with the Date macro. Add the macro to the cell and select a specific date from the interactive calendar.
• Make your table more fun and engaging with emojis. You can use them in place of statuses or to visually mark data. Click the smiley face icon at the top toolbar to find all of the emojis.

For more tips, watch this video on how to customize your tables in Confluence.

Merge similar tables to get an overview of work across teams

Confluence also allows you to manage tables that contain similar data. If such tables are scattered around your workspace, you can merge them into one bigger table. This way, you can group information about separate tasks on one page or extract specific information from detailed project requirements, merging them in one table for a quicker overview.

You will use two macros in this case: Page Properties and Page Properties Report .

First, you need to add the Page Properties macro to the page and place a two-row or two-column table inside of it. Set a label for this page and other pages with similar tables. These labels will be used later in the Page Properties Report macro to pull out particular pages and form a table from them.

After wrapping all of your tables into the Page Properties macro, you can create a new page. Lastly, insert the Page Properties Report macro, select the labels you previously set, pick a space where these tables are located, and save the page.

Using predefined page blueprints makes the process even easier. You can create a template yourself, adding the specifically formatted tables and macros. Or you can use the ready-made blueprints, which already contain the Page Properties macro, such as the Product Requirements Blueprint .

For a little inspiration, you can watch a video on how to use the Page Properties and Page Properties Report macros.

Leverage Confluence table macros to keep projects on track

People who use Confluence for project management often set tasks on various pages. While it might be hard to keep track of these tasks if they are located in different places, it is possible to organize them in one table, especially if these tasks are related to a certain project. The process is simple.

Create a new page and add a Task Report macro to it. Configure its settings:

• Select a Space or Pages from which the tasks derive.
• Choose an assignee for the tasks.
• Pick a status for the tasks.
• Decide how to sort the tasks and which columns to display.

Save the macro and the page, and you’ll see a table with all of the tasks. You can mark them as done, and the status will be updated on the corresponding page, too.

If you use Jira to track your tasks, you can still create alignment and transparency across teams by linking Jira and Confluence and adding the Jira Macro . In the macro settings, you can select the project or issue(s) you want to display. You can even build charts on the basis of the underlying Issues or Projects in your Jira Issues table. Just click Jira Charts on the left when you are editing the Jira Macro.

Extend Confluence tables capabilities with Table Filter and Charts

If sharing, processing, and visualizing tabular data is critical for your team, it might make sense to invest in a Marketplace app to extend your capabilities. Table Filter and Charts for Confluence , for example, is a popular app among Confluence users:

• Filter tables. The Table Filter macro applies the most relevant filters to the table columns, such as dropdown or date filters. You only need to choose which data to depict.
• Group and calculate data. Use the Pivot Table macro to quickly compare values. Choose columns with repeated inputs to act as row and column labels and pick the type of calculation.
• Build charts and graphs. Turn tabular data into dynamic charts that you can change on the fly. The Chart from Table macro offers over 15 kinds of charts.
• Transform existing tables . Merge your tables using the integrated presets or perform a custom transformation with the help of SQL functions.
• Output tables from other sources. These custom table macros support files in CSV, TSV , or JSON formats, and tables from Google Sheets.
• Re-use tables on different pages. The Table Excerpt macro derives a table from one page, and the Table Excerpt Include macro depicts it in another place. You can also output source page metadata in the same table.

With an app like Table Filter and Charts for Confluence , you can add the Table Filter, Pivot Table, and Chart from Table macros in view mode by clicking on the funnel icon at the top of the table. The app suggests the most relevant options for each macro, but you can explore other charts right in view mode. 

If you want to make more drastic changes to your data analysis and visualization, you can go to edit mode and adjust settings until you get the desired result.

Confluence tables can be versatile and fun to work with. Take advantage of our best practices, and get creative with your tables to maximize their full potential.

This is a guest post written by Maria Kurnosenko, a content marketing specialist at Stiltsoft. Stiltsoft is an Atlassian Platinum Marketplace Partner with more than 20 apps for Confluence, Jira, and Bitbucket.

Advice, stories, and expertise about work life today.

How to Use Page Properties Macros in Atlassian Confluence

by Boris Berenberg | Apr 30, 2019

Adopting Confluence

Confluence spaces are set up – Check. You structured your page trees – Check. Only key stakeholders can view your sensitive information through space permissions and page restrictions – Check. Information that was once in silos is now available to the right people – Check. Gone are the days when employees searched for key information in email and Google drive. The office is buzzing with excitement about how easy it is to collaborate and how great it is to have a single place for all company information. Users are updating content and creating new content daily, if not hourly. Confluence adoption is an organization-wide success. But then it happens…

“How can I see all of my projects’ information in one place, at a glance?” “When I search for ‘Project ABC’ status I get over 20 results, and I can’t find the right page!” “Which project deadline is the earliest?”

Frequently Overlooked Macro Solution

How to use these macros.

Modus Create Expands Atlassian Services and Expertise with Atlas Authority Acquisition

May 11, 2022 | Company news

With the acquisition of Atlas Authority, Modus Create will further expand its team of Atlassian experts and certifications.

Financial Companies and the Cloud: 5 Trends

Apr 28, 2022 | Confluence , Jira

Spurred by the pandemic, financial companies have accelerated digital transformation, including cloud computing. Among many benefits, cloud technology helps financial companies meet the evolving needs of consumers and lower infrastructure costs. In the Atlassian world...

Techsplaining Vs. Human-Centric System Administration

Apr 12, 2022 | Confluence , Jira , Work better

Effective Atlassian administration requires us to look beyond technical requirements and understand the human aspect.

Table Filter and Charts with Page Properties Report

Atlassian Confluence is a powerful and feature-rich platform for content management. The system and its built-in macros provide a comfortable space for collaboration among different teams. And using third-party apps, you can up the productivity and use Confluence to its full potential.

We start a series of video tutorials that will help you master Confluence and incorporate it into your everyday work.

Our first tutorial shows you the way to generate reports on specific page properties in Confluence. It also teaches you to filter, aggregate, and transform the data after creating the Page Properties report.

Confluence Page Properties and Page Properties Report macros

On any Confluence page, you can insert the Page Properties macro that allows you to define one or multiple properties to the page. These properties are placed within the specifically formatted table. The Page Properties Report macro further pulls these properties (the so-called metadata) from pages having specific labels and generates a table listing these properties.

This may be convenient when you deal with the pages storing similar content. With this macro, you can keep some information that can be further used for filtration or visualization.

The easiest way to use the Confluence Page Properties macro on your page is to create a blueprint and place the table with metadata and text hints there. This way, whenever a user creates a new page with a template, you will have the same data. That will keep consistency for all the pages based on the same blueprint.

To generate a content report, you need to create a page with the Page Properties Report macro. After that, select one or multiple page labels against which the list of pages will be generated.

Once you save the page, the macro generates the list of pages with metadata.

Learn more about using Spreadsheets in Confluence

Table Filter and Charts for Confluence with Page Properties Report

When you get a long list of data, you may find it useful to filter the content. The Table Filter and Charts for Confluence app will be a good tool to apply to Page Properties Report in this case.

This app allows you to:

• filter table data in many ways, choosing the most suitable filters
• generate pivot tables aggregating data against the specific parameters
• output charts and graphs visualizing your data series

Want to know how it works? Check out the video for key details.

The Jira macro helps us fetch the list of Jira issues and transform it into a table with user-defined columns. We’ll show you how to arrange Jira issues just right…

If you are an accountant, statistician, or analyst, you know MS Excel from A to Z. But how will you deal with tables if your company migrates to Confluence? No…

Confluence is an all-in-one collaboration hub that a lot of companies all over the world consider a must-have tool for teamwork. Confluence allows you to create and edit documents, share plans,…

We use cookies

We respect your privacy.

Your full name* Company name* Work email* What is your role?* СTO VP of Engineering Director of Engineering Engineering Manager Product Manager Software Engineer DevOps Other How many users are in your Bitbucket?* 0 - 49 50 - 149 150 - 499 500+

I consent to the processing of my personal data Privacy Policy

First Name* Last Name* Your location Your email* Phone Your preferred position* Resume/CV Cover Letter LinkedIn Profile

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

ColumnWidths property

• 6 contributors

Specifies the width of each column in a multicolumn combo box or list box.

object . ColumnWidths [= String ]

The ColumnWidths property syntax has these parts:

To separate column entries, use semicolons (;) as list separators. In Windows, use the list separator specified in the Regional Settings section of the Windows Control Panel to change this value.

Any or all of the ColumnWidths property settings can be blank. You create a blank setting by typing a list separator without a preceding value.

If you specify a -1 in the property page, the displayed value in the property page is a blank.

To calculate column widths when ColumnWidths is blank or -1, the width of the control is divided equally among all columns of the list. If the sum of the specified column widths exceeds the width of the control, the list is left-aligned within the control and one or more of the rightmost columns are not displayed. Users can scroll the list using the horizontal scroll bar to display the rightmost columns.

The minimum calculated column width is 72 points (1 inch). To produce columns narrower than this, you must specify the width explicitly.

Unless specified otherwise, column widths are measured in points. To specify another unit of measure, include the units as part of the values. The following examples specify column widths in several units of measure and describe how the various settings would fit in a three-column list box that is 4 inches wide.

In a combo box, the system displays the column designated by the TextColumn property in the text box portion of the control.

• Microsoft Forms examples
• Microsoft Forms reference
• Microsoft Forms concepts

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Was this page helpful?

Submit and view feedback for

Additional resources

Ask a question

Start a discussion.

• Jira Service Desk Jira Service Management
• Jira Work Management
• Confluence Confluence
• Trello Trello

Community resources

• Announcements
• Technical support
• Documentation

Atlassian Community Events

• Atlassian University
• groups-icon Welcome Center
• groups-icon Featured Groups
• groups-icon Product Groups
• groups-icon Regional Groups
• groups-icon Industry Groups
• groups-icon Community Groups

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Level 1: Seed

25 / 150 points

1 badge earned

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Join now to unlock these features and more

Come for the products, stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Page Properties Report shows double pages

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Suggest an answer

Still have a question?

Get fast answers from people who know.

Was this helpful?

• confluence-server
• Community Guidelines
• Privacy policy
• Notice at Collection
• Terms of use
• © 2023 Atlassian

Confluence Support

Documentation, knowledge base.

• View account
• View requests

Jira Software

Project and issue tracking

Jira Service Management

Service management and customer support

Jira Work Management

Manage any business project

Document collaboration

Git code management

Usage and admin help

Answers, support, and inspiration

Suggestions and bugs

Feature suggestions and bug reports

Marketplace

Product apps

Billing and licensing

Frequently asked questions

• Log in to account
• Contact support
• Training & Certification
• Cloud Migration Center
• GDPR guides
• Enterprise services
• Atlassian partners
• User groups
• Automation for Jira
• Atlassian.com
• View in Confluence
• Manage Viewport
• Space Directory
• People Directory
• Column Macro
• Team Calendar Macro
• Advanced Roadmaps Macro
• Anchor Macro
• Attachments Macro
• Blog Posts Macro
• Change History Macro
• Chart Macro
• Cheese Macro
• Children Display Macro
• Code Block Macro
• Content by Label Macro
• Content by User Macro
• Content Report Table Macro
• Contributors Macro
• Contributors Summary Macro
• Create from Template Macro
• Create Space Button Macro
• Excerpt Include Macro
• Excerpt Macro
• Expand Macro
• Favorite Pages Macro
• Gadget Macro
• Gallery Macro
• Global Reports Macro
• HTML Include Macro
• IM Presence Macro
• Include Page Macro
• Info, Tip, Note, and Warning Macros
• Jira Chart Macro
• Jira Issues Macro
• Labels List Macro
• Livesearch Macro
• Loremipsum Macro
• Multimedia Macro
• Navigation Map Macro
• Network Macro
• Noformat Macro
• Office Excel Macro
• Office PowerPoint Macro
• Office Word Macro
• Page Index Macro
• Page Properties Macro
• Page Properties Report Macro
• Page Tree Macro
• Page Tree Search Macro
• Panel Macro
• Popular Labels Macro
• Profile Picture Macro
• Recently Updated Dashboard Macro
• Recently Updated Macro
• Recently Used Labels Macro
• Related Labels Macro
• Roadmap Planner Macro
• RSS Feed Macro
• Search Results Macro
• Section Macro
• Space Attachments Macro
• Space Details Macro
• Spaces List Macro
• Status Macro
• Table of Contents Macro
• Table of Content Zone Macro
• Task Report Macro
• User List Macro
• User Profile Macro
• View File Macro
• Widget Connector Macro

On this page

Related content.

• No related content found

Still need help?

The Atlassian Community is here for you.

Ask the community

Add the column macro to a page to organise your content in columns.  This macro is used in conjunction with the Section macro, and provides more flexibility than page layouts. 

This macro is great for situations where:

• you need more than three columns, or
• you need your columns to be a specific width. 

On this page:

Screenshot: page with a four column layout using the Section and Column macros.  

Want a simpler way to lay out your page? Try a page layout instead .

Add this macro to your page

Column macros must be added inside a page layout section, or within a Section macro. 

To add the Column macro to a page:

• Position your cursor inside the body of a Section macro, or page layout section. 

• Choose  Column  from the  Formatting  category.
• Choose  Insert . 

You can then start typing into the macro body, then publish your page to see the macro in action.

Screenshot: section and column macros in the editor

Change the macro parameters

Macro parameters are used to change the behaviour of a macro.

To change the macro parameters:

• Update the parameters as required then choose  Insert .

Here's a list of the parameters available in this macro. 

Where the parameter name used in Confluence storage format or wikimarkup is different to the label used in the macro browser, it will be listed below in brackets ( example ).

Other ways to add this macro

Add this macro as you type.

Add this macro using wiki markup

This is useful when you want to add a macro outside the editor, for example as custom content in the sidebar, header or footer of a space.

Macro name:   column

Macro body:  Accepts rich text.

Was this helpful?

Confluence Support

• Documentation

Set up Confluence Cloud

Get the high-level details you need to set up your Confluence Cloud site in order to meet your team's needs.

Create and organize work in Confluence Cloud

Learn how to create great content and organize it.

Collaborate on content and get notified in Confluence Cloud

Learn how to collaborate on pages and blogs, get notified about activity, and view analytics to see how content is performing.

Manage your account and permissions in Confluence Cloud

Adjust settings around who can see what content on your site and what actions they can perform on it.

Administer Confluence Cloud sites

Find everything a site admin needs to know to keep their Confluence Cloud site running smoothly.

Extend the functionality of Confluence Cloud

Get an overview of the macros and premium features that extend Confluence functionality.

Answers, support and inspiration

System Status

Cloud services health

Suggestions and bugs

Feature suggestions and bug reports

Marketplace

Product apps

Billing & licensing

Frequently asked questions

• Log in to account
• Contact support
• Training & Certification
• Atlassian Migration Program
• GDPR guides
• Enterprise services
• Atlassian Partners
• Success Central
• User groups
• Automation for Jira
• Atlassian.com

Insert the section macro

This macro was intentionally excluded from the new editor and will be deprecated from the legacy editor soon. Read the announcement for more. 

Used with the Column macro to define columns on a page. See Format a Confluence Page .

Wiki markup example

Wiki markup is useful when you need to add a macro outside the editor, for example as custom content in the sidebar, header or footer of a space.

Macro name:   section

Macro body:  Rich text, consisting of one or more Column macros.

Was this helpful?

Additional Help

• Review macros only available in the legacy editor
• Insert the recently used labels macro
• Insert the search results macro
• Insert the space attachments macro
• Insert the space details macro