Let us first try inserting some text before we move on. Open the new excel file and insert the following data.
You can copy the entire sheet by using the steps below:
Step (1): Select the option of “Move or Copy” after Right Clicking the Sheet Name.
Step (2): This will open the Move or Copy dialog box as shown below. Select worksheet and press Ok.
Now Tick the box for Create a copy on the bottom and select the option (move to end) to create this copied sheet at the end of the already existing sheets. Your new sheet is now ready with all the text copied as it is in the new sheet.
If you wish to give a new name, you can double click on the sheet and edit the default name. After entering the new name as desired, press the enter key to save the changes.