copy without altering the value

[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.

 

[Sheeloo]

Copy
then choose Edit|Paste Special and select VALUES and click OK

 

[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.

 

[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

 

[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).