Question: how do i copy an excel spreadsheet without losing the layout and 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.