{"id":470,"date":"2026-04-08T04:33:48","date_gmt":"2026-04-07T19:33:48","guid":{"rendered":"https:\/\/tablenote.webdia.net\/?page_id=470"},"modified":"2026-04-08T04:33:48","modified_gmt":"2026-04-07T19:33:48","slug":"auto-adjust-formula-references","status":"publish","type":"page","link":"https:\/\/tablenote.webdia.net\/en\/auto-adjust-formula-references\/","title":{"rendered":"Automatic Adjustment of Formula References When Copying (Relative References)"},"content":{"rendered":"\n<p>This page explains how cell references are automatically adjusted when a formula is copied.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>How It Works<\/strong><\/p>\n\n\n\n<p>When you copy a formula cell to another location, the referenced cells are automatically shifted to match the new position. <br>This behavior is called\u00a0relative referencing.\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"2622\" style=\"aspect-ratio: 1206 \/ 2622;\" width=\"1206\" controls src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-1.mp4\"><\/video><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Example<\/strong><\/p>\n\n\n\n<p>Suppose the original cell contains the following formula:<\/p>\n\n\n\n<p>=\u200bA1\u200b+\u200bB1<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"1024\" src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-2-471x1024.png\" alt=\"\" class=\"wp-image-380\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-2-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-2-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-2-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-2-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-2-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-2-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<p>If you paste this cell\u00a0one row below, the formula changes to:<\/p>\n\n\n\n<p>=\u200bA2\u200b+\u200bB2<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"1024\" src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-3-471x1024.png\" alt=\"\" class=\"wp-image-381\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-3-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-3-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-3-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-3-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-3-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-3-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<p>If you paste it\u00a0one column to the right, the formula changes to:<\/p>\n\n\n\n<p>=\u200bB1\u200b+\u200bC1<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"1024\" src=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-4-471x1024.png\" alt=\"\" class=\"wp-image-382\" style=\"width:300px\" srcset=\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-4-471x1024.png 471w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-4-138x300.png 138w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-4-768x1670.png 768w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-4-706x1536.png 706w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-4-942x2048.png 942w, https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-326-4-scaled.png 1177w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong><strong>Behavior When Copying a Range<\/strong><\/strong><\/p>\n\n\n\n<p>The same rule applies when copying and pasting a range of multiple cells. Formula references are automatically adjusted according to how far each cell is moved.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Notes<\/strong><\/p>\n\n\n\n<p>\u2022 This adjustment is applied only to formulas, meaning cells that begin with\u00a0=.<\/p>\n\n\n\n<p>\u2022 Regular text cells are copied as they are.<\/p>\n\n\n\n<p>\u2022 If the result is not what you intended, you can use\u00a0Undo\u00a0to revert it.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This page explains how cell references are automatically adjusted when a formula is copied. How It Works When you copy a formula cell to another location, the referenced cells are automatically shifted to match the new position. This behavior is called\u00a0relative referencing.\u00a0 Example Suppose the original cell contains the following formula: =\u200bA1\u200b+\u200bB1 If you paste [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_locale":"en_US","_original_post":"https:\/\/tablenote.webdia.net\/?page_id=326","footnotes":""},"class_list":["post-470","page","type-page","status-publish","hentry","en-US"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/comments?post=470"}],"version-history":[{"count":0,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/470\/revisions"}],"wp:attachment":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/media?parent=470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}