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

# Formatting

> Format cells, numbers, text, and styles in Sourcetable.

Sourcetable provides the same formatting options you'd expect from Excel or Google Sheets.

## Text formatting

Apply text styles using the toolbar or keyboard shortcuts:

| Format        | Mac           | Windows        |
| ------------- | ------------- | -------------- |
| Bold          | `Cmd+B`       | `Ctrl+B`       |
| Italic        | `Cmd+I`       | `Ctrl+I`       |
| Underline     | `Cmd+U`       | `Ctrl+U`       |
| Strikethrough | `Cmd+Shift+X` | `Ctrl+Shift+X` |

## Number formats

Apply number formats from the toolbar dropdown or with shortcuts:

| Format               | Shortcut       |
| -------------------- | -------------- |
| Number (with commas) | `Ctrl+Shift+1` |
| Date                 | `Ctrl+Shift+3` |
| Currency             | `Ctrl+Shift+4` |
| Percentage           | `Ctrl+Shift+5` |

Additional number formats available in the format menu:

* Scientific notation
* Fraction
* Accounting
* Financial
* Duration
* Time
* Custom formats

## Quick date entry

Press `Ctrl+;` to insert the current date into the selected cell.

## Cell appearance

### Colors

* **Text color** — change the font color of selected cells
* **Background color** — set cell fill color
* **Border colors** — customize border appearance

All color options support both preset palettes and custom hex values.

### Alignment

* **Horizontal alignment** — left, center, right, or justified
* **Vertical alignment** — top, middle, or bottom
* **Text overflow** — control how text behaves when it exceeds the cell width (clip, wrap, or overflow)

### Borders

Add borders to cells, ranges, or specific edges (top, bottom, left, right) via the toolbar border button.

## Conditional formatting

Apply rules to automatically format cells based on their values. Access conditional formatting from the **Format** menu. You can set rules based on:

* Cell value (greater than, less than, between, equal to)
* Text content (contains, starts with, ends with)
* Date ranges
* Custom formulas

## Decimal places

* **Increase decimal places** — add precision to number formatting
* **Decrease decimal places** — reduce precision

Both options are available in the toolbar number format section.