Microsoft Office Tutorials and References
In Depth Information
Doing the Old Drag-and-Drop Thing
Figure 4-3:
the cell
to its new
position in a
Figure 4-4:
A worksheet
dropping the
selection into its
new place.
The arguments for the SUM functions in cell range B13:E13 do not keep pace
with the change — it continues to sum only the values in rows 3 through 9
after the move. However, as soon as you enter the sales figures for these new
enterprises in columns B through D in rows 10 and 11, Excel shows off its
smarts and updates the formulas in row 12 and column E to include the new
entries. For example, the SUM(B3:B9) formula in B12 magically becomes
Search JabSto ::

Custom Search