The tables offer a variety of editing tools that make it easier for you to enter and evaluate data in the tables. You can access them using the table menus and buttons as well as the shortcut menus of table cells.
You can edit a table with the options common in Excel spreadsheets. The most important functions are summarized in the following overview.
| Function | Shortcut | Button | Effect |
|---|---|---|---|
| Cut | Ctrl + X | Remove the content of the cell and save it in the clipboard. | |
| Copy | Ctrl + C | Copy the cell content to the clipboard. | |
| Insert | Ctrl + V | Paste the content of the clipboard into the cell. If the content of the clipboard is larger than a cell, the cells of subsequent table columns and rows are overwritten. A warning is displayed beforehand. | |
| Copy Row | Ctrl + + |
|
Overwrite the next row with the content of the current row. |
| Empty Row | Ctrl + - |
|
Delete the content of the row without deleting the row itself. |
| Insert Row | Ctrl + I |
|
Insert a new, empty row. The subsequent rows are moved downwards. |
| Delete Row | Ctrl + R |
|
Delete the current row. The subsequent rows are moved upwards. |
| Select / Open | F7 |
|
Open a list or a dialog box for selection in a cell. |
| Edit in Dialog Box |
|
Open a dialog box where you can enter the data of the current row. |
