Microsoft Office Tutorials and References
In Depth Information
Doing the Old Drag-and-Drop Thing
Figure 4-3:
Dragging
the cell
selection
to its new
position in a
worksheet.
Figure 4-4:
A worksheet
after
dropping the
cell
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
SUM(B3:B11).
 
Search JabSto ::




Custom Search