Tags: button, divide, example, excel, expliain, microsoft, msdn, multiply, operation, paste, radio, sbtract, software, special

Use of Paste Special - Operation

On Microsoft » Microsoft Excel

13,971 words with 10 Comments; publish: Fri, 23 May 2008 18:37:00 GMT; (30678.13, « »)

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.

All Comments

Leave a comment...

  • 10 Comments
    • "Avadivelan TCS" <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote in message

      news:94446701-4794-46F2-A489-98CF273FAA60.excel.questionfor.info.microsoft.com...

      > 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

      #1; Fri, 23 May 2008 18:38:00 GMT
    • Deactivate several hyperlinks at once

      1.. Type the number 1 in a blank cell, and right-click the cell. 2.. Click Copy on the shortcut menu. 3.. While pressing CTRL, select each hyperlink you want to =deactivate. 4.. Click Paste Special on the Edit menu. 5.. Under Operation, click Multiply and then click OK. The above is from Excel Help. This is one example of using multiply.

      I also use multiply by 1 to convert numbers in text format (i.e. left =aligned in a cell) to number format (i.e. right aligned). "Add 0" =achieves the same.

      Epinn

      "David Biddulph" <david.excel.questionfor.info.biddulph.org.uk> wrote in message =news:aIqdnbU9beZT1bbYnZ2dnUVZ8qudnZ2d.excel.questionfor.info.bt.com...

      "Avadivelan TCS" <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote in =message news:94446701-4794-46F2-A489-98CF273FAA60.excel.questionfor.info.microsoft.com...

      > 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=20

      #2; Fri, 23 May 2008 18:39:00 GMT
    • Epinn, that's not what the Operations are for.

      They were there before hyperlink's existed.

      remember KIS

      Steve

      On Tue, 10 Oct 2006 08:41:49 +0100, Epinn <someone.excel.questionfor.info.example.com.NO_SPAM> = =

      wrote:

      > Deactivate several hyperlinks at once

      > 1.. Type the number 1 in a blank cell, and right-click the cell.

      > 2.. Click Copy on the shortcut menu.

      > 3.. While pressing CTRL, select each hyperlink you want to deactiva=te.

      > 4.. Click Paste Special on the Edit menu.

      > 5.. Under Operation, click Multiply and then click OK.

      > The above is from Excel Help. This is one example of using multiply.

      > I also use multiply by 1 to convert numbers in text format (i.e. left = =

      > aligned in a cell) to number format (i.e. right aligned). "Add 0" =

      > achieves the same.

      > Epinn

      > "David Biddulph" <david.excel.questionfor.info.biddulph.org.uk> wrote in message =

      > news:aIqdnbU9beZT1bbYnZ2dnUVZ8qudnZ2d.excel.questionfor.info.bt.com...

      > "Avadivelan TCS" <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote in =

      > message

      > news:94446701-4794-46F2-A489-98CF273FAA60.excel.questionfor.info.microsoft.com...

      >> 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 cel=l,

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

      #3; Fri, 23 May 2008 18:40:00 GMT
    • I know. But the poster wants an example. It's good that you clarify.

      Epinn

      "Epinn" <someone.excel.questionfor.info.example.com.NO_SPAM> wrote in message =news:OYl4X$D7GHA.4996.excel.questionfor.info.TK2MSFTNGP03.phx.gbl...

      Deactivate several hyperlinks at once

      1.. Type the number 1 in a blank cell, and right-click the cell. 2.. Click Copy on the shortcut menu. 3.. While pressing CTRL, select each hyperlink you want to =deactivate. 4.. Click Paste Special on the Edit menu. 5.. Under Operation, click Multiply and then click OK. The above is from Excel Help. This is one example of using multiply.

      I also use multiply by 1 to convert numbers in text format (i.e. left =aligned in a cell) to number format (i.e. right aligned). "Add 0" =achieves the same.

      Epinn

      "David Biddulph" <david.excel.questionfor.info.biddulph.org.uk> wrote in message =news:aIqdnbU9beZT1bbYnZ2dnUVZ8qudnZ2d.excel.questionfor.info.bt.com...

      "Avadivelan TCS" <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote in =message news:94446701-4794-46F2-A489-98CF273FAA60.excel.questionfor.info.microsoft.com...

      > 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=20

      #4; Fri, 23 May 2008 18:41:00 GMT
    • Have you tried using the operation options to see what happens?

      They add, subtract,multiply and divide the selected cell(s) by what you have

      copied onto the clipboard.

      i.e. you have 10 in A1

      You have 3 in B1

      Copy B1 and paste special>multiply to A1

      What result do you get?

      Gord Dibben MS Excel MVP

      On Tue, 10 Oct 2006 00:00:02 -0700, Avadivelan TCS

      <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote:

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

      #5; Fri, 23 May 2008 18:42:00 GMT
    • I think sometimes a "bonus" not explained clearly can confuse people. =Sorry about that. I'll do my best to remember to keep it simple.

      Epinn

      "Epinn" <someone.excel.questionfor.info.example.com.NO_SPAM> wrote in message =news:OIri1gI7GHA.4496.excel.questionfor.info.TK2MSFTNGP05.phx.gbl...

      I know. But the poster wants an example. It's good that you clarify.

      Epinn

      "Epinn" <someone.excel.questionfor.info.example.com.NO_SPAM> wrote in message =news:OYl4X$D7GHA.4996.excel.questionfor.info.TK2MSFTNGP03.phx.gbl...

      Deactivate several hyperlinks at once

      1.. Type the number 1 in a blank cell, and right-click the cell. 2.. Click Copy on the shortcut menu. 3.. While pressing CTRL, select each hyperlink you want to =deactivate. 4.. Click Paste Special on the Edit menu. 5.. Under Operation, click Multiply and then click OK. The above is from Excel Help. This is one example of using multiply.

      I also use multiply by 1 to convert numbers in text format (i.e. left =aligned in a cell) to number format (i.e. right aligned). "Add 0" =achieves the same.

      Epinn

      "David Biddulph" <david.excel.questionfor.info.biddulph.org.uk> wrote in message =news:aIqdnbU9beZT1bbYnZ2dnUVZ8qudnZ2d.excel.questionfor.info.bt.com...

      "Avadivelan TCS" <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote in =message news:94446701-4794-46F2-A489-98CF273FAA60.excel.questionfor.info.microsoft.com...

      > 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=20

      #6; Fri, 23 May 2008 18:43:00 GMT
    • Epinn, it's a public forum - I don't push standards or guide lines

      The *extras or bonus* stuff is what makes these forums a bonus :)

      I really only meant that maybe a complicated answer should be presented =as =

      *bonus* rather than the *answer*

      Steve

      On Tue, 10 Oct 2006 17:50:52 +0100, Epinn <someone.excel.questionfor.info.example.com.NO_SPAM> = =

      wrote:

      > I think sometimes a "bonus" not explained clearly can confuse people. = =

      > Sorry about that. I'll do my best to remember to keep it simple.

      > Epinn

      > "Epinn" <someone.excel.questionfor.info.example.com.NO_SPAM> wrote in message =

      > news:OIri1gI7GHA.4496.excel.questionfor.info.TK2MSFTNGP05.phx.gbl...

      > I know. But the poster wants an example. It's good that you clarify.=

      > Epinn

      > "Epinn" <someone.excel.questionfor.info.example.com.NO_SPAM> wrote in message =

      > news:OYl4X$D7GHA.4996.excel.questionfor.info.TK2MSFTNGP03.phx.gbl...

      > Deactivate several hyperlinks at once

      > 1.. Type the number 1 in a blank cell, and right-click the cell.

      > 2.. Click Copy on the shortcut menu.

      > 3.. While pressing CTRL, select each hyperlink you want to deactiva=te.

      > 4.. Click Paste Special on the Edit menu.

      > 5.. Under Operation, click Multiply and then click OK.

      > The above is from Excel Help. This is one example of using multiply.

      > I also use multiply by 1 to convert numbers in text format (i.e. left = =

      > aligned in a cell) to number format (i.e. right aligned). "Add 0" =

      > achieves the same.

      > Epinn

      > "David Biddulph" <david.excel.questionfor.info.biddulph.org.uk> wrote in message =

      > news:aIqdnbU9beZT1bbYnZ2dnUVZ8qudnZ2d.excel.questionfor.info.bt.com...

      > "Avadivelan TCS" <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote in =

      > message

      > news:94446701-4794-46F2-A489-98CF273FAA60.excel.questionfor.info.microsoft.com...

      >> 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 cel=l,

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

      #7; Fri, 23 May 2008 18:44:00 GMT
    • Don't worry Steve. Believe it or not when I posted that writeup, it did =cross my mind if I made it more complicated for the user than I should.

      Epinn

      "SteveW" <sj_walton.excel.questionfor.info.nothotmail.com> wrote in message =news:op.tg7yjz1oevjsnp.excel.questionfor.info.enigma03...

      Epinn, it's a public forum - I don't push standards or guide lines

      The *extras or bonus* stuff is what makes these forums a bonus :)

      I really only meant that maybe a complicated answer should be presented =as *bonus* rather than the *answer*

      Steve

      On Tue, 10 Oct 2006 17:50:52 +0100, Epinn <someone.excel.questionfor.info.example.com.NO_SPAM> =

      wrote:

      > I think sometimes a "bonus" not explained clearly can confuse people. = > Sorry about that. I'll do my best to remember to keep it simple.

      > Epinn

      > "Epinn" <someone.excel.questionfor.info.example.com.NO_SPAM> wrote in message > news:OIri1gI7GHA.4496.excel.questionfor.info.TK2MSFTNGP05.phx.gbl...

      > I know. But the poster wants an example. It's good that you clarify.

      > Epinn

      > "Epinn" <someone.excel.questionfor.info.example.com.NO_SPAM> wrote in message > news:OYl4X$D7GHA.4996.excel.questionfor.info.TK2MSFTNGP03.phx.gbl...

      > Deactivate several hyperlinks at once

      > 1.. Type the number 1 in a blank cell, and right-click the cell.

      > 2.. Click Copy on the shortcut menu.

      > 3.. While pressing CTRL, select each hyperlink you want to =deactivate.

      > 4.. Click Paste Special on the Edit menu.

      > 5.. Under Operation, click Multiply and then click OK.

      > The above is from Excel Help. This is one example of using multiply.

      > I also use multiply by 1 to convert numbers in text format (i.e. left =

      > aligned in a cell) to number format (i.e. right aligned). "Add 0" > achieves the same.

      > Epinn

      > "David Biddulph" <david.excel.questionfor.info.biddulph.org.uk> wrote in message > news:aIqdnbU9beZT1bbYnZ2dnUVZ8qudnZ2d.excel.questionfor.info.bt.com...

      > "Avadivelan TCS" <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote in > message

      > news:94446701-4794-46F2-A489-98CF273FAA60.excel.questionfor.info.microsoft.com...

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

      #8; Fri, 23 May 2008 18:45:00 GMT
    • Thanks David & Epinn

      "David Biddulph" wrote:

      > "Avadivelan TCS" <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote in message

      > news:94446701-4794-46F2-A489-98CF273FAA60.excel.questionfor.info.microsoft.com...

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

      >

      >

      #9; Fri, 23 May 2008 18:46:00 GMT
    • I got the result 30. correct...!

      "Gord Dibben" wrote:

      > Have you tried using the operation options to see what happens?

      > They add, subtract,multiply and divide the selected cell(s) by what you have

      > copied onto the clipboard.

      > i.e. you have 10 in A1

      > You have 3 in B1

      > Copy B1 and paste special>multiply to A1

      > What result do you get?

      >

      > Gord Dibben MS Excel MVP

      > On Tue, 10 Oct 2006 00:00:02 -0700, Avadivelan TCS

      > <AvadivelanTCS.excel.questionfor.info.discussions.microsoft.com> wrote:

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

      >

      #10; Fri, 23 May 2008 18:47:00 GMT