How to transfer data from one Excel sheet to another?

How to transfer data from one Excel sheet to another?

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
Convert number to spelling 28
How to calculate positions (1st,2nd,3rd...) in Excel 6
Comparing two columns of names in Excel 8
Unable to change date format in Excel 39
Excel - IF function with multiple words 14
How to convert number into text in Excel 9
Copying data from one Excel sheet to another. 30
If a cell contains any text then add a value 20
Removing " false" value in "IF" 10
Date formatting in dd/mm/yyyy 11
Around the same subject

Excel