Editing Cell Contents: Regular report

To set up cell contents formatting options, switch to the edit mode in one of the following ways:

Operations with Cell Contents

After switching to the edit mode, one can execute the following operations with the data stored in the cell:

To set up the format of selected cells:

Select the Formatting item in the cell's context menu. The panel to set up cell format opens. Set cell contents formatting parameters.
Use the Formatting toolbar tab.

To set up conditional formatting of the selected cells, select the Conditional Formatting item in the cell's context menu. The cell conditional formatting setup panel opens. Set cell conditional formatting parameters.

For details about data cutting see the Copying and Pasting Data article.

For details about data copying see the Copying and Pasting Data article.

For details about data pasting see the Copying and Pasting Data article.

To select all the contents of the selected cell, open the cell for edit and execute one of the operations:

Select the Select All context menu item.
Press CTRL+A.

To clear cell data, use the Clear button on the Data toolbar tab.

The following data clear options are available:

Clear Comment. To clear a cell comment only, select the Clear Comment item in the drop-down menu of the Clear button.
Clear Contents. To clear cell contents only, select the Clear Contents item in the drop-down menu of the Clear button. One can also use the DELETE key for this purpose.
Clear Format. To clear cell data format only, select the Clear Format item in the drop-down menu of the Clear button. One can also use CTRL+\ to set this option.
Clear All. To clear cell contents, data format and comment, click the Clear button or select the Clear All item in the button's drop-down menu.

When data range filtering is applied on a report sheet or table sheet, data clearing is applied only to visible rows/columns.

To undo or redo the operation with cell contents, see the Undo/Redo Operation section.