vanish. . - Merge Cells To merge a group of cells into one cell: Select the cells to merge. .
Click on Merge Cell icon or select Format -> Merge Cells option from menu bar. Figure . Merge cells . – Formatting Cells and Protecting Worksheets, locking and hiding cells Formatting Data in a cell gives additional effect to the text.
Additional effect includes changing the Font type, Style, Font size, automatic wrapping, bold, underline, italic etc. The data in Calc can be formatted in several ways using the icons of the Formatting Tool bar (Refer Figure . ) Figure . Formatting Tool bar .
. - Icons available in the Formatting Tool Bar: . Font Name list box : Various fonts are available in the list from which the required font can be selected. .
Font Size list box : Font size can be selected from this list box. . Bold Icon : This icon is used to apply bold for selected cell. Key board shortcut Ctrl + B can also be used.
. Italic Icon : Italic icon is used to apply italic style to selected cell. Ctrl + I can also be used to apply italic. .
Under line Icon : To apply underline for selected cell this icon can be used. Ctrl + U can also be used for this. . Four alignment Icons : Using this icon content of a cell can be aligned Left, Center, Right and Justify.
The key board short cuts are Ctrl + L, Ctrl + E, Ctrl + R and Ctrl + J can also be used respectively to align cell content. . Number Format Icon : Currency symbol (Ctrl + Shift + ), Percent (Ctrl + Shift + ), Standard (Ctrl + Shift + ), Add Decimal Place, Delete Decimal Place can be applied using this icons. .
Increase Indent and Decrease Indent Icons can be used to indent the cell content. Borders Icon, Background Colour Icon and Font Colour Icons can be used to apply border, to change cell background colour and to change font colour. . .