Question: how to copy and paste link in excel?
Answer: Copy the data you want to transpose and link, as you normally would. Select any cell in an unused worksheet. Choose Paste Special from the Edit menu. ...  Click on the Paste Link button. ...  Press Ctrl+H to display the Replace dialog box. ...  In the Find What area, type an equal sign.