| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help me with altering text in excel | New Users to Excel | |||
| Altering the X-axis | Charts and Charting in Excel | |||
| Altering VLookup Formula | Excel Worksheet Functions | |||
| Values won't display after altering a formula. | Excel Worksheet Functions | |||
| Formula keeps altering by itself! | Excel Worksheet Functions | |||
Hybrid Mode
