Question: how to copy and paste in excel table?
Answer: In Excel, select the data you want to copy, and then press Ctrl+C.
Open the other Office program, click where you want to paste the data, and then press Ctrl+V.
Click Paste Options next to the data, and choose how you want to paste it. Keep Source Formatting This keeps the data formatting exactly as is.