Format Tool-Bar, Format Painter and Format Cells are available for formatting the spreadsheets.

1. Format Tool-Bar

(Figure 1 : Format Tool-Bar)

2. Format Painter

Select a cell having the format to copy, select Format Painter and then select the target cell(s).

(Figure 2 : Format Painter)

3. Format Cells

3.1) Numbers

(Figure 3: Format Cells - Numbers)

3.2) Alignment

(Figure 4 : Format Cells - Alignment)

3.3) Font

(Figure 5 : Format Cells - Font)

3.4) Border

(Figure 6 : Format Cells - Border)

3.5) Patterns

(Figure 7 : Format Cells - Patterns)

3.6) Protection

(Figure 8 : Format Cells - Protection)

3.7) Validation

(Figure 9 : Format Cells - Validation)