{"id":84,"date":"2016-01-10T17:01:52","date_gmt":"2016-01-11T01:01:52","guid":{"rendered":"http:\/\/www.susmg.info\/alandale\/tips\/?p=84"},"modified":"2016-09-02T01:14:39","modified_gmt":"2016-09-02T01:14:39","slug":"use-excels-paste-special-to-perform-calculations-when-pasting","status":"publish","type":"post","link":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/","title":{"rendered":"Use Excel’s Paste Special to perform calculations when pasting"},"content":{"rendered":"
\n
\n

Last week I was working with an Excel spreadsheet that had \"\"several columns of numbers.\u00a0 As it happened, I needed to increase all the numbers (and there were lots of them) by 1.\u00a0 So\u00a0 in the screen shot to the right, 24-Aug should be 4056 and 25-Aug should be 4068, etc.\u00a0 Changing the number in each cell manually would have been tedious and time-consuming.<\/p>\n

So what to do?\u00a0 \u00a0Use Excel\u2019s Paste Special feature.\u00a0 While Paste Special is more commonly used for Paste Values or Paste Link you can also use it to add the same number to a group of cells.<\/p>\n

To add 1 to a group of cells:<\/p>\n

    \n
  1. Enter 1 in a blank cell<\/li>\n
  2. Copy the cell containing 1<\/li>\n
  3. Select the cells containing numbers that you want to increase by 1<\/li>\n
  4. Right-click on the selected cells<\/li>\n
  5. Select Paste Special\"\"<\/li>\n
  6. In the Paste Special dialog box under Operation, select Add<\/li>\n
  7. Click on OK<\/li>\n<\/ol>\n

    \u00a0<\/strong>
    \n\"\"<\/p>\n

    As you will see from the Paste Special dialog box above, you can also use this feature to multiply, subtract and divide a group of cells by a number.\u00a0 For instance, if you had prices in a series of cells you could use this feature to increase or decrease them all by\u00a0the same percentage.<\/p>\n<\/div>\n<\/div>\n

    \n

    Any questions, please let me know<\/a>.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Last week I was working with an Excel spreadsheet that had several columns of numbers.\u00a0 As it happened, I needed to increase all the numbers (and there were lots of …<\/p>\n","protected":false},"author":2,"featured_media":35,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-84","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"\nUse Excel's Paste Special to perform calculations when pasting - Alandale Training Software Tips<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use Excel's Paste Special to perform calculations when pasting - Alandale Training Software Tips\" \/>\n<meta property=\"og:description\" content=\"Last week I was working with an Excel spreadsheet that had several columns of numbers.\u00a0 As it happened, I needed to increase all the numbers (and there were lots of ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/\" \/>\n<meta property=\"og:site_name\" content=\"Alandale Training Software Tips\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-11T01:01:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-09-02T01:14:39+00:00\" \/>\n<meta name=\"author\" content=\"John Chandler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Chandler\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Use Excel's Paste Special to perform calculations when pasting - Alandale Training Software Tips","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/","og_locale":"en_US","og_type":"article","og_title":"Use Excel's Paste Special to perform calculations when pasting - Alandale Training Software Tips","og_description":"Last week I was working with an Excel spreadsheet that had several columns of numbers.\u00a0 As it happened, I needed to increase all the numbers (and there were lots of ...","og_url":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/","og_site_name":"Alandale Training Software Tips","article_published_time":"2016-01-11T01:01:52+00:00","article_modified_time":"2016-09-02T01:14:39+00:00","author":"John Chandler","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Chandler","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/#article","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/"},"author":{"name":"John Chandler","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/3d915833a2c762b11624ae07740300e8"},"headline":"Use Excel’s Paste Special to perform calculations when pasting","datePublished":"2016-01-11T01:01:52+00:00","dateModified":"2016-09-02T01:14:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/"},"wordCount":217,"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/#primaryimage"},"thumbnailUrl":"","articleSection":["Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/","url":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/","name":"Use Excel's Paste Special to perform calculations when pasting - Alandale Training Software Tips","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/#primaryimage"},"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/#primaryimage"},"thumbnailUrl":"","datePublished":"2016-01-11T01:01:52+00:00","dateModified":"2016-09-02T01:14:39+00:00","author":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/3d915833a2c762b11624ae07740300e8"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/01\/10\/use-excels-paste-special-to-perform-calculations-when-pasting\/#primaryimage","url":"","contentUrl":""},{"@type":"WebSite","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website","url":"https:\/\/www.alandaletraining.com\/software-tips\/","name":"Alandale Training Software Tips","description":"Weekly Software Tips","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.alandaletraining.com\/software-tips\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/3d915833a2c762b11624ae07740300e8","name":"John Chandler","url":"https:\/\/www.alandaletraining.com\/software-tips\/author\/d5afe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":1,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"predecessor-version":[{"id":152,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/84\/revisions\/152"}],"wp:attachment":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/categories?post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/tags?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}