Shift+Mouse Drag | Select rows |
Ctrl+Shift+Mouse Drag | Deselect rows |
Mouse Drag row headers | Select rows |
Shift+drag column headers | Select columns |
Ctrl+click column headers | Select columns |
Ctrl+Shift+click column headers | Deselect columns |
(Ctrl+) Shift + ↑↓ | (Un)select rows |
(Ctrl+) Shift + ←→ | (Un)select columns |
(Ctrl+) Shift + mouse-drag | (Un)select rows |
(Ctrl+) Shift + ENTER | (Un)Select rows with the current value |
Ctrl + Shift + Home | Select rows above current |
Ctrl + Shift + End | Select rows below current |
Up, Down, Left, Right | Navigate |
Page Up, Page Down | Navigate |
Ctrl+Home | Jump to first row |
Ctrl+End | Jump to last row |
Home | Jump to first column |
End | Jump to last column |
Double-click column header | Sort |
Menu | Current Column | Sort | Sort |
Double-click | Edit cell |
Ctrl+C | Copy cell |
Ctrl+V | Paste into cell |
Ctrl+click | Invert column selection |
≡ | Open column filter |
Drag column header | Reorder columns |
Drag column header border | Resize columns |
Drag row header border | Copy cell |
Menu -> Column sizing | Batch sizing options |
Menu | Color coding | On/Off | Turn color-coding on/off for all columns |
Menu | Color coding | Color scheme | Select a palette |
Summary columns is a way to visualize multiple values numerical across the row. This feature is useful for quick visual profiling of values. In the following picture, each inline viewer visualizes the values of five numerical columns, which allows for quick visual comparison between rows.
The following summary column types are available:
- Sparkline
- Bar Chart
- Radar
- Pie Bar Chart
- Markup
To add a summary column: Menu | Add | Summary Columns
An HTML (or Markdown) template that renders row values can be embedded in each row.
To add a default form: Menu | Add | Forms | Default To add a custom form: Menu | Add | Forms | Custom...
See also: