You are working in an Excel file and realize you need to duplicate the data. If you have a lot of formatting, manually entering this data is a nightmare.
You can copy your data to another spreadsheet.
In your source workbook, look toward the bottom left-hand corner and find the name of the sheet you want to copy. Sheet 1, unless you renamed it.
Right-click on the sheet you want to copy
Select “Move or Copy” from the menu.
In the "To Book" drop down, click the drop down arrow and select either new book or one the open spreadsheets
Click the create a copy checkbox on the bottom the window
A new spreadsheet will open with your data.