Microsoft Office Tutorials and References
In Depth Information
Move or Copy a Range
Move or Copy
a Range
If your worksheet is not set up the way you want,
you can restructure or reorganize the worksheet by
moving an existing range to a different part of the
sheet.
You can also make a copy of a range, which is a
useful technique if you require a duplicate of the
range elsewhere, or if you require a range that is
similar to an existing range. In the latter case, after
you copy the range, you can then edit the copied
version of the data as needed.
Move or Copy a Range
Move a Range
1 Select the range you want to
move.
2 Position the mouse over any
outside border of the range (
changes to ).
3 Click and drag the range to the
new location ( changes to ).
A Excel displays an outline of the
range.
B Excel displays the address of the
new location.
4 Release the mouse button.
C Excel moves the range to the
new location.
Search JabSto ::




Custom Search