Forum Discussion
Help with copying word data to match excel format
Hello, I am trying to find a way that I can copy data from a word file and have it match the layout setup in the excel file I am pasting to all at one time. So far I have used paste transpose, but it...
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.