Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & Paste Special Operations
Is it possible, when using the Paste Special Operations function to paste,
rather than have Excel paste the result of the operation to have it paste a formula? For example, say I have 100 in one cell and 50 in another, and I want to copy the cell that says 100 and paste it on the 50 with Paste Special Add function (or whatever function will actually do what I'm looking for) and instead of it pasting the value of the addition (150) pasting instead something like =50+100. As a corallary, would there be some way to do this where I could paste a formula with a reference instead, so that, for instance, with two cells, one with the value of 100 and one with the value of 50, if I copied the 100 into the 50, the cell would then read =50+[Cell Reference of cell that has value of 100 in it]. That way, if I subsequently changed what was in that cell, it would carry over to the new cell? |
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; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Copy Paste Operations | New Users to Excel | |||
Excel should remember copy/paste buffer across other operations | Excel Discussion (Misc queries) |