Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting

Editing Data

We all make mistakes. Not necessarily because we are careless, but because working with numbers is a rather tedious affair and there are plenty of opportunities to introduce errors. Fortunately, they can be easily corrected at any time.

Correcting or changing the content of a worksheet is called editing. You can tell that you are in the editing mode when you see the black rectangular cursor change into a text cursor inside the current cell. Another indicator of working in the editing mode is the content “spill” to the neighboring cells (see Figure 1-7). However, don’t count on it happening at all times, as you can turn it off by turning on the cell content wrap mode.

Figure 1-7. Editing text stored inside a cell

Here are a few ...