Making changes to contents of cells

From WikiEducator
Jump to: navigation, search

In the last activity, you took the first steps in editing data, getting inside the cell. Continuing on this topic, let's review the edit process and then look at a number of functions that can adjust the data contained in cells. Remember that data in a spreadsheet may be of two types: numerical and alphabetical. We will be encountering both in the activities to follow.

Edit existing content of a cell

A quick review. You perform this task to add, insert or delete text to or from the existing contents of a cell. You do this in the Input line of the Formula bar.

  • Select the cell whose contents need to be revised.
  • Click in the Input line to change to edit mode.
  • Revise the data as needed.
  • Press Enter, Tab, or an arrow key when the revision is complete.

Replace contents of a cell

Sometimes the quickest way to make a correction is to overwrite the data in the cell with the new content. Remember overwriting "Cost" with "Total Cost" a few pages back?

The operation is simple: select the desired cell and type the new data. As soon as you start typing, the old data disappears. No need to use the Input line.

Icon activity.jpg More Practice
If you are still feeling a bit unsure:
  • Select a blank cell in your spreadsheet.
  • Type "blather".
  • Press Enter, Tab, or an arrow key to move to another cell.
  • Reselect the cell containing "blather".
  • Type "flatter".
  • Press Enter, Tab, or an arrow key to move to another cell.

The original "blather" has been changed to "flatter".

Use the undo and redo commands

Again, you have already used the undo command via the undo button, Calc3UndoButton.png. Sometimes when editing or formatting you make a mistake and want to return the worksheet to a previous state. The undo command goes back one step for each time it's implemented.

You can implement the undo command in three ways:

  • Click the undo button, Calc3UndoButton.png.
  • Select Edit > Undo.
  • Press the key combination Ctrl+Z.

In fact, the undo button contains the history of changes made in the current editing session, up to a default number, typically 100. You can repeatedly press the undo button to go back one step at a time, or click the down arrow next to the undo button on the Formatting bar, and choose an earlier step to return to in the dropdown box.

Undo dropdown box showing revision history

Use the redo command to reinstate a later version after using undo command. The redo command reverses the action of the undo command. This is useful if you'd like to try out adding a new item to a spreadsheet; you can compare the earlier and later version and pick whichever you like better.

To implement the redo command:

  • Click the redo button on the Formatting bar, Calc3RedoButton.png
  • Select Edit > Redo.
  • Press the key combination Ctrl+Y.

Note that the redo command contains a revision history accessible via the down arrow next to the redo button.

Icon present.gif
Tip: The undo command works for many spreadsheet operations that you will perform. However, some commands (for example, editing Styles) cannot be undone.

The best way to understand how undo and redo work is to use them while editing. In the activities that follow, take a moment here and there to try out undo and redo.