copy without altering the value

F

freebee

Hi,
After I copied 5 rows+5 columns from the top to bottom of the same worksheet
(since it's very long), the cell value at the bottom were all different from
the top. How do I keep them the same?
Thank you.
 
F

freebee

Hi, my top cels have formulas. When top cels' values changed, how do I make
values in the bottom cels also change?
Is it possible to copy the top cels to another worksheet in the same
workbook and achieve the above?
thanks.
 
S

Sheeloo

Suppose you want the values in A1:E5 (5 rows and 5 columns) and (A101:E105 be
the same even if the values in A1:E5 change...

Then in A101 enter
=A1
then copy cell 101 and paste to A101:E105

If you want the same thing in Sheet2 A1:E5
then enter this in Sheet2 A1
=Sheet1!A1 then copy to A1:E5
 
S

ShaneDevenshire

Hi,

Select the 5 by 5 range and choose copy, move to the target cells and choose
Edit, Paste Special, Paste Link (the button at the bottom left of the dialog
box).
 
Top