Summer Keyboard Shortcuts

Summer is designed for keyboard-first data work. Shortcuts follow three guiding principles:

Consistent modifiers —
⌘ Command
is the base action,
⇧ Shift
adds an alternate form,
⌥ Option
adds a variant, and
⌃ Control
is reserved exclusively for column operations.
Left-hand friendly — column commands use ⌃ with letters clustered left, so the right hand stays on the mouse for column selection.
Mnemonic — the key matches the first letter of the action (⌃S Sort, ⌘F Find & Filter, ⌘L Lookup).

Many panels support a repeat-shortcut pattern: pressing the opening shortcut a second time activates something deeper within the panel rather than toggling it closed.

Column Commands

These shortcuts act on the currently selected column (or columns). They use ⌃ (Control) exclusively — and the letter is always mnemonic. All column commands are intentionally clustered on the left side of the keyboard so the right hand stays on the mouse for column selection while the left hand operates the command.

Click a column header to enter column mode. ⇧-click or use ⇧← / ⇧→ to extend the selection. Space adds the current column to a sticky multi-column selection without holding a modifier.

Organize

Shortcut	Action	Notes
`⌃S`	Sort	Sort the table by this column. Press again to reverse sort, then again to clear.
`⌃G`	Group	Group rows by this column's values. Press again on the same column to ungroup.
`⌃P`	Pin	Pin the column to the left edge so it stays visible during horizontal scroll.
`⌃M`	Mark / Bookmark	Toggle a bookmark on the selected column(s).
`⌃F`	Mark / Bookmark	Toggle a bookmark on the selected column(s).
`Space`	Add to Selection	Add this column to the sticky multi-column selection without holding `⇧`.
`⌫`	Hide Column	Move the column to the hidden state. Restore it from the Schema panel.
`⌃C`	Copy Column Number	Copy the 1-based column number of the selected columns.
`⌃←`	Contract Width	Reduce the column's display width.
`⌃→`	Expand Width	Increase the column's display width.
`⌃⇧←`	Move Column Left	Reorder the column one position to the left.
`⌃⇧→`	Move Column Right	Reorder the column one position to the right.
`Esc`	Clear selection	Deactivate column highlight

Quick Filter

Apply an instant filter on the selected column without opening the filter panel.

Shortcut	Action	Notes
`⌃D`	Show Duplicates	Filter to rows where this column has a duplicate value.
`⌃E`	Show Errors	Filter to rows where this column contains an error or invalid value.
`⌃B`	Show Blanks	Filter to rows where this column is empty.
`⌃O`	Show Outliers	Filter to rows where this column's value is a statistical outlier.
`⌃V`	Show Valid	Filter to rows where this column has a valid, non-blank value.
`⌃L`	Show Lookup Matches	Filter to rows where this column has a matching entry in the configured lookup table.
`⌃A`	Show All (Clear Filter)	Remove the current column filter and show all rows.
`⌃=`	Show True / Show False	Filter boolean state—good to combine with Quick Compare.

Column Roles & Types

Shortcut	Action	Notes
`⌃1`	Set / Unset as Key	Mark the column as the primary key for join and lookup operations.
`⌃2`	Set / Unset as Dimension	Mark the column as a grouping dimension (categorical, not aggregated).
`⌃3`	Set Type: Number	Interpret the column as a decimal number.
`⌃4`	Set Type: Money	Interpret the column as a currency amount.
`⌃5`	Set Type: Percent	Interpret the column as a percentage value.
`⌃6`	Set Type: Text	Interpret the column as plain text.
`⌃7`	Set Type: Category	Interpret the column as a categorical value (shows color chips for distinct values).
`⌃8`	Set as Sensitive	Toggle the column's sensitive flag, which masks or redacts its values.

Display Formatting

Shortcut	Action	Notes
`⌃T`	Cycle Summary Function	Cycle the column footer through Sum → Average → Min → Max → Count → none.
`⌃,`	Toggle Rounding / Format	For number columns: toggle rounding. For other types: cycle display format.
`⌃0`	Toggle 2 or 0 decimal places	Quickly switch between 0 and 2 decimal places
`⌃.`	Cycle Decimal Places	Cycle displayed decimal precision: 0 → 1 → 2 ... 6 → auto.
`⌃=`	Toggle Friendly Values	Toggle between raw values and formatted display (e.g., 1000000 → 1M).
`⌃R`	Toggle Raw Mode	Show the raw stored value instead of the formatted display value.

Grid Navigation

Arrow key behavior changes depending on whether you are in row mode (a row is selected) or column mode (a column header is selected).

Row mode

Shortcut	Action
`↑` / `↓`	Move row selection up / down.
`⇧↑` / `⇧↓`	Extend row selection up / down.
`⌘↑` / `⌘↓`	Jump to first / last row.
`⌥↑` / `⌥↓`	Scroll up / down one page.
`←` / `→`	Scroll the viewport left / right by one column.
`⌘←` / `⌘→`	Scroll the viewport to the first / last column.
`⌥←` / `⌥→`	Scroll the viewport left / right one full page width.

Column mode

Shortcut	Action
`←` / `→`	Move column selection left / right.
`⇧←` / `⇧→`	Extend column selection left / right.
`⌘←` / `⌘→`	Jump column selection to first / last column.
`⌘⌥←`	Jump to Previous Selected Column
`⌥←` / `⌥→`	Scroll the viewport left / right one full page width.
`↑` / `↓`	Scroll the viewport up / down one row.
`⌘↑` / `⌘↓`	Scroll the viewport to the top / bottom.
`⌥↑` / `⌥↓`	Scroll the viewport up / down one page.

Any mode

Shortcut	Action
`Page Up` / `Page Down`	Scroll the viewport up / down one page.
`Space`	Lock / unlock the current selection — it persists while clicking elsewhere.
`Esc`	Clear the current selection; deactivate bookmark highlight if no bookmark filter is active.

Navigate

Move through rows, columns, groups, and bookmarks without lifting your hands from the keyboard.

Find

Shortcut	Action	Notes
`⌘F`	Find and Filter…	Open the Find & Filter panel. Repeat: re-focuses the search field when already open.
`⌘⇧F`	Quick Find…	Open the jump bar in Find mode for a fast inline search.
`⌘G`	Find Next	Jump to the next search or filter match.
`⌘⇧G`	Find Previous	Jump to the previous search or filter match.

Jump

Shortcut	Action	Notes
`⌘J`	Jump to Column…	Open the jump bar to navigate to a column by name or number.
`⌘⇧J`	Jump to Row…	Open the jump bar to navigate to a specific row number.
`⌘⌥←`	Jump to Previous Column	Return to the last column that was selected before the current one.

Groups

Requires grouped rows (created with ⌃G on a column). Group navigation takes priority over tab switching when groups are active.

Shortcut	Action	Notes
`⌘[`	Previous Group	Move to the previous group at the current nesting level.
`⌘]`	Next Group	Move to the next group at the current nesting level.
`⌘⇧[`	Previous Group + Select	Navigate to the previous group and select all its rows.
`⌘⇧]`	Next Group + Select	Navigate to the next group and select all its rows.
`⌃[`	Previous Group (expanding)	Navigate to the previous group and expand it if collapsed.
`⌃]`	Next Group (expanding)	Navigate to the next group and expand it if collapsed.
`⌘⌃[`	Previous Top-Level Group	Jump to the previous outermost group.
`⌘⌃]`	Next Top-Level Group	Jump to the next outermost group.
`⌘⌃⇧[`	Previous Top-Level Group + Select	Navigate to the previous outermost group and select all its rows.
`⌘⌃⇧]`	Next Top-Level Group + Select	Navigate to the next outermost group and select all its rows.
`⌥[`	Collapse Group	Collapse the best candidate visible group.
`⌥]`	Expand Group	Expand the first collapsed group.
`⌘⌥[`	Collapse Group Level	Collapse the deepest currently-open level across the whole table.
`⌘⌥]`	Expand Group Level	Expand the shallowest collapsed level across the whole table.

Bookmarks

Shortcut	Action	Notes
`⌘B`	Bookmarks Panel	Open the Bookmarks panel. Repeat: toggle the active bookmark category on/off.
`F2`	Next Bookmark	Jump to the next bookmarked row or column.
`⇧F2`	Previous Bookmark	Jump to the previous bookmarked row or column.
`⌘F2`	Toggle Bookmark	Add or remove a bookmark on the current selection.
`⌘⇧F2`	Toggle Bookmark Highlighting	Toggle visual highlight of all bookmarked rows/columns.
`⌘⌥F2`	Clear All Bookmarks	Remove all bookmarks in the current category.

Table Panels

These shortcuts open the side panel to the named tool. Pressing the shortcut again while the panel is open performs a secondary action — noted in Repeat.

Shortcut	Panel	Notes & Repeat-Shortcut Behavior
`⌘I`	Overview	Show the table summary: row/column counts, type distribution, and per-column statistics.
`⌘/`	Table Schema	Show column types, roles, and metadata. Edit column names, types, and display settings here.
`⌘F`	Find and Filter…	Open the filter panel focused on the search field. Repeat: re-focuses the search field.
`⌘L`	Lookup…	Enrich the table by matching values to a reference table. Repeat: fills the "Matching Against" table from the current column selection.
`⌘=`	Compute and Transform…	Open the formula editor to create or transform a computed column.
`⌘D`	Duplicates…	Find, highlight, and remove duplicate rows based on selected key columns.
`⌘K`	Combine Tables…	Join two tables side-by-side on a shared key column.
`⌘⌥K`	Split Table…	Divide a table into two output tabs based on a column value. Repeat: re-evaluates the current column selection.
`⌘⌥I`	Insert Clipboard Data…	Parse clipboard data and append it as new columns. Re-parses clipboard each time invoked.

Filtering

Multiple shortcuts create or modify filters directly without opening the filter panel.

Shortcut	Action	Notes
`⌘F`	Find and Filter…	Open the Filter panel (see Table Panels above).
`⌘⌃F`	View Filtered Rows in New Tab	Open the currently-filtered rows as a new filter-view tab.
`⌘⌃⇧F`	Filter using Selection Criteria	Build a filter rule from the selected cell value and apply it immediately.
`⌘⇧B`	Filter using Bookmarked Rows	Show only rows that have a bookmark in the active category.

Quick Compute

With one or more columns selected, these shortcuts create a computed column immediately without opening the Compute panel. Summer infers the operation from the column types — if the types don't match a defined formula, the Compute panel opens instead.

Shortcut	Action	Type Behavior
`⌘⇧+`	Add / Sum / Join	2 numbers → add · Multiple numbers → SUM · Text → JOIN with comma · Number + Percent → increase by % · Date + Number → add days
`⌘⇧–`	Subtract / Range / Split	2 numbers → subtract · Multiple numbers → range (max−min) · Text → SPLIT on comma · Number + Percent → decrease by % · 2 dates → days between
`⌘⇧%`	Ratio	2 numbers → divide A ÷ B and express as a ratio
`⌘⇧*`	Product	2 numbers → multiply · Number + Percent → percent of number
`⌘⇧&`	Concat / Average	Text → concatenate · Numbers → average
`⌘⇧)`	First Value	Multiple columns → return the first non-blank value (COALESCE)
`⌘⇧L`	Max / Length	Numbers → maximum value · Text → maximum text length
`⌘⌃=`	Compare	Return True/False whether selected columns are equal
`⌘⇧?`	If / Else	2 columns → if A then A else B · 3 columns → if A then B else C
`F9`	Recompute Now	Update all computed columns — refresh based on new sort or filter

App & Window

Global commands that work from any window or when no document is open.

Shortcut	Action	Notes
`⌘,`	Settings	Open the View Settings panel for the active table.
`⌘O`	Open…	Open a CSV or TSV file in a new window.
`⌘⇧O`	Add Table from File…	Open a file as a new tab in the current window.
`⌘⇧V`	Add Table from Clipboard	Parse clipboard text as a new tab.
`⌘⌃I`	Import…	Launch SummerDB to import a database or spreadsheet.
`⌘⌃E`	Open in Spreadsheet	View data in your spreadsheet app.
`⌘⇧E`	Open in Editor	View data in your text editor app.
`⌘S`	Save / Export…	Open the Export panel to save the active table.
`⌘⌥S`	Export Selection…	Open Export panel scoped to the current selection.
`⌘W`	Close Tab	Close the active tab; closes the window when the last tab is closed.
`⌘⇧W`	Close Window	Close the active window.
`⌘⌥W`	Close All Windows	Close all open Summer windows.

Tabs

Each file opens as a workbook with one or more table tabs. Tabs can be plain tables, filter views (green), or combined/joined tables.

Shortcut	Action	Notes
`⌘T`	New Tab…	Add an empty tab to the current window, or open a new window if none is open.
`⌘⌃T`	New Tab — Copy All Rows	Duplicate the active table into a new independent tab.
`⌘⌃F`	New Tab — Copy Filtered Rows	Create a filter-view tab from the current active filter.
`⌘⌃S`	New Tab — Copy Selection	Open the current row selection as a new tab.
`⌘⌃C`	New Tab — Copy Selected Columns	Open only the selected columns as a new tab, preserving selection order.
`⌘{`	Previous Tab	Switch to the tab to the left.
`⌘}`	Next Tab	Switch to the tab to the right.
`⌘1` – `⌘9`	Jump to Tab 1–9	Switch directly to a numbered tab.
`⌘⇧T`	Show / Hide Tab Bar	Toggle the tab strip at the top of the window.

Edit & Clipboard

Summer provides multiple copy formats for pasting into other apps, and several ways to analyze a selection before copying.

Shortcut	Action	Notes
`⌘C`	Copy	Copy the selection as a tab-separated table (headers + rows).
`⌘⇧C`	Copy as Markdown	Copy as a Markdown pipe table.
`⌘⌃⇧C`	Copy as Values Only	Copy the values without column headers.
`⌃C`	Copy Column Number	Copy the 1-based column number of the selected columns.
`⌘E`	Use Selection for Find	Load the selected cell value into the Find field.
`⌘⇧U`	Copy Unique Values (Sorted)	Copy deduplicated values from the selected column, sorted A–Z.
`⌘⇧D`	Copy Duplicate Values (Sorted)	Copy only values that appear more than once, sorted A–Z.
`⌘⌥I`	Insert Clipboard Data…	Parse clipboard content and add it as new columns.
`⌘⌥E`	Export Selection…	Open the Export panel scoped to the current selection.
`⌘⌥⌫`	Empty Trash	Permanently delete all hidden rows and hidden columns.

View

Control the display of the grid, split panes, font size, and side panel visibility.

Shortcut	Action	Notes
`⌘⇧I`	Highlight Intersection	Toggle cell intersection highlighting when both a row and column are selected.
`⌘⇧$`	Display in Default Currency	Toggle currency conversion for money columns.
`⌘\`	Split Right	Toggle a side-by-side horizontal split of the active table.
`⌘⌃\`	Split Down	Toggle a top-bottom vertical split of the active table.
`⌘⌥\`	Synchronize Split	Toggle synchronized vertical scrolling between split panes.
`⌘⌥+`	Increase Font Size	Zoom the grid text in.
`⌘⌥–`	Decrease Font Size	Zoom the grid text out.
`⌘⌥0`	Reset Font Size	Return to the default font size.
`⌘⇧\`	Show / Hide Side Panel	Toggle the inspector/action panel on the right side of the window.
`⌘Esc`	Reset All	Clear all filters, grouping, sorts, and pinned columns; restore all hidden rows and columns.

Keyboard Reference

esc⎋

delete⌫

tab⇥

{[

}]

control

return↩

shift⇧

control⌃

option⌥

command⌘

←

↑

↓

→