Question: how to copy excel sheet with same format?
Answer: Right click on the worksheet tab and select Move or Copy. Select the Create a copy checkbox. Under Before sheet, select where you want to place the copy. Select OK.