---
title: "Set up the Advanced Table Viewer macro features"
canonical: "https://support.appfire.com/space/TBL/1765147138/Set%20up%20the%20Advanced%20Table%20Viewer%20macro%20features"
format: markdown
---
> Macro (aura-html)
The Advanced Table Viewer macro setup mode enables you to configure macro features. It is a full-screen view to provide data visibility and a smoother configuration experience of data source and table display options.
- The macro provides column filtering, row styling, column drag-and-drop, column grouping, search, row numbering, sorting, pagination, download, rename heading, and column and group calculation. You can configure these features and access them in both Confluence page view and edit mode.
- The macro enables the search and sort feature by default when you insert it for the first time.
- Pagination turns on automatically if the table has more than 10 rows, displaying 10 rows per page by default.
- The features configured in macro setup mode are saved as the default for every refresh of the Confluence page.
> Macro (refined-tabs)
>
> > Macro (refined-tab)
>
> To configure the features, navigate to the macro’s setup mode. Only users with edit permissions can access it.
>
> > 📝 - When you insert and configure the Advanced Table Viewer macro, you will navigate to the setup mode before saving the macro.
> > 📝 - To know about the various terms and modes used in the macro, refer to the [Advanced Table Viewer macro glossary](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1765245023).
>
> 1. Open the Confluence page containing the Advanced Table Viewer macro.
> 2. Edit the Confluence page.
> 3. Edit the Advanced Table Viewer macro to open the setup mode.
>
> 
>
> 4. The macro setup mode opens in full-screen view.
> - The left panel displays a preview of the data imported from the data source.
> - The right panel displays the available feature configurations.
> - To enable or disable a feature, click the specific icon.
> 5. The feature configurations are available at the table and column level. Refer to the Table and column properties section.
>
> > ℹ️ To configure the Advanced Table Viewer macro for CSV and Excel data sources, refer to:
> > ℹ️
> > ℹ️ - [Configure CSV data source in Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1782972884)
> > ℹ️ - [Configure Excel data source in Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/3122888898)
>
> > Macro (refined-tab)
>
> - The right panel toolbar displays the available feature configuration at the table level.
> - The table properties apply to the entire table, affecting all columns and rows within a single macro.
> - In the right panel, you can enable or disable the macro table features.
>
> | **Table properties** | **Description** | **Default value** | **Read more** |
> | --- | --- | --- | --- |
> | Column filtering
( ) | Configure column filters for individual columns and filter table data based on specific column values. | OFF | [Filter columns with Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/2001437596) |
> | Row styling
( ) | Apply row colors and highlight table rows using the row styling feature. | OFF | [Row styling with Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1864990849) |
> | Grouping
( ) | Interactively group and organize your table data on the Confluence page, with support for nested grouping across multiple columns. | OFF | [Group columns with Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/3211755580) |
> | Search
( ) | Perform a dynamic search on the imported table data. The search feature is enabled by default. | ON | [Search with Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1764920560) |
> | Row numbering
( ) | Display a column with row numbers. | OFF | - |
> | Sort
( ) | Sort the column values in ascending and descending order. | ON | [Sorting with Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1540654640) |
> | Download
( ) | - Download the table data as a CSV file.
> - When enabled, the download button is displayed at the top right of the table in the Confluence view and edit page mode.
> - On clicking **Download**, the file gets downloaded to your local file system. | OFF | - |
> | Pagination
( ) | - Navigate large datasets efficiently on the Confluence page using the previous, next, and direct page number controls.
> - Displays the current row range and total row count (for example, showing 1–10 of 55 rows).
> - Set the number of rows displayed per page using the **Rows per page** option. | ON if the table consists of more than 10 rows per page | - |
>
> > 📝 To edit the Data Source in the setup mode, click **Edit Data Source **on the right panel. The *Data Source* dialog opens. For more information, refer to [Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1531117698).
> > 📝
> > 📝 
>
>
> > Macro (refined-tab)
>
> - The column features apply specifically to the configured table columns.
> - The macro offers **Rename heading,** **column calculation, **and** group calculation**. To set up the column properties for a specific column, click *Edit column* ( ).
>
> | **Column properties** | **Description** | **Default value** | **Read more…** |
> | --- | --- | --- | --- |
> | Rename heading | Rename the column header. | - | [Rename the table column name with Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1940817034) |
> | Edit column calculation | Perform column-level calculation and display the Sum, Average, Minimum, Maximum, Count, and Distinct for column values. | None | [Column calculation with Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/1540654683) |
> | Edit group calculation | Perform column calculations and display summarized values at each level of the nested group. | None | [Column group calculation with Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/3219587079) |
> | Column drag-and-drop
( ) | Reorganize table columns using drag-and-drop in macro setup mode. | - | [Column drag-and-drop with Advanced Table Viewer macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/3398172705) |