Ask a question »

Transfer Data Between Excel Spreadsheets

May 2016

This article will teach you how to transfer data from one Excel spreadsheet to another if your copy and paste function is not working. The two methods presented will utilize a quick formula that you can apply to data present in the same Microsoft Excel file.

Transfer Data from One Spreadsheet to Another

For each example, consider that we have two sheets: Sheet 1 and Sheet 2 and we would like to transfer from cell A1 of sheet 1 to cell B1 of Sheet 2.

Using the + Symbol in Excel

Start by selecting the target cell (in our case B1 of Sheet 2) and typing in the + symbol.

Next, right-click on the Sheet 1 label button to go back to your data. Click on cell A1 and press Enter.

Your data will be automatically copied into cell B1.

Hint: If you performed the operation correctly, then upon selecting cell A1, you should have the following formula displayed in the formula bar: +Sheet1!A1.

Using the +Sheet(X)!((XY) Formula

The second method will make use of the +Sheet(X)!(XY) formula.

Select the cell in which you would like to swap the data and type
into the formula bar.

Using the conditions above, the formula +Sheet2!B21 will copy data from cell B21 of Sheet 2.

N.B. "X" stands for "sheet label;" and "XY" stands for the targeted cell coordinates.

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. - Latest update by ChristinaCCM
This document entitled « Transfer Data Between Excel Spreadsheets » 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.