HomeApplicationOffice information

How to copy sheet from Excel file to another Excel file

While working with Excel, there are times when you want to copy the sheet from one Excel file to another Excel file to facilitate data processing. If you do not know how to copy sheet, please refer to how to copy sheet in Excel to other Excel file in this article.

How to copy sheet from Excel file to another Excel file Picture 1

Here TipsMake.com share to you how to copy the sheet in this Excel file to another Excel file, invite you to follow along.

If you want to copy Sheet1 in Excel Book1 file to Excel Book2 file, do as follows:

Step 1: Open the two files Excel Book1 and Book2.

How to copy sheet from Excel file to another Excel file Picture 2

Step 2: In the Excel Book1 file, right-click Sheet1 and select Move or Copy .

How to copy sheet from Excel file to another Excel file Picture 3

Step 3: In the Move or Copy dialog box, select Book2 in To book , in the Before sheet section, select the location for Sheet1 to copy in Book2. Note you choose Create a Copy to copy Sheet1, if not selected then all Sheet1 in Book1 file will be lost.

How to copy sheet from Excel file to another Excel file Picture 4

So you have copied the sheet from Excel to Excel there.

How to copy sheet from Excel file to another Excel file Picture 5

Or you can make copy sheet in Excel to another Excel file manually as follows:

Step 1: Open the first Excel file containing the sheet to copy, press Ctrl + A to copy all the sheets.

How to copy sheet from Excel file to another Excel file Picture 6

Step 2: Open the second Excel file, click the New sheet icon to create a new sheet.

How to copy sheet from Excel file to another Excel file Picture 7

Step 3: Press Ctrl + V to paste the copied sheet into the new sheet of this second Excel file. So you copied the sheet from the first Excel file to the second Excel file.

How to copy sheet from Excel file to another Excel file Picture 8

Above TipsMake.com has instructed you how to copy this Excel sheet to another Excel file. Hopefully through this article, you will understand and quickly copy the sheet as required. Good luck!

4 ★ | 1 Vote

You should read it

May be interested

  • How to Unprotect an Excel SheetHow to Unprotect an Excel Sheet
    this wikihow teaches you how to unprotect a sheet within a microsoft excel workbook in windows or macos. if the sheet is protected by a password and you're not sure what it is, you can use google sheets or a vba script (in earlier versions...
  • How to lock Excel Sheet, set a password for the sheet in ExcelHow to lock Excel Sheet, set a password for the sheet in Excel
    lock sheet, set password for data sheet in excel to create security for your data file, do not let anyone edit or add data. tipsmake.com will guide you how to do in our article below.
  • How to display Sheet Tab in Excel when hidden, not displayedHow to display Sheet Tab in Excel when hidden, not displayed
    excel's sheet tab is used to manage work sheets easily. however, during the data processing process, the sheet tab suddenly becomes hidden, making you wonder how to handle this situation? so let's learn how to display sheet tab in excel when hidden to help you solve problems and work more efficiently.
  • How to hide and show Sheet in ExcelHow to hide and show Sheet in Excel
    sometimes working with too many sheets makes you confused, or you don't want important sheets being viewed by others on your computer ..., or for some reason you want to hide the sheet and when necessary then display the sheet.
  • Recover deleted Sheet in ExcelRecover deleted Sheet in Excel
    when you delete sheet in excel, it seems that the undo keyboard shortcut has no effect. so how to recover deleted sheet in excel?
  • how to fix error cannot copy data in Excel fileshow to fix error cannot copy data in Excel files
    in the process of using the computer, there will be times when we encounter an error that we cannot copy data in excel. the cause may be that the computer has a virus, the clipboard is not working, and therefore the copy command (ctrl + c) and the paste command (ctrl + v) are not working.
  • Shortcut switch Sheet in ExcelShortcut switch Sheet in Excel
    shortcut switch sheet in excel. are you looking for a shortcut combination to quickly switch sheet in excel to make the process of working between sheets faster? below the article shared to you the sheet shortcut shortcut in excel, invite you to tickle
  • Tips with spreadsheets (sheet) in ExcelTips with spreadsheets (sheet) in Excel
    in excel spreadsheets to manage excel data using sheet tabs, you can easily add, delete, rename or customize the settings as you like for the worksheets in excel worksheet. here are some basic tips when working with sheets in e
  • How to rename, copy and move spreadsheets in ExcelHow to rename, copy and move spreadsheets in Excel
    instructions on how to rename, copy and move spreadsheets in excel. 1. how to change the name of the worksheet (sheet) in excel - method 1: + double-click the worksheet name - when the selected worksheet name is entered, enter the new name of the worksheet: + after entering the name
  • How to use PDF Anti-copy to protect PDF filesHow to use PDF Anti-copy to protect PDF files
    pdf anti-copy is software that protects pdf files, preventing the ability to copy all data, even when converting pdf files to word or excel.

Office information