In order to work with an Excel spreadsheet, you need to be able to create a copy of the spreadsheet. This can be done in two ways. You can copy the whole thing or only certain parts that you want to keep. Copy-only method The first method is by using…