• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Getting the Most Out of Ranges > Inserting a Copy of a Range

Inserting a Copy of a Range

If you don't want a pasted range to overwrite existing cells, you can tell Excel to insert the range. In this case, Excel moves the existing cells out of harm's way before pasting the range. (As you'll see, you have control over where Excel moves the existing cells.) Follow these steps to insert a copy of a range:

1.
Select the range you want to copy.

2.
Use any of the methods described earlier in this chapter to copy the range.

3.
Select the upper-left cell of the destination range.

4.
Choose Insert, Copied Cells. Excel displays the Insert Paste dialog box to enable you to choose where to move the existing cells that would otherwise be overwritten (see Figure 1.13).

Figure 1.13. Use the Insert Paste dialog box to tell Excel which direction to move the existing cells.


TIP

You also can insert a copied range by right-clicking the destination cell and choosing Insert Copied Cells from the shortcut menu.

5.
Either click Shift Cells Right to move the cells to the right, or click Shift Cells Down to move them down.

6.
Click OK. Excel shifts the existing cells and then pastes the range.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint