| Info |
|---|
The Table Spreadsheet macro is available for Confluence Cloud only. Soon available for Server and Data Center. |
The Table Spreadsheet macro allows you to add an Excel-like spreadsheet. You can work with it both in the page view and page edit mode.
Adding the Table Spreadsheet macro
1. Insert the macro on a page:
Start entering /Table Spreadsheet and select the macro
- On the editor pane, click Insert -> View more, find the macro and insert it on the page
| Info |
|---|
The page stores your spreadsheet as an attachment. You can find more information about the attachment or download the file in the page settings. |
| Handy Carousel |
|---|
|
Main functions of the Table Spreadsheet macro
- Cell format
- Text settings (font, size, type, color)
- Cell color
- Border style and color
- Alignment and text placement
- Merging cells
- Freezing rows
- Automatic functions
- Multiple sheets
Filtering the spreadsheet
- Click the funnel icon on the editor pane
- To sort the spreadsheet, choose the sorting type
- To filter the spreadsheet, select a column and click Create filter
- Choose a condition to filter the column by
- Confirm the settings or clear the filter, if no longer needed
| Handy Carousel |
|---|
|
Adding a pivot table
- Select the pivot table macro on the editor pane
- On a new sheet, choose the settings
| Handy Carousel |
|---|
|
Adding a chart
- Select the chart macro on the editor pane
- Choose chart settings
| Info |
|---|
The following chart types are available:
|
| Handy Carousel |
|---|
|
Conditional formatting
- Select a table
- Choose Conditional formatting on the editor pane
- Select a suitable formatting preset or set your own rule
