Skip to main content

Table Editing

It fundamentally offers a user editing experience similar to Excel.
Editing mode starts with Enter.

demo-table-edit

Adding Columns

Created using the shortcut Alt + Enter.

Tab Key

Allows direct entry into the next cell's editing mode using Tab.
Creates a new column in the last cell.
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)

Can paste from the editor to Excel or vice versa.
However, for specific columns, true/false are supported as follows (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

Possible through the table context menu or shortcut Alt + K.

demo-column-pk