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 pointer of mouse changed to move or copy range

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

Lesson 16 - How to move a range2

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 pointer 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

 

Submit a Comment

Your email address will not be published. Required fields are marked *