Microsoft Office Tutorials and References
In Depth Information
Moving and Copying a Range
Figure 1-15
Selected nonadjacent range A1:A5;F1:G5
adjacent range A1:A5
adjacent range F1:G5
4. Click any cell in the worksheet to deselect the range.
Moving and Copying a Range
Amanda wants you to insert titles into the worksheet that describe the customer order
data you have entered. Including the company name, a descriptive title, and the current
date is part of good worksheet design, enabling others to quickly see the who , what , and
when of the data. The current worksheet has no space to add this information. You could
insert several blank rows at the top of the worksheet for this information. Another option
is to select and then move the customer data lower in the worksheet, freeing up the rows
at the top for the new text.
Moving or Copying a Cell or Range
• Select the cell or range you want to move or copy.
• Move the pointer over the border of the selection until the pointer changes shape.
• To move the range, click the border and drag the selection to a new location (or to
copy the range, hold down the Ctrl key and drag the selection to a new location).
or
• Select the cell or range you want to move or copy.
• In the Clipboard group on the Home tab, click the Cut button or the Copy button (or
right-click the selection, and then click Cut or Copy on the shortcut menu).
• Select the cell or upper-left cell of the range where you want to move or copy the
content.
• In the Clipboard group, click the Paste button (or right-click the selection, and then
click Paste on the shortcut menu).
Search JabSto ::




Custom Search