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.
  • Please refer to this FAQ Excel - Convert a row into a column and vice-versa.
Do you need more help with Excel? Check out our forum!

Excel