Skip to content

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.

Copy formatting from one cell and apply it to others:

Action Shortcut
Copy format Ctrl+Shift+C
Paste format Ctrl+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:

Alignment Description
Left Text aligns to the left edge (default)
Center Text is centered in the cell
Right Text aligns to the right edge
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).

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%
Date Ctrl+Shift+# 1/18/2026
Time Ctrl+Shift+@ 3:45:00 PM
Scientific Ctrl+Shift+^ 1.23E+03

To adjust decimal places:

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

Semantic cell styles apply a coordinated set of visual properties (background, text color, border, bold/italic) in one click. Access them from the Styles dropdown in the format bar, or via the Command Palette.

Style Appearance Use case
Normal Clears style, restores defaults Remove a previously applied style
Error Red background, red text, red border Highlight errors or invalid data
Warning Amber background, amber text, amber border Flag values that need attention
Success Green background, green text, green border Indicate passing/valid values
Input Blue background, blue text, blue border Mark cells for user input
Total Subtle fill, bold text, top border Summary/total rows
Note Gray background, muted text, italic Annotations and comments

Behavior:

  • Applying a style clears any manual background and font color so the style colors take effect
  • Applying “Normal” removes the style and restores default formatting
  • Styles adapt to the current theme (light vs dark)
  • When applied to a multi-cell range, borders appear only around the perimeter

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

Action Method
Resize column Drag column border
Auto-fit column Double-click column border
Auto-size column Ctrl+0
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+%
Date format Ctrl+Shift+#
Time format Ctrl+Shift+@
Scientific format Ctrl+Shift+^
Format dialog Ctrl+1