How to move or copy a range

How to move a range

Select the range you want to move

How to move a range - 1

Place the pointer of your mouse on the border surrounding the range.

The pointer of your mouse would change to this four-headed-arrow - 1

When it does hold down the left button of your computer mouse and drag the selected range to the new area on your worksheet…where you want to put it.

Then release the left button of your computer mouse.

Excel moves the selected range for you to the new location as seen below

How-to-move-a-range - 2

How to copy a Range

Select the range you want to copy

How-to-copy-a-range - 1

Hold down the ‘Ctrl’ key on your keyboard, then carry the pointer of your mouse over the border of your selected range.

Your pointer changes to this four-headed-arrow - 2

When it does also hold down the left button of your computer mouse and drag the selected range to the new location on your worksheet.

Excel copies your selected range to the new location as seen below.

How-to-copy-a-range - 2

 

 

Lesson 17: How to insert a row