Skip to content

Formatting

ActionShortcut
BoldCtrl+B
ItalicCtrl+I
UnderlineCtrl+U
StrikethroughCtrl+5

You can also use the format bar buttons or the Format menu. Formatting is applied to all selected cells.

Copy formatting from one cell and apply it to others:

ActionShortcut
Copy formatCtrl+Shift+C
Paste formatCtrl+Shift+V

Usage:

  1. Select a cell with the formatting you want to copy
  2. Press Ctrl+Shift+C (status bar confirms ”● Format copied from A1”)
  3. Select one or more destination cells
  4. Press Ctrl+Shift+V to apply the format

All formatting properties are copied: bold, italic, underline, strikethrough, alignment, number format, and text overflow mode.

Use the Format menu or format bar to set text alignment:

AlignmentDescription
LeftText aligns to the left edge (default)
CenterText is centered in the cell
RightText aligns to the right edge
AlignmentDescription
TopText aligns to the top of the cell
MiddleText is centered vertically (default)
BottomText aligns to the bottom of the cell

Access via Format menu or Cell Inspector (Ctrl+1).

FormatShortcutExample
GeneralCtrl+Shift+~1234.56 (auto-detected)
NumberCtrl+Shift+!1,234.56
CurrencyCtrl+Shift+$$1,234.56
PercentCtrl+Shift+%12.34%

To adjust decimal places:

  • Increase decimals: Use format bar .00→.000 button
  • Decrease decimals: Use format bar .000→.00 button

Control how text behaves when it’s wider than the cell:

ModeBehavior
ClipText is cut off at the cell boundary (default)
WrapText wraps to multiple lines within the cell
SpillText 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).

ActionMethod
Resize columnDrag column border
Auto-fit columnDouble-click column border
Auto-size columnCtrl+0
ActionShortcut
BoldCtrl+B
ItalicCtrl+I
UnderlineCtrl+U
StrikethroughCtrl+5
Copy formatCtrl+Shift+C
Paste formatCtrl+Shift+V
General formatCtrl+Shift+~
Number formatCtrl+Shift+!
Currency formatCtrl+Shift+$
Percent formatCtrl+Shift+%
Format dialogCtrl+1