
Replacing all the data in a cell
To remove data and insert new data, simply type over the old data. The
new data will retain the original formatting.
Changing part of the data in a cell
Sometimes it is necessary to change the contents of cell without
removing all of the contents, for example if the phrase “See Dick run”
is in a cell and it needs to be changed to “See Dick run fast.” It is often
useful to do this without deleting the old cell contents first.
The process is the similar to the one described above, but you need to
place the cursor inside the cell. You can do this in two ways.
Using the keyboard
After selecting the appropriate cell, press the
F2
key and the cursor is
placed at the end of the cell. Then use the keyboard arrow keys to
move the cursor through the text in the cell.
Using the mouse
Using the mouse, either double-click on the appropriate cell (to select
it and place the cursor in it for editing), or single-click to select the cell
and then move the mouse pointer up to the input line and click into it
to place the cursor for editing.
Formatting data
The data in Calc can be formatting in several ways. It can either be
edited as part of a cell style so that it is automatically applied, or it can
be applied manually to the cell. Some manual formatting can be
applied using toolbar icons. For more control and extra options, select
the appropriate cell or cells, right-click on it, and select Format Cells.
All of the format options are discussed below.
Note
All the settings discussed in this section can also be set as a
part of the style using the Styles and Formatting window. See
Chapter 10 (Using Styles in Calc) in the
Calc Guide
for more
information.
Chapter 5 Getting Started with Calc 151
Kommentare zu diesen Handbüchern