Formatting
Align text, format numbers, and style your sheets.
Text alignment
By default, numbers are right-aligned and text is left-aligned. You can change this for any cell, range, row, or column using the three alignment buttons in the toolbar: left, center, and right.
Select the cells you want to align, then click the desired alignment button. The alignment is saved with the sheet.
Centering column titles in the first row is a quick way to make your sheet look more professional.
Number formatting
Click the # icon in the toolbar to open the number format menu. Three formats are available:
- Number — adds thousand separators (1,234)
- Currency — thousand separators with two decimal places (1,234.00)
- Percent — multiplies the value by 100 and adds the % symbol (0.15 becomes 15.00%)
Select the cells you want to format before choosing a format. To go back to the default format, open the menu and click Clear.
The currency format doesn't add a currency symbol. It simply formats the number with thousand separators and two decimal places, which works for any currency.
Cell colors
The paintbrush icon in the toolbar lets you apply a background color to cells. Six colors are available: yellow, red, orange, green, blue, and purple. Select one or more cells, then choose a color. Click the X to clear the color.
Colors are great for status tracking (green for done, red for urgent), visual organization, or just making important data stand out.
You can color an entire row or column at once. Select the row or column by clicking its header, then apply the color.
Freezing rows and columns
When your sheet gets big, headers disappear as you scroll. Freezing fixes that. Select a row or column by clicking its header, then click the snowflake icon in the toolbar.
Frozen rows stay at the top of the grid and frozen columns stay on the left, no matter how far you scroll. Click the snowflake again to unfreeze.
You'll see a subtle line marking the boundary of frozen rows or columns. It's a helpful visual indicator of what's frozen.
Column width
Double-click a column header to auto-fit its width to the widest content. cDox remembers custom widths — they'll persist when you come back to the sheet later.