logo

Copy or move worksheets

Excel 2007 NL tips
10136, 10136-07, 2007, Excel, tip, Werkblad kopieren, Werkblad verplaatsen

Why copy each part individually into a new worksheet in Excel when you can move or copy an entire worksheet from another file all at once?

Copy Excel worksheets

Copy Excel Worksheets

  • Open both the Excel file containing the worksheet you want to copy and the file to which you want to copy it.
  • Right-click on the sheet tab of the worksheet to be copiedRight-click on the worksheet tab
  • Select Move or Copy Sheet
    Move or Copy Sheet option
  • The Move or Copy window appears
    Move or Copy window
  • Check the box for Create a copy
    Create a copy option
  • Select the destination Excel file
    Select target file
  • In this example, it’s Training voorbeeld 2
  • Choose where the copied sheet should be placed
    Choose target location in workbook
  • Click OK
  • The worksheet is now copied to the other Excel file at the specified location.

Move Only

  • By unchecking Create a copy, the sheet will be moved instead of copied.