{"id":2059,"date":"2015-11-26T23:34:33","date_gmt":"2015-11-26T22:34:33","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2059"},"modified":"2023-11-30T21:49:06","modified_gmt":"2023-11-30T20:49:06","slug":"paste-special-a-values-multiplier-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/paste-special-a-values-multiplier-in-excel\/","title":{"rendered":"Excel Paste Special: A Values Multiplier"},"content":{"rendered":"<p>Paste Special has a few different Paste features and operations that many users do not know about.<\/p>\n<p>One of them is the <em><strong>Paste Special &gt; Values &gt; Multiply<\/strong><\/em> combination.<\/p>\n<p>What that does is multiply a range of selected cells by a value, called the multiplier. \u00a0So if you want to increase all your values by 10%, you can&#8230;.see how below:<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/OuYd6AvVMuw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Value-Miltiply.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Paste-Value-Miltiply.xlsx<\/span><\/a><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> <strong>Enter the amount to multiply by<\/strong> (the multiplier) in an empty cell, e.g. 1.10<img loading=\"lazy\" decoding=\"async\" title=\"Excel Paste Special: A Values Multiplier\"  class=\"alignnone size-full wp-image-19374\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-01.png\" alt=\"Excel Paste Special: A Values Multiplier\" width=\"675\" height=\"302\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-01.png 675w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-01-300x134.png 300w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> <strong>Copy<\/strong> that cell<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Paste Special: A Values Multiplier\"  class=\"alignnone size-full wp-image-19375\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-02.png\" alt=\"Excel Paste Special: A Values Multiplier\" width=\"704\" height=\"298\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-02.png 704w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-02-300x127.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> <strong>Select the data range<\/strong> you want to multiply, <strong>Right Click and select Paste Special<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Paste Special: A Values Multiplier\"  class=\"alignnone size-full wp-image-19376\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-03.png\" alt=\"Excel Paste Special: A Values Multiplier\" width=\"418\" height=\"493\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-03.png 418w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-03-254x300.png 254w\" sizes=\"(max-width: 418px) 100vw, 418px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong> <\/span>Select <strong>Values &amp; Multiply<\/strong> and press OK<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-26_23-14-30.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel Paste Special: A Values Multiplier\"  class=\"alignnone size-full wp-image-2061\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-26_23-14-30.png\" alt=\"Excel Paste Special: A Values Multiplier\" width=\"398\" height=\"325\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-26_23-14-30.png 398w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-26_23-14-30-300x245.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/a><\/p>\n<p>Your values have now been multiplied by the multiplier!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Paste Special: A Values Multiplier\"  class=\"alignnone size-full wp-image-19378\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-05.png\" alt=\"Excel Paste Special: A Values Multiplier\" width=\"642\" height=\"312\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-05.png 642w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Paste-Multiply-05-300x146.png 300w\" sizes=\"(max-width: 642px) 100vw, 642px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Paste Special has a few different Paste features and operations that many users do not know about. One of them is the Paste Special &gt; Values &gt; Multiply combination. What that does is multiply a range of selected cells by a value, called the multiplier. \u00a0So if you want to increase all your values by [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17372,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,41],"tags":[88,113],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2059"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=2059"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/2059\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17372"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=2059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=2059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=2059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}