Forum Discussion

williams_ash's avatar
williams_ash
Copper Contributor
Mar 02, 2021

Copy and paste

Hi,

 

I am currently trying to transfer multiple addresses from one spreadsheet to another, however when I paste I get a #ref error in the boxes when it paste to the new spreadsheet. If there a way to get around this so I don't have to manually transfer each address?

excel

1 Reply

  • Marley330's avatar
    Marley330
    Copper Contributor
    Mar 02, 2021
    Have you tried pasting values? When you click in the cell you want to paste into, right click and look for the icon with A.

Resources