| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and paste special
Hello
I don't know this is a stupid question, but what is the difference between a regular copy and paste routine and the copy and paste special --Formulas on a cell which has the result of some calculation? I tried the copy and paste special on a cell that had the formula =a1+a2. When I tried to do the paste special --formulas into a cell 2 columns across, the formula modified as =c1+c2. If this is indeed what is to be expected, why can't we just use the regular copy and paste which will give the same result? I am not keen on giving the absolute references to the formula to make sure it doesn't change. Please help. Thanks. -- Thanks and regards LAKSHMI VINAY -- Thanks and regards LAKSHMI VINAY |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy and paste special
doesn't copy cell format, etc
"Lakshmi Vinay" wrote: Hello I don't know this is a stupid question, but what is the difference between a regular copy and paste routine and the copy and paste special --Formulas on a cell which has the result of some calculation? I tried the copy and paste special on a cell that had the formula =a1+a2. When I tried to do the paste special --formulas into a cell 2 columns across, the formula modified as =c1+c2. If this is indeed what is to be expected, why can't we just use the regular copy and paste which will give the same result? I am not keen on giving the absolute references to the formula to make sure it doesn't change. Please help. Thanks. -- Thanks and regards LAKSHMI VINAY -- Thanks and regards LAKSHMI VINAY |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy and paste special
Paste Special only pastes the selected element.
Try this, put a border on your original cell and make the text bold. Now compare the difference between Paste Special -- Formulas and just Paste. -- If this helps, please click "Yes" <<<<<<<<<<< "Lakshmi Vinay" wrote: Hello I don't know this is a stupid question, but what is the difference between a regular copy and paste routine and the copy and paste special --Formulas on a cell which has the result of some calculation? I tried the copy and paste special on a cell that had the formula =a1+a2. When I tried to do the paste special --formulas into a cell 2 columns across, the formula modified as =c1+c2. If this is indeed what is to be expected, why can't we just use the regular copy and paste which will give the same result? I am not keen on giving the absolute references to the formula to make sure it doesn't change. Please help. Thanks. -- Thanks and regards LAKSHMI VINAY -- Thanks and regards LAKSHMI VINAY |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Copy paste special | Excel Discussion (Misc queries) | |||
| Copy, Paste Special Value | Excel Discussion (Misc queries) | |||
| Copy and Paste special | Excel Discussion (Misc queries) | |||
| Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Hybrid Mode
