1,325
edits
Changes
Jump to navigation
Jump to search
Line 114:
Line 114: − + − + − + − +
→Formatting a spreadsheet
{{clear}}
{{clear}}
Formatting a spreadsheet involves two important formats.
Formatting a spreadsheet involves two important formats.
* '''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.
* 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 Calc gives much importance for cells, the text alignment inside the cell also needs to be taken care of. 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.
* Alignment of Text inside the cell : Since Calc gives much importance for cells, the text alignment inside the cell also needs to be taken care of. 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.
There are two useful options associated with cells known as Merge cell and Split cell.
There are two useful options associated with cells known as Merge cell and Split cell.
* '''Merge cell''' combines two or more cells together to make it as one. For example, If you want the main heading to be given in a particular column which is having two or more sub menus or subsections you can use this feature.
* "Merge cell" combines two or more cells together to make it as one. For example, If you want the main heading to be given in a particular column which is having two or more sub menus or subsections you can use this feature.
To merge cells, select two or more cells and right click on anyone of the selected cells and click on "merge cell".
To merge cells, select two or more cells and right click on anyone of the selected cells and click on "merge cell".
* '''Split cell''' is needed when you accidentally merged the cells which are no longer required and you want them to be the separate cells.
* "Split cell" is needed when you accidentally merged the cells which are no longer required and you want them to be the separate cells.
To Split a merged cell, right click on the merged cell and click "split cell".
To Split a merged cell, right click on the merged cell and click "split cell".