Spreadsheets: editing data within a cell

The tutor points out a handy hint that will be obvious to spreadsheet veterans, yet perhaps very useful to beginners.

Let’s imagine you’ve entered a city name in a cell: Medicine Hat, Alberta. However, you notice you mistyped the name: the cell reads Medidine Hat, Alberta.

If you return to the cell, arrowing back and forth will just place you in neighboring cells. Delete will erase the entire entry, as will attempting to type in the cell. It’s unlike a word processing situation, where you can arrow your way to the problem and edit.

Double-clicking on the cell is the solution. Then the typing cursor appears right where the mouse arrow was, and you can arrow back and forth within the cell entry to correct the misspelling.

Once again: to edit a cell entry, you can double-click on the cell, then move the cursor within the entry:)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Tagged with: , ,

Leave a Reply