Excel tools to demonstrate


Moving (Cutting and Pasting)



Yüklə 119,95 Kb.
səhifə12/56
tarix05.01.2022
ölçüsü119,95 Kb.
#72366
1   ...   8   9   10   11   12   13   14   15   ...   56

Moving (Cutting and Pasting)


Often you would like to move information from one place in the sheet to another.

To move (cut and paste):

Select the range to be cut, press Ctrl-x (for cutting), select the upper left corner of the paste range, and press Ctrl-v. (The little finger-index finger combination in your left hand is also good for pressing Ctrl-x.)

As with copying and pasting, ribbon buttons can be used instead of key combinations, but either is more efficient than selecting menu items. Also, note that you need only select the upper left cell of the paste range. Excel knows that the shape of the paste range must be the same as the shape of the cut range.

Try it! Move the range A2:C8 to the range D2:F8. (Watch how relative addresses affect the eventual formulas in column F.)



Yüklə 119,95 Kb.

Dostları ilə paylaş:
1   ...   8   9   10   11   12   13   14   15   ...   56




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin