Microsoft Office Tutorials and References
In Depth Information
Having Your Fill
There’s that ever-present white cell. And what purpose does that cell serve? It marks the cell that will
receive the next bit of data you type. Select a range, begin to type, and then press Enter. The entry ends
up in the white cell.
And if you need any corroboration, select any range, observe the address of the white cell, and
glance in turn at the name box. You’ll see that very address recorded in the box.
And the white-cell/range selection does something else. If you select any range and begin to type,
the first entry stakes the white cell—and if you press Enter, the cell pointer plunges down one row, of
course—but the blue range color remains in force. Try this: select cells D12 through D21, type the
number 51, and press Enter. This is what you’ll see (Figure 2–38):
Figure 2–38. Within range—data entry inside the selection
Type a number in the current cell—D13—and press Enter, and the number is once again registered
in its cell—and the pointer again descends one row, to D14. And so forth.
But of course you’ll have a question about all this: Entering data in a cell and pressing Enter always
does exactly what I’ve described above—even if you don’t select a range. So what are we gaining here?
Here’s the answer: Select this range instead: D12:E21. Start typing and press Enter. The data locks
into D12 and proceeds to D13, etc. But when you reach cell D21—the last cell in the D column—and
press Enter, this time the cell pointer won’t drop down to D22—it’ll pop up to E12 instead, which is after
all the next cell in the selected range (Figure 2–39):