Skip to content
VisiGrid

Formatting

Text Formatting

Section titled “Text 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.

Format Painter

Section titled “Format Painter”

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.

Horizontal Alignment

Section titled “Horizontal Alignment”

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

Vertical Alignment

Section titled “Vertical Alignment”
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).

Number Formats

Section titled “Number Formats”
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

Cell Styles

Section titled “Cell Styles”

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.

StyleAppearanceUse case
NormalClears style, restores defaultsRemove a previously applied style
ErrorRed background, red text, red borderHighlight errors or invalid data
WarningAmber background, amber text, amber borderFlag values that need attention
SuccessGreen background, green text, green borderIndicate passing/valid values
InputBlue background, blue text, blue borderMark cells for user input
TotalSubtle fill, bold text, top borderSummary/total rows
NoteGray background, muted text, italicAnnotations 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

Text Overflow

Section titled “Text Overflow”

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

Column Width

Section titled “Column Width”
ActionMethod
Resize columnDrag column border
Auto-fit columnDouble-click column border
Auto-size columnCtrl+0

Formatting Shortcuts Summary

Section titled “Formatting Shortcuts Summary”
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