Use of Paste Special - Operation
Thanks David & Epinn
"David Biddulph" wrote:
"Avadivelan TCS" wrote in message
...
Hi All,
In the PASTE SPECIAL ,what is the use of
OPERATION(Add,Sbtract,Multiply,Divide)
radio button. can anybody expliain with example.
Thanks in advance for your reply.
If you have a cell with the value 3, for example, if you copy that cell,
then select a range of cells and use Paste Special/ Multiply, it will
multiply the value in each cell in the selected range by 3.
--
David Biddulph
|