copy without altering the value
 

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.

copy without altering the value
 

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

"freebee" wrote:

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.

copy without altering the value
 

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" wrote:

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

"freebee" wrote:

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.

copy without altering the value
 

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

"freebee" wrote:

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" wrote:

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

"freebee" wrote:

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.

copy without altering the value
 

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


--
Thanks,
Shane Devenshire


"freebee" wrote:

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.