Skip to main content

Table Editing

Table editing basically offers an editing experience similar to Excel.
Editing mode starts with Enter.

demo-table-edit

Adding Columns​

Created using the shortcut Alt + Enter.
A column is added to every selected table.

Tab Key​

Press Tab to move straight into the next cell's editing mode.
Pressing Tab in the last cell creates a new column.
Use Shift + Tab to navigate to the previous cell's editing mode.

demo-table-tab

Selecting Multiple Columns​

Supports four methods:

  • Shift + Arrow Up/Down
  • Ctrl + click (Windows/Linux) or ⌘ + click (Mac)
  • Shift + click
  • Alt + A: Select All

demo-column-select

Rearranging and Moving Columns​

Functions when dragging, enabling movement to other tables.

demo-column-move

Supports moving multiple columns with Ctrl + drag (Windows/Linux) or ⌘ + drag (Mac).

demo-column-multi-move

Column Deletion​

Deletes the currently selected column.
Shortcut: Alt + Backspace or Alt + Delete

demo-column-remove

Copying/Pasting Columns​

Operates like a table-based clipboard.
Shortcuts: Ctrl + C (Windows/Linux) or ⌘ + C (Mac), Ctrl + V (Windows/Linux) or ⌘ + V (Mac)

You can paste from the editor into Excel and from Excel back into the editor.
For the columns below, any of these values is read as true (case insensitive):

  • AutoIncrement: TRUE, 1, YES, Y
  • Unique: TRUE, 1, YES, Y
  • Not Null: TRUE, 1, YES, Y, NOT NULL

demo-copy-column-to-sheet demo-copy-sheet-column

Supports actions when selecting multiple tables.

demo-copy-column-multi

Column Primary Key​

Set the selected column as a primary key from the table context menu or with the shortcut Alt + K.

demo-column-pk