To copy an Excel spreadsheet without losing the layout and format, you need to use the Formulas & Number Formatting option. For that, open an Excel spreadsheet, press Ctrl+A to select the entire sheet, and press Ctrl+C to copy the file. Then, open a new spreadsheet, click on the Paste option, and select the Formulas & Number Formatting option. It will continue using the same formulas and number formatting in the new file.