Formatting
Text Formatting
Section titled “Text Formatting”| Action | Shortcut |
|---|---|
| Bold | Ctrl+B |
| Italic | Ctrl+I |
| Underline | Ctrl+U |
| Strikethrough | Ctrl+5 |
You can also use the format bar buttons or the Format menu. Formatting is applied to all selected cells.
Format Painter
Section titled “Format Painter”Copy formatting from one cell and apply it to others:
| Action | Shortcut |
|---|---|
| Copy format | Ctrl+Shift+C |
| Paste format | Ctrl+Shift+V |
Usage:
- Select a cell with the formatting you want to copy
- Press
Ctrl+Shift+C(status bar confirms ”● Format copied from A1”) - Select one or more destination cells
- Press
Ctrl+Shift+Vto apply the format
All formatting properties are copied: bold, italic, underline, strikethrough, alignment, number format, and text overflow mode.
Horizontal Alignment
Section titled “Horizontal Alignment”Use the Format menu or format bar to set text alignment:
| Alignment | Description |
|---|---|
| Left | Text aligns to the left edge (default) |
| Center | Text is centered in the cell |
| Right | Text aligns to the right edge |
Vertical Alignment
Section titled “Vertical Alignment”| Alignment | Description |
|---|---|
| Top | Text aligns to the top of the cell |
| Middle | Text is centered vertically (default) |
| Bottom | Text aligns to the bottom of the cell |
Access via Format menu or Cell Inspector (Ctrl+1).
Number Formats
Section titled “Number Formats”| Format | Shortcut | Example |
|---|---|---|
| General | Ctrl+Shift+~ | 1234.56 (auto-detected) |
| Number | Ctrl+Shift+! | 1,234.56 |
| Currency | Ctrl+Shift+$ | $1,234.56 |
| Percent | Ctrl+Shift+% | 12.34% |
To adjust decimal places:
- Increase decimals: Use format bar
.00→.000button - Decrease decimals: Use format bar
.000→.00button
Text Overflow
Section titled “Text Overflow”Control how text behaves when it’s wider than the cell:
| Mode | Behavior |
|---|---|
| Clip | Text is cut off at the cell boundary (default) |
| Wrap | Text wraps to multiple lines within the cell |
| Spill | Text overflows into adjacent empty cells |
Spill behavior:
- Spill stops at the next non-empty cell
- Spill stops at cells with visual formatting (bold, italic, etc.)
- Maximum spill is 8 cells
Access text overflow via the Cell Inspector (Ctrl+1).
Column Width
Section titled “Column Width”| Action | Method |
|---|---|
| Resize column | Drag column border |
| Auto-fit column | Double-click column border |
| Auto-size column | Ctrl+0 |
Formatting Shortcuts Summary
Section titled “Formatting Shortcuts Summary”| Action | Shortcut |
|---|---|
| Bold | Ctrl+B |
| Italic | Ctrl+I |
| Underline | Ctrl+U |
| Strikethrough | Ctrl+5 |
| Copy format | Ctrl+Shift+C |
| Paste format | Ctrl+Shift+V |
| General format | Ctrl+Shift+~ |
| Number format | Ctrl+Shift+! |
| Currency format | Ctrl+Shift+$ |
| Percent format | Ctrl+Shift+% |
| Format dialog | Ctrl+1 |