Calc Guide

Figure 31: Defining input help for a cell
Figure 32: Defining an error message for a cell with
invalid data
Editing data
Editing data is done is in much the same way as entering it. The first
step is to select the cell containing the data to be edited.
Removing data from a cell
Data can be removed (deleted) from a cell in several ways.
Removing data only
The data alone can be removed from a cell without removing any of
the formatting of the cell. Click in the cell to select it, and then press
the Backspace key.
Removing data and formatting
The data and the formatting can be removed from a cell at the same
time. Press the Delete key (or right-click and choose Delete
Contents, or use Edit > Delete Contents) to open the Delete
Contents dialog (Figure 33). From this dialog, different aspects of
Chapter 2 Entering, Editing, and Formatting Data 51