Skip to main content

Documentation Index

Fetch the complete documentation index at: https://sourcetable.com/docs/llms.txt

Use this file to discover all available pages before exploring further.

Sourcetable gives you a full-featured spreadsheet that works like Excel or Google Sheets. If you’ve used either, you already know how to use Sourcetable.

​
Workbooks and sheets

A workbook is your top-level document. Each workbook contains one or more sheets, accessible via tabs at the bottom of the screen.
  • Click the + button next to the sheet tabs to add a new sheet
  • Double-click a tab to rename it
  • Right-click a tab for options like duplicate, delete, or reorder
  • Use Shift+F11 to quickly insert a new sheet

​
Entering data

Click any cell and start typing to enter data. Press Enter to confirm and move down, or Tab to confirm and move right.
  • Edit a cell — double-click it or press F2
  • New line within a cell — press Option+Enter (Mac) or Alt+Enter (Windows)
  • Cancel an entry — press Esc
  • AutoSum — select a range and press Option+= (Mac) or Alt+= (Windows)

​
Selection

  • Select a row — Shift+Space
  • Select a column — Ctrl+Space
  • Select all — Cmd+A (Mac) or Ctrl+A (Windows)
  • Extend selection — hold Shift and use arrow keys
  • Select by word — hold Cmd+Shift (Mac) or Ctrl+Shift (Windows) and use arrow keys
  • Jump to first/last row — Cmd+Up/Down (Mac) or Ctrl+Up/Down (Windows)
  • Jump to first/last column — Cmd+Left/Right (Mac) or Ctrl+Left/Right (Windows)
  • Go to cell A1 — Cmd+Home (Mac) or Ctrl+Home (Windows)
  • Switch sheets — Cmd+Page Down/Up (Mac) or Ctrl+Alt+Page Down/Up (Windows)

​
Copy, paste, and fill

  • Copy — Cmd+C / Ctrl+C
  • Cut — Cmd+X / Ctrl+X
  • Paste — Cmd+V / Ctrl+V
  • Fill down — select a range starting with the source cell, then press Cmd+D / Ctrl+D
  • Fill right — select a range starting with the source cell, then press Cmd+R / Ctrl+R
  • Fill handle — drag the small square at the bottom-right corner of a selection to extend a pattern

​
Rows and columns

  • Insert rows/columns — Cmd+Shift+= (Mac) or Ctrl+Shift+= (Windows)
  • Delete rows/columns — Cmd+Option+- (Mac) or Ctrl+Alt+- (Windows)
  • Hide rows — Cmd+9 / Ctrl+9
  • Hide columns — Cmd+0 / Ctrl+0
  • Unhide rows — Cmd+Shift+9 / Ctrl+Shift+9
  • Unhide columns — Cmd+Shift+0 / Ctrl+Shift+0

​
Freeze panes

Freeze rows or columns to keep headers visible while scrolling. Go to View > Freeze Panes and choose:
  • Freeze top row
  • Freeze first column
  • Freeze at current selection
  • Insert or edit a hyperlink — Cmd+K (Mac) or Ctrl+K (Windows)
  • Open a hyperlink — Option+Enter (Mac) or Ctrl+Enter (Windows)

​
File compatibility

Sourcetable supports importing and exporting:
  • XLSX — full Excel compatibility
  • CSV — comma-separated values
  • JSON — structured data
  • PDF — export for sharing and printing