Microsoft Office Tutorials and References
In Depth Information
Relocating the Data: Copying and Moving
Figure 2–29. Auto-fill options
The default selection, Copy Cells, really characterizes what we’ve just done. But assuming we’ve
copied the number 3 as per the screen shot, from the D17 source cell down through D30, look then what
happens when we click selection number two, Fill Series, as shown in Figure 2–30:
Figure 2–30. A Fill Series
I’ll bet that one got you to look up and stop texting. What Excel has done here is add an increment of
one to each of the cells in the range to which we copied the original value, 3. That’s a rather cool
Search JabSto ::

Custom Search