Microsoft Office Tutorials and References
In Depth Information
Aligning Your Data—Where It Appears in the Cell
Figure 2–8. Getting ticked off: Completing the data entry process by clicking the gray tick
This click-the-tick approach will also finish off the data entry as with all the other
techniques, but this time—and unlike the other methods listed above- will leave the cell
pointer in the same cell. Note also the X to the left of the tick; click it instead and the
445 you’ve started to type above will be canceled
Aligning Your Data—Where It Appears in the Cell
Now let’s look at a little more closely at the data you’ll enter and how they appear in
cells. When you type a textual entry the results appear left-aligned— that is, starting at a
cell’s left edge—by default, and that’s simply because our Roman alphabet proceeds
from left to right. But type a number—or what Excel calls a value , and it will position
itself by default—that is, for starters—at the cell’s right edge, because our number
system is Arabic, extending right to left:
Figure 2–9. Choosing sides: Text aligned left, numbers right
Text data entry differs in some important ways from its numeric cousin. For one thing, if
you type a lengthy phrase in a cell—and you can actually type over 32,000 characters in
a cell—Excel will allow the excess text to spill into adjoining columns:
Figure 2–10. Crossing the line: a text phrase advancing into other cells
Search JabSto ::

Custom Search