Question: how do you copy and paste an excel sheet and keep formatting?
Answer: Select the cell with the desired format and press Ctrl+C to copy its content and formats.
Select the entire column or row that you want to format by clicking on its heading.
Right-click the selection, and then click Paste Special.