The tables provide a variety of editing tools that facilitate data input and evaluation in 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 | Removes the content of the cell and saves it in the clipboard. | |
Copy | Ctrl + C | Copies the cell content to the clipboard. | |
Insert | Ctrl + V | Inserts 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 before. | |
Copy Row | Ctrl + + | Overwrites the next row with the content of the current row. | |
Empty Row | Ctrl + - | Deletes the content of the row without deleting the row itself. | |
Insert Row | Ctrl + I | Inserts a new, empty row. The subsequent rows are moved downwards. | |
Delete Row | Ctrl + R | Deletes the current row. The subsequent rows are moved upwards. | |
Select / Open | F7 | Opens a list or a dialog box for selection in a cell. | |
Edit in Dialog Box | Opens a dialog box where you can enter the data of the current row. |