Clear formatting

To clear the formatting in cells without deleting the data, follow these steps:

1.Select the cell or range whose formatting you want to clear.

2.On the Home tab, in the Edit group, click  Clear and select Clear formatting in the menu that opens.

To clear the formatting in the cells and delete the data they contain, follow these steps:

1.Select the cell or range from which you want to delete data.

2.On the Home tab, in the Edit group, click  Clear and select Clear all in the menu that opens.

The result of applying the Clear formatting command:

–Cell formatting is reset to the default settings (see below)

–Cell contents are not deleted.

–Cell widths remain unchanged.

–If no user-defined row height changes were made while working on the document, cell heights revert to the default value of 0.53 cm (when using a 12-point font).

–Merged cells are split.

–If the cells contain hyperlinks, the formatting specific to hyperlinks is reset. The hyperlinks themselves are not deleted.

–The formatting of table cells reverts to the formatting defined by the selected table style.

–The formatting of pivot table cells reverts to the default formatting settings for pivot tables, or to the table style of a third-party editor, if one was applied. The number formats of the pivot table are reset to the General format.

–The formatting of cells containing drop-down lists reverts to the default settings (see below). The contents of the drop-down lists are not deleted.

–Formulas are not recalculated.

–The formatting of note text is not reset.

–When you run the Clear formatting or Clear all commands in a document in .ods format that contains default settings created in other editors, the formatting will be reset to the default settings specified in MyOffice Spreadsheet.

By default, the following formatting settings are applied to cells:

–Font: XO Thames

–Font size: 12

–Font type: Regular

–Text highlight "p_xo_list_bullet" style="">–Text "p_xo_list_bullet" style="">–Horizontal alignment: Align left for text, Align right for numbers

–Vertical alignment: Align to bottom

–Character spacing: Normal

–Cell fill: None

–Cell format: General

–Cell borders: None

–Text rotation: Not applicable

–Text wrap: Not applicable