{"id":829,"date":"2017-05-30T20:00:00","date_gmt":"2017-05-31T03:00:00","guid":{"rendered":"https:\/\/ml2solutions.com\/?p=829"},"modified":"2021-05-02T17:08:50","modified_gmt":"2021-05-03T00:08:50","slug":"copy-formula-in-excel-without-changing-the-references","status":"publish","type":"post","link":"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/","title":{"rendered":"Copy Formula in Excel Without Changing the References"},"content":{"rendered":"<p>I had a need to copy a formula in Excel but didn\u2019t want part of the formula to change.&nbsp;&nbsp; I did some research and found out part of the formula that references other cells can be made absolute.&nbsp; This is done putting a \u201c$\u201d in front of the cell reference like this ($A$1).&nbsp;&nbsp; The $ can be put at both parts or just one part is desired.<\/p>\n<p>&nbsp;<\/p>\n<p>Resources:<\/p>\n<ul>\n<li><a title=\"https:\/\/www.ablebits.com\/office-addins-blog\/2016\/01\/20\/copy-formula-excel\/\" href=\"https:\/\/www.ablebits.com\/office-addins-blog\/2016\/01\/20\/copy-formula-excel\/\">https:\/\/www.ablebits.com\/office-addins-blog\/2016\/01\/20\/copy-formula-excel\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I had a need to copy a formula in Excel but didn\u2019t want part of the formula to change.&nbsp;&nbsp; I did some research and found out part of the formula [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[120],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Copy Formula in Excel Without Changing the References - ML2 Solutions<\/title>\n<meta name=\"description\" content=\"Copy Formula in Excel Without Changing the References I had a need to copy a formula in Excel but didn\u2019t want part of the formula to change.&nbsp;&nbsp; I did some research and found out part of the formula\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Copy Formula in Excel Without Changing the References - ML2 Solutions\" \/>\n<meta property=\"og:description\" content=\"Copy Formula in Excel Without Changing the References I had a need to copy a formula in Excel but didn\u2019t want part of the formula to change.&nbsp;&nbsp; I did some research and found out part of the formula\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/\" \/>\n<meta property=\"og:site_name\" content=\"ML2 Solutions\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ml2solutions\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ml2solutions\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-31T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-03T00:08:50+00:00\" \/>\n<meta name=\"author\" content=\"Matt Woicik\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ml2solutions\" \/>\n<meta name=\"twitter:site\" content=\"@ml2solutions\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matt Woicik\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/\"},\"author\":{\"name\":\"Matt Woicik\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd\"},\"headline\":\"Copy Formula in Excel Without Changing the References\",\"datePublished\":\"2017-05-31T03:00:00+00:00\",\"dateModified\":\"2021-05-03T00:08:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/\"},\"wordCount\":87,\"publisher\":{\"@id\":\"https:\/\/ml2solutions.com\/#organization\"},\"articleSection\":[\"IT\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/\",\"url\":\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/\",\"name\":\"Copy Formula in Excel Without Changing the References - ML2 Solutions\",\"isPartOf\":{\"@id\":\"https:\/\/ml2solutions.com\/#website\"},\"datePublished\":\"2017-05-31T03:00:00+00:00\",\"dateModified\":\"2021-05-03T00:08:50+00:00\",\"description\":\"Copy Formula in Excel Without Changing the References I had a need to copy a formula in Excel but didn\u2019t want part of the formula to change.&nbsp;&nbsp; I did some research and found out part of the formula\",\"breadcrumb\":{\"@id\":\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ml2solutions.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IT\",\"item\":\"https:\/\/ml2solutions.com\/category\/it\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Copy Formula in Excel Without Changing the References\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ml2solutions.com\/#website\",\"url\":\"https:\/\/ml2solutions.com\/\",\"name\":\"ML2 Solutions\",\"description\":\"Helping you get more leads and make more sales\",\"publisher\":{\"@id\":\"https:\/\/ml2solutions.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ml2solutions.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ml2solutions.com\/#organization\",\"name\":\"ML2 Solutions\",\"url\":\"https:\/\/ml2solutions.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png\",\"contentUrl\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png\",\"width\":303,\"height\":54,\"caption\":\"ML2 Solutions\"},\"image\":{\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ml2solutions\",\"https:\/\/x.com\/ml2solutions\",\"https:\/\/www.instagram.com\/ml2solutions\/\",\"https:\/\/www.pinterest.com\/ml2solutions\/\",\"https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd\",\"name\":\"Matt Woicik\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g\",\"caption\":\"Matt Woicik\"},\"description\":\"Matt is a digital marketing strategist and the owner of ML2 Solutions, a digital marketing agency. He helps businesses increase awareness and get more leads using digital marketing. New marketing methods are confusing, always changing and difficult to figure out. Matt helps to explain things and provide solutions with clear results.\",\"sameAs\":[\"https:\/\/ml2solutions.com\",\"https:\/\/www.facebook.com\/ml2solutions\",\"https:\/\/www.instagram.com\/ml2solutions\/\",\"https:\/\/www.linkedin.com\/company\/ml2solutions\/\",\"https:\/\/www.pinterest.com\/ml2solutions\/\",\"https:\/\/x.com\/ml2solutions\",\"https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Copy Formula in Excel Without Changing the References - ML2 Solutions","description":"Copy Formula in Excel Without Changing the References I had a need to copy a formula in Excel but didn\u2019t want part of the formula to change.&nbsp;&nbsp; I did some research and found out part of the formula","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:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/","og_locale":"en_US","og_type":"article","og_title":"Copy Formula in Excel Without Changing the References - ML2 Solutions","og_description":"Copy Formula in Excel Without Changing the References I had a need to copy a formula in Excel but didn\u2019t want part of the formula to change.&nbsp;&nbsp; I did some research and found out part of the formula","og_url":"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/","og_site_name":"ML2 Solutions","article_publisher":"https:\/\/www.facebook.com\/ml2solutions","article_author":"https:\/\/www.facebook.com\/ml2solutions","article_published_time":"2017-05-31T03:00:00+00:00","article_modified_time":"2021-05-03T00:08:50+00:00","author":"Matt Woicik","twitter_card":"summary_large_image","twitter_creator":"@ml2solutions","twitter_site":"@ml2solutions","twitter_misc":{"Written by":"Matt Woicik"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/#article","isPartOf":{"@id":"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/"},"author":{"name":"Matt Woicik","@id":"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd"},"headline":"Copy Formula in Excel Without Changing the References","datePublished":"2017-05-31T03:00:00+00:00","dateModified":"2021-05-03T00:08:50+00:00","mainEntityOfPage":{"@id":"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/"},"wordCount":87,"publisher":{"@id":"https:\/\/ml2solutions.com\/#organization"},"articleSection":["IT"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/","url":"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/","name":"Copy Formula in Excel Without Changing the References - ML2 Solutions","isPartOf":{"@id":"https:\/\/ml2solutions.com\/#website"},"datePublished":"2017-05-31T03:00:00+00:00","dateModified":"2021-05-03T00:08:50+00:00","description":"Copy Formula in Excel Without Changing the References I had a need to copy a formula in Excel but didn\u2019t want part of the formula to change.&nbsp;&nbsp; I did some research and found out part of the formula","breadcrumb":{"@id":"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ml2solutions.com\/it\/copy-formula-in-excel-without-changing-the-references\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ml2solutions.com\/"},{"@type":"ListItem","position":2,"name":"IT","item":"https:\/\/ml2solutions.com\/category\/it\/"},{"@type":"ListItem","position":3,"name":"Copy Formula in Excel Without Changing the References"}]},{"@type":"WebSite","@id":"https:\/\/ml2solutions.com\/#website","url":"https:\/\/ml2solutions.com\/","name":"ML2 Solutions","description":"Helping you get more leads and make more sales","publisher":{"@id":"https:\/\/ml2solutions.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ml2solutions.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ml2solutions.com\/#organization","name":"ML2 Solutions","url":"https:\/\/ml2solutions.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/","url":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png","contentUrl":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png","width":303,"height":54,"caption":"ML2 Solutions"},"image":{"@id":"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ml2solutions","https:\/\/x.com\/ml2solutions","https:\/\/www.instagram.com\/ml2solutions\/","https:\/\/www.pinterest.com\/ml2solutions\/","https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA"]},{"@type":"Person","@id":"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd","name":"Matt Woicik","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ml2solutions.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g","caption":"Matt Woicik"},"description":"Matt is a digital marketing strategist and the owner of ML2 Solutions, a digital marketing agency. He helps businesses increase awareness and get more leads using digital marketing. New marketing methods are confusing, always changing and difficult to figure out. Matt helps to explain things and provide solutions with clear results.","sameAs":["https:\/\/ml2solutions.com","https:\/\/www.facebook.com\/ml2solutions","https:\/\/www.instagram.com\/ml2solutions\/","https:\/\/www.linkedin.com\/company\/ml2solutions\/","https:\/\/www.pinterest.com\/ml2solutions\/","https:\/\/x.com\/ml2solutions","https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA"]}]}},"_links":{"self":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/posts\/829"}],"collection":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/comments?post=829"}],"version-history":[{"count":0,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/posts\/829\/revisions"}],"wp:attachment":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/media?parent=829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/categories?post=829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/tags?post=829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}