excel - Copy the selected cells to new worksheet and show where it came from -

I copy a cell and paste the shortcut from worksheet A to worksheet B. Now, I want to add a cell to worksheet B. And tell where it came from. How can i Thx!

Leo

The example marks will show an arrow indicating a sheet. But this cell does not show the name of the reference or sheet, one way to get the sheet and cell reference is to enter a mark in the cell below the copied cell and go to the cell on the sheet from which it was copied and enter Press the text sheet in cell 1! Comes to the destination cell with the underlying formula like the C4. Now go to the Tools menu and click View Options check the View formula check box and click OK to dismiss the options window. Now the formula = is displayed with the icon just remove the mark and go to the option and clear the check on the formula. Cell reference is now displayed.