1-866-245-5224 sales@keystonelearning.com

Excel 2007: Copy & Paste Worksheets

Excel 2007: Copy & Paste Worksheets

How many times have you heard, “Don’t reinvent the wheel,” or, “If it ain’t broke, don’t fix it”? Well, the same theory can be applied to Excel. If you already have the shell of a worksheet and you just need to adjust some numbers, don’t start from scratch – use what you already have.

In order to copy and paste worksheets, you simply need to combine your knowledge of data copy and paste with your knowledge of moving worksheets. Now, data copy and paste is something covered in the Excel 2007 Beginner, but we just talked about moving worksheets.

Copying & Pasting Worksheets Using the Ribbon

     
  1. Select the worksheet you want to copy
     
  2.  
  3. Click Format in the Cells group on the Home tab
     
  4.  
  5. Choose Move or Copy… from the drop-down list
     

Figure 4. Move or Copy Dialog Box

    4.       Select a new worksheet location

    5.       Click the check box next to Create a copy

    6.       Click OK

Copying & Pasting Worksheets Using the Shortcut Menu

     
  1. Right-click the worksheet tab you want to copy
     
  2.  
  3. Choose Move or Copy… from the shortcut list
     
  4.  
  5. Select a new worksheet location
     
  6.  
  7. Click the check box next to Create a copy
     
  8.  
  9. Click OK
     

Copying a Worksheet Tab by Dragging

     
  1. Press and hold [CTRL]
     
  2.  
  3. Click and Drag the worksheet tab you want to move to its new location