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

Chapter 1. Getting the Most Out of Ranges > Making Multiple Copies of a Range

Making Multiple Copies of a Range

If you need to make multiple copies of a range, you could execute a separate Paste command for each destination, but Excel offers an easier way. The following procedure gives the steps:

1.
Select the range you want to copy.

2.
Copy the range.

3.
Select the upper-left cell for each destination range (see Figure 1.11). The cells you select can be contiguous or noncontiguous.

Figure 1.11. To paste multiple copies, select the upper-left cell for each destination range.


4.
Choose Edit, Paste. Excel pastes the range to each destination, as shown in Figure 1.12.

Figure 1.12. When you execute the Paste command, Excel copies the range to each destination.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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