Copying the sheet in the same Excel file is quite simple, but if you copy the sheet from one Excel file to another, the operation will be a bit more complicated. If you do not know how to do it, please follow the instructions in the article below.
You probably know that Microsoft Excel is a spreadsheet processing application in Microsoft’s MS Office suite, which helps users present processing information in the form of data tables, perform calculations, and build statistics. Statistics intuitive, effective. In addition to the main features used, copying, Copy the sheet from one Excel file to another It is also done quite easily, thereby helping users to search and organize data quickly and conveniently.
Move the sheet to another Excel file.
How to copy sheet from Excel file to another Excel file
In this article, we will demonstrate how to move and copy sheets from one Excel file to another using Excel file Excel 2016. Other versions of Excel such as Excel 2013 and 2010 do the same.
Step 1: First, you need to open both files containing the sheet to copy and the file to move the sheet into, for example, you want to copy the Sheet with the name Taimienphi.vn of the file Taimienphi.vn-Copy, move Sheet in Excel.xls to file Taimienphi.vn-Copy-sheet.xlsx.
You open and open these 2 files -> then right-click on the Sheet to transfer -> select Move or Copy…
Step 2: A interface of copy and move window appears as shown below -> you select the file you want to move, for example, you want to transfer the sheet Taimienphi.vn from Taimienphi.vn-Copy, move Sheet in Excel.xls to file Taimienphi.vn-Copy-sheet.xlsx -> tick selected Create a copy -> then press select OK, got it
Step 3: After pressing OK, got it, you move to the newly transferred file, copy to see if a sheet has been copied yet. As a result, you will see the newly copied sheet as the interface shown in the image below:
Similarly, if you have other sheets that need to be converted to another Excel file, then you follow the same instructions above. If two sheets of the same name (for example, the copy sheet is sheet 1 and the other Excel file also has the current sheet is sheet 1), when copied to it will display as Sheet1 (2).
Above is the tutorial Copy sheet from Excel file to Excel file Another helps users quickly copy the entire contents of a sheet and paste intact content and formatting into a completely new Excel file.
The copy, transfer sheet in Excel above, basically the operations for users to perform quite simple. You can move data in the same sheet or you can move the entire sheet to a new file.
Also, if you need to learn to get things done Filter data between the Sheet In Excel, please refer to the implementation method introduced on Taimienphi.vn and follow it! Good luck!