> ## 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.

# Spreadsheet basics

> Learn the core spreadsheet features in Sourcetable — cells, sheets, navigation, and data entry.

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

## Navigation

* **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

## Hyperlinks

* **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