What keyboard shortcuts can I use in LUSID web grids?

Prev Next

You can use keyboard shortcuts to move around, select, copy and edit data in LUSID web grids. Web grids are the data tables you see on dashboards such as Holdings, Transactions and Rebalance.

On macOS, use ⌘ Cmd wherever this article lists ^ Ctrl.

Some shortcuts only work in certain grids:

  • Editable grids: The shortcut only works in grids where you can edit cells directly. Currently, this is the Rebalance dashboard.

  • Rebalance: The shortcut only works on the Rebalance dashboard.

Moving around the grid

Shortcut

Action

← ↑ → ↓

Move to the neighbouring cell.

^ Ctrl + ← ↑ → ↓

Jump to the first or last cell in that direction.

Page Up / Page Down

Scroll up or down one page.

⇥ Tab / ⇧ Shift + ⇥ Tab

Move to the next or previous cell.

Selecting cells and rows

Shortcut

Action

⇧ Shift + ← ↑ → ↓

Extend your cell selection.

⇧ Shift + click a cell

Extend your cell selection to the cell you click.

^ Ctrl + click a cell

Add the cell to your selection.

^ Ctrl + A

Select all cells.

␣ Space (on a row with a checkbox)

Tick or untick the row.

⇧ Shift + click a row checkbox

Tick every row between the last row you ticked and this one. (Rebalance)

^ Ctrl + click a row checkbox

Tick or untick only this row. (Rebalance)

Click a row checkbox inside a highlighted cell selection

Tick every row your selection covers. (Rebalance)

Copying, cutting and pasting

Shortcut

Action

^ Ctrl + C

Copy the selected cells. LUSID copies values exactly as the grid displays them.

^ Ctrl + X

Cut the selected cells. (Editable grids)

^ Ctrl + V

Paste into the selected cells. If you copied fewer cells than you selected, LUSID repeats the copied cells to fill your selection. (Editable grids)

^ Ctrl + D

Fill down: copy the top row of your selection into the rows below it. (Editable grids)

Drag the fill handle

Fill the cells you drag across. The fill handle is the small square at the bottom-right corner of your selection. (Editable grids)

You can also right-click a cell and select one of these options:

  • Copy: copy the selected cells.

  • Copy with headers: copy the selected cells and their column headers.

  • Copy raw value (numeric columns only): copy the full-precision number, without thousands separators.

Editing cells (editable grids)

Shortcut

Action

Start typing

Start editing and replace the cell's value.

␣ Space

Start editing and keep the cell's current value.

F2

Start editing and keep the cell's current value.

⌫ Backspace / Delete

Clear the selected cells.

↵ Enter (when not editing)

Move down one row.

↵ Enter (when editing)

Save your edit.

⎋ Esc

Cancel your edit.

⇥ Tab / ⇧ Shift + ⇥ Tab (when editing)

Save your edit and move right or left.

↑ / ↓ (when editing)

Save your edit and move up or down.

If you save an edit at the edge of the grid, you stay on the same cell. The grid does not move you to another row.

Editing several cells at once (Rebalance)

These shortcuts work on the Rebalance dashboard when bulk edit mode is on.

Shortcut

Action

Select several cells, type a value, then press ↵ Enter or ⇥ Tab

Write the value to every selected cell you can edit. Your selection stays in place.

^ Ctrl + ↵ Enter

Write the value to every selected cell you can edit, in the same way as a spreadsheet.

If you press ↵ Enter without changing the value, LUSID does not update the other selected cells.

Column headers

Shortcut

Action

⇥ Tab / ← ↑ → ↓

Move between column headers.

↵ Enter

Sort by the column.

Context Menu key, ⇧ Shift + F10, or ⌥ Alt + ↓

Open the column menu.

␣ Space

Rename the column.

↵ Enter (when renaming)

Save the new column name.

⎋ Esc (when renaming)

Cancel the rename.

⇥ Tab / ⇧ Shift + ⇥ Tab (when renaming)

Save the new name and move to the next or previous header.

Grouped rows

Shortcut

Action

↵ Enter (on a group row)

Expand or collapse the group.

Column menu: grouping by date

Shortcut

Action

↵ Enter / ␣ Space (on Custom date format)

Open the custom format box.

↵ Enter (in the format box)

Apply the format.

⎋ Esc

Close the menu.