Format cells

Bold and colour cells, align text, set number and date formats, add notes and colour cells automatically with conditional formatting.

Make a sheet readable: bold and colour cells, add borders, merge cells, align text, choose how numbers and dates look, add notes, and colour cells automatically with conditional formatting.

Before you start: Can edit on Sheets. Formatting is saved with the sheet, so everyone sees it.

Text and colour

Select cells, then use the toolbar:

Button What it does
Bold, Italic, Underline, Strikethrough Toggle the style. Ctrl + B, Ctrl + I, Ctrl + U also work.
Text colour Automatic or one of Red, Orange, Yellow, Green, Teal, Blue, Purple, Pink, Gray.
Fill colour No fill or one of the same colours.
Align left, Align centre, Align right Horizontal alignment. Numbers align right unless you choose otherwise.
Wrap text Lets long text run onto a second line inside the cell.
Clear formatting Removes styles from the selected cells. Values stay.

The colours are chosen to stay readable in both light and dark mode.

Borders

Select cells and click Borders on the toolbar. Choose All borders, Outside borders, Inside borders, Top border, Bottom border, Left border, Right border or No borders. In the same menu, pick the line — Thin line, Medium line or Thick line — and its colour (Automatic colour or one of the palette colours) before you apply it. Undo reverses a border change in one step.

Merge cells

Use merged cells for report titles and headings that span several columns.

  1. Select two or more cells.
  2. Click Merge cells on the toolbar, or right-click and choose Merge cells.
  3. If other cells in the range hold values, AxisIQ asks first: only the top-left value is kept and the rest are cleared.

The merged range shows as one cell. Clicking it selects the whole merge, and the arrow keys leave from its far edge. To split it again, select it and click the same button, now Unmerge cells.

  • Inserting or deleting rows and columns moves, grows or shrinks a merge with them.
  • Rows that contain a merge can't be sorted — unmerge them first.
  • A merge can't cross frozen rows or columns, or cover more than 10,000 cells.
  • Merges are kept when you download or import an Excel (.xlsx) file.
  • Teammates with the sheet open see the merge straight away.

Number and date formats

Click 123 (Number format) on the toolbar. The choice applies to the whole column of the selected cell.

The number format menu

Option Example
Automatic As typed
Number 1,234.56
Whole number 1,235
Percent 12.3% (0.123 shows as 12.3%)
More decimal places / Fewer decimal places One more or one fewer digit
Date 2026-10-05, 5 Oct 2026, or Monday, 5 October 2026

Formats change only how values look. Formulas still use the full value.

Notes

  1. Select a cell and click Note on the toolbar (or right-click › Insert note).
  2. Type the Note (up to 1,000 characters) and save.

A cell with a note shows a small marker in its top-right corner. Hover the cell to read it. Right-click › Edit note changes it; Remove note deletes it.

Conditional formatting

Colour cells automatically from their value — for example every "Overdue" in red.

  1. Select the cells the rule should cover (for example the Status column).
  2. Click Conditional formatting on the toolbar.
  3. Click Add rule.
  4. Check the cells under Applies to, or click Use current selection.
  5. Under Format cells if, pick a condition: Greater than, Greater than or equal to, Less than, Less than or equal to, Equal to, Not equal to, Between, Text contains, Is empty or Is not empty. Fill in Value (and And for Between).
  6. Choose the look: Text colour, Fill and Bold.
  7. Click Done, then Save.

Conditional formatting rules for Overdue and Paid

  • The list shows each rule with a preview. Use the pencil to edit a rule and the bin to delete it.
  • When several rules match a cell, the first one in the list wins.
  • Rules follow the value: when "Open" becomes "Overdue", the colour changes on its own.
  • A sheet can have up to 50 rules.

Tips

  • Use bold and a fill colour on a header row, then freeze it (Freeze › Freeze 1 row).
  • Conditional colours beat colouring by hand: they stay right as data changes.