Question: how do i copy an excel spreadsheet without losing formatting?
Answer: Right click on the tab and select Move or Copy from the context menu. This will open the Move or Copy dialog box.
Under Before sheet, choose where you want to place the copy.
Put a tick in the Create a copy box.
Click OK.