The Spreadsheet toolbar

Save and export

Icon	Feature	Description
	Save	Saves the current state of your workbook without leaving the Spreadsheet editor
	Export to Excel	Exports your workbook as an Excel document (.xlsx format)

Document history

Icon	Feature	Description
	Undo	Cancels the last action applied on your workbook
	Redo	Re-applies the last canceled action on your workbook

Formatting cells

Data contained in the document cells can be formatted with various formats. Applying a format on a cell changes the way its content is displayed, but the value remains the same (the real value is displayed inside the status bar).

Standard formatting

Formatting

Description

Text

This is the default cell format. No transformations are applied on the cell content.

Number

Displays the cell content as a number, right-aligned. If the cell value is not a number, the cell content is not transformed.

Percentage

Same effect as the "Number" format. Also add a percent symbol after the number.

Example: "0.58" is transformed to "58%"

Currencies

Currencies are formatted according to your Confluence instance language.

Formatting	Displayed currency
Dollar	$
Euro	€
Indian Rupee	₹
Pound Sterling	£
Russian Ruble	₽
Swiss Franc	CHF
Japanese Yen	¥

Date and Time

You can use the '//' (double slash) Confluence shortcut to add a date into a cell.

Formatting	Description
Date	Displays the cell content as a Confluence date, editable via a date picker.
Time	Displays the cell content as a Confluence time, editable via a date picker.
Date & Time	Displays the cell content as a Confluence date and time, editable via a date picker.

Styling cells

Basic styles

Icon	Feature	Description
	Bold	Emphasis the current cells content selection
	Italic	Sets the italic style on the current cells content selection
	Underline	Underlines the current cells content selection
	Strike through	Strikes the current cells content selection
	Foreground color	Applies the selected color on the cells content selection. You can change the foreground color by clicking on the arrow on the right.
	Background color	Applies the selected color on the cells background content selection. You can change the background color by clicking on the arrow on the right.
	Border	Sets the selected border on the cells content selection. You can change the border by clicking on the arrow on the right
	Clear format	Removes any styles from the current cells content selection. Also reset cells format to "Text".

The font size can be changed by using this bottom drop-down list :

Decimal places

Icon

Feature

Description

Reduce decimal place

Reduces the number of digits after the decimal separator

Example: "0.58" is transformed to "0.6"

Add decimal place

Increases the number of digits after the decimal separator

Example: "0.58" is transformed to "0.580"

Alignment

Icon	Feature	Description
	Horizontal left	Horizontally aligns the current cells content selection to the left
	Horizontal center	Horizontally aligns the current cells content selection to the center
	Horizontal right	Horizontally aligns the current cells content selection to the right
	Vertical top	Vertically aligns the current cells content selection to the top
	Vertical center	Vertically aligns the current cells content selection to the middle
	Vertical bottom	Vertically aligns the current cells content selection to the bottom

Document structure

Icon	Feature	Description
	Merge	Unifies many cells as one. In case of content conflict, the data from the up-left cell is conserved.
	Split	Separates merged cells
	Insert row before	Inserts a new row before the select one.
	Insert row after	Inserts a new row after the select one.
	Delete row	Deletes the selected row(s)
	Insert column before	Inserts a new column before the select one.
	Insert column after	Inserts a new column after the select one.
	Delete column	Deletes the selected column(s)

Others

Icon	Feature	Description
	Function insertion	Replaces the active cell content with an '=' to start writing a formula