Skip to main content
Skip table of contents

Toolbar


The Spreadsheet toolbar


Save and export

IconFeatureDescription

SaveSaves the current state of your workbook without leaving the Spreadsheet editor

Export to ExcelExports your workbook as an Excel document (.xlsx format)


Document history

IconFeatureDescription

UndoCancels the last action applied on your workbook

RedoRe-applies the last canceled action on your workbook


Formatting cells

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).

More details about formatting cells feature


Styling cells

Basic styles

IconFeatureDescription

BoldEmphasis the current cells content selection

ItalicSets the italic style on the current cells content selection

UnderlineUnderlines the current cells content selection

Strike throughStrikes the current cells content selection

Text colorApplies the selected color on the cells content selection. You can change the text color by clicking on the arrow on the right or you can define your own custom color.

Background colorApplies the selected color on the cells background content selection. You can change the background color by clicking on the arrow on the right or you can define your own custom color.

BorderSets the selected border on the cells content selection. You can change the border by clicking on the arrow on the right

Clear formatRemoves any styles from the current cells content selection. Also resets cells format to "Text".


Custom color can be define with a color picker available for text color and background color.

User can define a maximum of 20 custom colors.


Custom colours for text and background



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

Set font size

Decimal places

IconFeatureDescription

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

IconFeatureDescription

Horizontal left

Horizontally aligns the current cells content selection to the left

Horizontal centerHorizontally aligns the current cells content selection to the center

Horizontal rightHorizontally aligns the current cells content selection to the right

Vertical topVertically aligns the current cells content selection to the top

Vertical centerVertically aligns the current cells content selection to the middle

Vertical bottomVertically aligns the current cells content selection to the bottom


Document structure

IconFeatureDescription

MergeUnifies many cells as one. In case of content conflict, the data from the up-left cell is conserved.

SplitSeparates merged cells

Insert row beforeInserts a new row before the select one.

Insert row afterInserts a new row after the select one.

Delete rowDeletes the selected row(s)

Insert column beforeInserts a new column before the select one.

Insert column afterInserts a new column after the select one.

Delete columnDeletes the selected column(s)


Headers and footers

IconFeatureDescription

Set a row(s) header(s)Define selected row(s) as header(s) of the sheet

Set a row(s) footer(s)Define selected row(s) as footer(s) of the sheet

Set a column(s) header(s)Define selected column(s) as header(s) of the sheet

More details about headers and footers features


IconFeatureDescription

Add linkApply an URL link on cell(s)

Remove link

Remove an URL link on cell(s)

Add an URL link

  • Click on the "Add link" button 
  • Use the following shortcut Ctrl+k

A form will open to apply the URL to selected cell(s) by clicking on the button Apply or press Enter on the keyboard.


Open an URL link

Both Ctrl+click or simple click on the given link will open it in a new tab, except for date data type which is only working with Ctrl+click to allow date modification by double click.


Edit an URL link

From selected cell(s), click on the arrow down next to the link feature button, the same form will open and is editable.


Remove an URL link

  • Click on the "Remove link" button 
  • Use the following shortcut Ctrl+k


Other

IconFeatureDescription

Function insertion

Replaces the active cell content with an '=' to start writing a formula

More details about formulas available

Set alternating row colors

Apply alternating row colors on the whole sheet

More details about alternating colors feature


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.