moving cells to new sheets

[D Abramovich]

I am trying to tidy up a fairly large and complex workbook
that is all (quite confusingly) kept on one sheet.

Is there any way to move cells to other worksheets and
have them hold on to their original reference from the
original sheet?
e.g. easily copy cell from Sheet 1 with say, (=R1/2) to
Sheet2 so it now has the formula (='Sheet1'!R1/2)

Thanks

David

 

[Max]

Try: Cut (from Sheet 1) > Paste (in Sheet 2)

 

[JMay]

An alternative,, right-click on your source-tab and select Move or Copy...