Edit data

Edit data
	Chapter 2. Cells

Edit existing content of a cell

Suppose we click on a cell, for example A8 in the following screen. The contents of cell A8 are also display in the Input line of the Formula bar. If you wish to add text to the existing contents of the cell:

Click at the end of the text in the Input line.
Press Enter, Tab or an arrow key when you are done.

Alternatively, you could edit the contents of the Input line as you would any text. You can insert text or delete text.

Replace content of a cell

Click on the cell whose content you wish to replace.
Type your new content.

When you do this, the existing content of the cell will automatically be replaced by your new entry.

	Note
	The difference between the method for editing existing content and replacing existing content is that to edit the content you click on the input line whereas to replace you do not.

Use the undo, redo command

Suppose you delete a line of text, then immediately realise you have made a mistake. The undo command allows you to go back a step to the point before the previous command. To use this command:

Edit->Undo

OR

Press Ctrl-Z.

In fact the undo command has a history. If you repeat the command it will undo the second last command. If you repeat it once more it will undo the third last command, and so on.

The redo command reverses the effect of the last undo. To use this command:

Edit->Redo

Suppose you had used the undo command three times. In effect you would have undone your previous three command. If you now use the redo, it will re-instate these actions.

The best way of understanding how undo and redo work is to practice using them.


Rows and columns		Duplicate, Move, Delete