how to copy and paste an entire workbook in excel?
Click on the down-arrow just to the right of the Open button. Excel displays a list of different ways you can open the selected workbook. Choose the Open As Copy option. Excel opens a copy of the workbook.