How to transfer data from one Excel sheet to another?
![How to transfer data from one Excel sheet to another?](https://img-19.ccm.net/SvakY4ipykZDCWc-je-DGVTsfMU=/480x335/smart/b195aa20d0664534930c681cd1b644a4/ccmcms-enccm/32652937.jpg)
Read this short guide if you would like to transfer data between two Excel spreadsheets. We will show you how to bind data from a column to a row in another sheet.
How to transfer data between two Excel spreadsheets?
Consider that the data to be copied are on Sheet1! B2:H2 and and the targeted ones in Sheet2! C3:C9 (the number of cells are identical).
- Select the second range (Sheet2)
- Type = TRANSPOSE =TRANSPOSE(Sheet1!B2:H2)
- Confirm with CTRL + SHIFT + ENTER to obtain an array formula.
Note: Only the content is copied, to the format of the destination cells
How to transfer data on Excel via a command?
There is also a command that can achieve this manipulation:
- Copy/Paste > Paste Special > Transpose.
Do you need more help with Excel? Check out our forum!
Subject
Replies