Microsoft Office Tutorials and References
In Depth Information
There’ll Be Some Changes Made—Editing Cells
Figure 2–39. Knowing its place: the white cell remains within the range
And when you reach cell E21—the last cell in the range—and enter data there and press Enter, you’ll
be taken back to D12.
This, then, is the data-entry advantage of selecting a range, if you need to: the range selection
confines your data entry to precisely that area of the spreadsheet and nowhere else. But note, however,
that if you follow up each data entry in the range by carrying out some of the other navigational moves
instead of Enter, such as pressing the various keyboard arrows, or clicking your mouse, the blue range
selection will turn off and the method we’ve just described will likewise be voided—unless you select the
range again, of course. If you do want to conduct your data entry within a specified range, these
keystrokes work:
Enter—takes you down one row within the range.
Shift-Enter—takes you up one row within the range.
Tab—takes you one cell to the right in the range, or back to the first column and
down one row if you’re already in the last column of a range.
Shift-Tab—takes you one column to the left in the range, or one row up and into
the last column if you’re already in the first column of the range.
That concludes our discussion of the basics of data entry—but not to worry; we need to return to the
subject. There’s all that formatting to do, after all!
But in any case, once you nail down the basics we still need to remind ourselves that no one’s
perfect, and in the course of imparting their data to worksheets users make mistakes, change their
minds, and have to enter new numbers as events warrant. So once the data is squirreled into their
respective cells, we still need to ask: how do you edit all this?
There’ll Be Some Changes Made—Editing Cells
As you’d expect, there’s more than one way to modify the contents of cells, all of which are pretty easy to
master. The most straightforward approach is to simply overwrite any existing cell contents; that is, just
click or key your way into the cell you want to overwrite, and type something new. That’s all.
Search JabSto ::

Custom Search