1,325
edits
Changes
From Open Educational Resources
→Formatting a spreadsheet
==== Formatting a spreadsheet ====
==== Formatting a spreadsheet ====
[[File:LO Calc 6 Formatting numbers.png|500px|left]]
[[File:LO Calc 6 Formatting numbers.png|500px|left]]
Most of the formatting options available in LibreOffice Writer are available in Calc also. Making the text bold, italicised, increasing/reducing font size, font color etc are all available. Data can also be formatted based on what it represents - date, time, currency, etc. The numeric information display format in terms of "000" separators or number of decimal places can be configured.
Formatting a spreadsheet can be done in two modes.
# Text formatting : Most of the formatting options available in LibreOffice Writer are available in Calc also. Making the text bold, italicized, increasing/reducing font size, font color etc are all available. Data can also be formatted based on what it represents - date, time, currency, etc. The numeric information display format in terms of "000" separators or number of decimal places can be configured.
# Alignment of Text inside the cell : Since in Calc we give much importance for cells, we need to take care of the text alignment inside the cell also. Such alignments can be Top, center and bottom. Wrap text option allows the text which gone out of the cell to be aligned within the cell boundary.
{{clear}}
{{clear}}
