Formatting using Format Cells Dialog Box: The above formatting options can be applied individually one by one. The Format Cells dialog box is used to apply formatting and see the preview. Select a cell and Right-click and select Format cells or click Format → Cells or press Ctrl+ , now Format Cells dialog box appears with seven tabs as follows. Figure .
Format Cells Numbers Tab : Several number formats like Category, Format, Language, Decimal places, leading zeros and Thousands separator. User-defined Format code is also applied. The main advantage here is that preview is available. Cell Protection Tab : In Open Office Calc, cells are protected against any accidental changes.
Protection can be provided by means of a password. Authorization is given by entering the correct password. It is clear that the Cell Protection with a Protected attribute is only effective when the whole sheet is in protected mode. Figure .
Format Cell - Cell Protection . Select the cells that you want to apply the cell protection feature.. . Choose Format → Cells and click the Cell Protection tab.
. In the Protection group, the Protected check box is enabled, click Ok button. This becomes effective only when password and confirm are entered through Tools → Protectd Document → Sheet(Refer Figure . ).
Figure . Protecting the Sheet In the Format Cells dialog box - for cell protection under the Protection group:. . Enable Protected to prevent changes to the contents and the format of a cell.
. Enable Hide formula to hide and to protect formulae from changes. . Enable Hide when printing to hide protected cells in the printed document.
(The cells are not hidden on screen). . Click OK . .
Apply the protection options. . To protect the cells from being changed / viewed / printed according to your settings in the Format → Cells Dialog box, choose Tools → Protect Document → Sheet . .
Enter a password with of atleast or more characters. . –Cell Referencing . .
Relative Addressing The cell from A1 to A3 is addressed as A1:A3 .