Changes

</gallery>

</gallery>

{{clear}}

{{clear}}

Formatting a spreadsheet can be done in two modes.  

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.

* There are two useful options available for any cells known as Merge cell and Split cell.

* '''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.

* 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.

There are two useful options associated with cells known as Merge cell and Split 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. To Split a merged cell, give right click on the merged cell and click 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. 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. To Split a merged cell, right click on the merged cell and click split cell.

==== Providing headings to the data ====

==== Providing headings to the data ====

</gallery>

</gallery>

In a case, If you enter data for more than 50 cities, you will not be able to read the column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on View → Freeze Cells → Freeze Rows and Columns.

In a case, If you enter data for more than 50 cities, you will not be able to read the column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on View --> Freeze Cells --> Freeze Rows and Columns.

{{clear}}

{{clear}}