contents from a column or row. Deleting Column or Row is not Possible . Formatting Worksheet Formatting Data in a cell gives additional effect to the text. Additional effect includes changing the font style, font size, automatic wrapping, bold, underline, italic etc.
The data in Calc can be formatted in several ways. Using formatting icons can be used. Selected columns To Delete Selected columns; click here Figure . Delete multiple columns Chapter .
. Text Formatting Making the cell contents as bold, italics, underlined, changing font style, size, colour etc., comes under text formatting. All text formatting options are available as icons in Formatting toolbar learnt in OpenOffice Writer. Figure .
(a) Text Formatting Toolbar Moving handle Bold Italic Underline Merge Cells Align Center Justify Align Styles Font Styles Fond Size Figure . (a) Text Formatting Toolbar Formatting Option Keyboard Shortcut Description Font style Used to change Font style Font size Used to change Font size Bold Ctrl + B Used to make the data as Bold Italic Ctrl + I Used to italicize data Underline Ctrl + U Used to underline the data Left Align Ctrl + L Left Align data within a cell Right Align Ctrl + R Right Align data t within a cell Center Align Ctrl + E Center the data within a cell Justify Ctrl + J Align the data evenly both on left and right side of a cell Merge cell Makes selected cells as a single cell . . Number formatting Number formatting options are used to visually change the format of a numeric content.
These formatting changes are only for visual as, it does not change its original value. For example, To display a number as currency form use Number format: Currency. Number format: Currency will be used as shown Figure . (b).
Currency Percentage Delete Decimal Add Decimal Standard Figure . (b) Formatting toolbar Number Format Keyboard Shortcuts Currency Symbol Ctrl+Shift+ Percent Ctrl+Shift+ Standard Ctrl+Shift+ Add Decimal Place Delete Decimal Place Chapter . Open the spreadsheet which was created in Illustration . .