Enter, edit and format data
Select cells, enter and edit values, move around with the keyboard, and format numbers as currency, percent, accounting or dates in Kazi Sheets.
Select and enter
- Click a cell to select it, then just start typing. Press Enter to confirm and move down, or Tab to move right.
- Double-click a cell to edit what's already in it.
- Use the arrow keys to move around.
- Delete or Backspace clears the selected cells.
- Drag across cells (or Shift+click) to select a range.
Numbers, text and dates
Kazi recognises what you type:
| You type | Kazi treats it as |
|---|---|
1250 or 1250.50 | Number |
12.5% | Percentage |
2026-11-12 | Date |
=SUM(B2:B9) | Formula. See Formulas |
| Anything else | Text |
Number formats
Select cells and choose a format from the toolbar:
| Format | Example |
|---|---|
| Number | 1,250.50 |
| Currency (choose the symbol) | $1,250.50 · UGX 1,250 · €1.250,50 |
| Accounting | Aligns currency symbols and decimals in a column |
| Percent | 12.5% |
| Date | 12 Nov 2026 |
| Text | Shown exactly as typed |
Use the increase / decrease decimals buttons to control how many decimals show. The value itself isn't rounded, only its display.
Styling
Bold (Ctrl+B), italic (Ctrl+I), underline (Ctrl+U), strikethrough, font and size, text and fill colour, borders and alignment are all on the toolbar.
For a finished look in one click, apply a table style from the Format menu: Emerald Financial Banded Ledger, Sovereign Petrol Banded Ledger or Terracotta Executive Banded Table.
Rows, columns and sheets
- Use the Rows/Cols menu on the toolbar to insert or delete rows and columns.
- Drag a column's edge in the header to change its width.
- Add sheets with Insert → New Blank Sheet Tab, and switch between them with the tabs at the bottom.
Clear
- Clear Selected Values: removes content, keeps formatting.
- Clear Selected Formatting: removes formatting, keeps content.
- Clear Entire Active Sheet: empties the sheet (you can undo with Ctrl+Z).