Microsoft Office Tutorials and References
In Depth Information
Aligning Your Data—Where It Appears in the Cell
Just type away and let the text do its thing, bearing in mind that, appearances to the
contrary, all the text you see in the above screen shot inhabits just one cell—the cell in
which you started to type. That’s all perfectly legal. But crossing cell boundaries can
cause a problem.
Let’s say the text we see above has been inscribed in cell B6. If we go ahead and type
an entry in cell C6—the cell to its immediate right, we see something like this:
Figure 2–11. Now you see it, now you don’t: The case of the missing text.
What happened? What happened is that the new phrase in C6 is simply claiming its own
turf, so to speak. C6 was empty, after all, and all we did was enter a bit of text there—
obscuring, but not deleting, that part of the text in B6 that had overstepped its bound.
And how do I know that none of the text in B6 has been deleted? I can verify that fact by
clicking on B6 and looking at the Formula Bar. You’ll see
Figure 2–12. All there: the text in B6, revealed in the Formula Bar
Now we can begin to understand how the Formula Bar reveals the data you’ve entered
in a cell. By that I meant that a glance at the actual cell doesn’t always tell you what’s
really going on inside of it, and we’ll see more evidence of this when we starting looking
at formulas. Here we see that because of the data in C6, some of the phrase in B6 isn’t
visible—at least not on the worksheet itself. And if you were to go ahead and print the
worksheet in its current state, the text in B6 would remain eclipsed as you see it above.
But the Formula Bar reassures us that that it’s all still there just the same.