Ask a question »

Excel - Transfering data for a spreadsheet to another

November 2015

[Excel] Transfering data for a spreadsheet to another

It may happens that we need to transfer data from an Excel spreadsheet to another and that the copy paste function does not work!

However, there are several methods that can be used to handle this purpose.

Method 1

  • Consider that we have two sheets: Sheet 1 and Sheet 2 and we want to pass a data from cell A1 of sheet 1 to cell B1 of Sheet 2.
  • Select the target cell(in our case B1 of Sheet 2) and type in the + symbol
  • Right click on the Sheet 1 label button (at the button)
  • This wil bring you back to Sheet 1 click on cell A1 and press Enter.
  • This will automatically copy the data in cell B1.
    • Hint: If you performed the operation as mentioned above, then upon selecting cell A1, you should have this formula displayed in the formula bar: +Sheet1!A1

Method 2

  • Here we shall try to make use of the +Sheet(X)!(XX) formula.
  • Select the cell in which you want to swap the data.
  • In the formula bar type this command:

  • X stands for sheet label
  • XY stands for the targeted cell coordinates.
  • Don't take brackets into account.

E.g: +Sheet2!B21 : will copy data from cell B21 of sheet 2.
For unlimited offline reading, you can download this article for free in PDF format:

See also

In the same category

Pasar datos de una hoja Excel a otra
By Carlos-vialfa on April 14, 2009
Excel - jak kopiowa? dane mi?dzy arkuszami
By Karolllla on October 1, 2014
Original article published by Carlos-vialfa. Translated by jak58.
This document entitled « Excel - Transfering data for a spreadsheet to another » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.