Microsoft Office Tutorials and References
In Depth Information
Having Your Fill
Figure 2–37. Where the list takes shape
When you’re done, click Add, and your list is swung into the Custom Lists column, where it now
shares a zip code with Excel’s built-in, default lists.
Then just type any one of your custom names in a cell, drag the fill handle, and your list plays down
or across the range.
Just bear in mind that we haven’t exhausted all the possibilities for copying and moving data. That’s
because a different kind of cell content—a cell reference can also be copied or cut, with some new —
implications. That one is coming soon.
Now on to some concluding observations about basic data entry. Note that this expression:
123 Main Street
is considered text . Indeed, for starters, any data entry containing a non-numerical element, such as:
or say, a social security number:
is to be treated as text, as opposed to a number. You can’t add a social security number; and Excel won’t
treat the number above as a case of subtraction, either. You’ll soon see why.
Now there’s one other basic data entry principle you’ll want to know that will at last shed some light
on that pristine white cell you’ll always see topping a range selection. Again, if I go ahead and drag my
mouse across a range of cells: