{"id":40,"date":"2023-11-18T17:51:00","date_gmt":"2023-11-18T17:51:00","guid":{"rendered":"https:\/\/exceladvisor.org\/ko\/r1c1\/"},"modified":"2023-12-11T07:00:34","modified_gmt":"2023-12-11T07:00:34","slug":"r1c1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/ko\/r1c1\/","title":{"rendered":"Excel\uc5d0\uc11c r1c1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2144802863\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Excel\uc5d0\ub294 \ub450 \uac00\uc9c0 \uc720\ud615\uc758 \uc140 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uccab \ubc88\uc9f8\ub294 A1\uc774\uace0 \ub450 \ubc88\uc9f8\ub294 R1C1\uc785\ub2c8\ub2e4. \uae00\uc384\uc694, \ub300\ubd80\ubd84\uc758 Excel \uc0ac\uc6a9\uc790\ub294 R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc774 \uc874\uc7ac\ud55c\ub2e4\ub294 \uc0ac\uc2e4\uc870\ucc28 \ubaa8\ub985\ub2c8\ub2e4.<\/p><p> \uadf8\ub7ec\ub098 \uc77c\ubd80 \uc0ac\uc6a9\uc790\ub294 \uc774 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc744 \uc88b\uc544\ud558\uace0 A1\ubcf4\ub2e4 \ub354 \ud3b8\ub9ac\ud558\ub2e4\uace0 \uc0dd\uac01\ud569\ub2c8\ub2e4. R1C1 \uc2a4\ud0c0\uc77c\uc740 \uc880 \uc624\ub798\ub41c \uc2a4\ud0c0\uc77c\uc785\ub2c8\ub2e4.<\/p><p> \uc774\ub294 Microsoft\uac00 Apple Macintosh\uc6a9\uc73c\ub85c \uac1c\ubc1c\ud55c <a href=\"https:\/\/en.wikipedia.org\/wiki\/Multiplan#Cell_addressing_differences\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Multiplan\uc5d0\uc11c \ucc98\uc74c \uc18c\uac1c\ub418\uc5c8\uc2b5\ub2c8\ub2e4<\/a> .<\/p><p> \uadf8\ub7ec\ub098 \uba87 \ub144 \ud6c4 Microsoft\ub294 A1 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\uae30 \uc2dc\uc791\ud558\uc5ec Lotus\uc5d0\uc11c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud55c \uc0ac\ub78c\ub4e4\uc5d0\uac8c \uc775\uc219\ud558\ub2e4\uace0 \ub290\uaf08\uc9c0\ub9cc R1C1\uc740 \ud56d\uc0c1 Excel\uc5d0 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<\/p><p> R1C1\uc5d0\ub294 A1\ubcf4\ub2e4 \ucd94\uac00 \uc774\uc810\uc774 \uc801\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc624\ub298 \uc774 \uae30\uc0ac\uc5d0\uc11c\ub294 R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c \uc0ac\uc6a9\uc758 \ubaa8\ub4e0 \uce21\uba74\uc744 \uc5ec\ub7ec\ubd84\uacfc \uacf5\uc720\ud558\uace0 \uc2f6\uc2b5\ub2c8\ub2e4.<\/p><p> \uadf8\ub7ec\ub2c8 \ub354 \uc774\uc0c1 \uace0\ubbfc\ud558\uc9c0 \ub9d0\uace0 \uc774 \ubb38\uc81c\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p><h2 class=\"wp-block-heading\"> \ucc38\uc870 \uc2a4\ud0c0\uc77c A1\uacfc R1C\uc758 \ucc28\uc774\uc810<\/h2><p> \ucc38\uc870 \uc2a4\ud0c0\uc77c A1\uc5d0\ub294 \uc5f4 \uc774\ub984\uc774 \uc54c\ud30c\ubcb3\uc73c\ub85c, \ud589 \uc774\ub984\uc774 \uc22b\uc790\ub85c \ud45c\uc2dc\ub418\uba70 \uc140 A1\uc744 \uc120\ud0dd\ud558\uba74 \uc5f4 A\uc640 \ud589 1\uc5d0 \uc788\uc74c\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.<\/p><p> \ud558\uc9c0\ub9cc R1C1\uc5d0\uc11c\ub294 \uc5f4\uacfc \ud589\uc774 \uc22b\uc790\ub85c \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \ub530\ub77c\uc11c A1 \uc140\uc744 \uc120\ud0dd\ud558\uba74 \ud589 1\uacfc \uc5f4 1\uc744 \uc758\ubbf8\ud558\ub294 R1C1\uc774 \ud45c\uc2dc\ub418\uace0, A2\ub85c \uc774\ub3d9\ud558\uba74 R2C1\uc774 \ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png\" sizes=\"\" srcset=\"\" alt=\"\ucc38\uc870 \uc2a4\ud0c0\uc77c A1\uacfc \ucc38\uc870 \uc2a4\ud0c0\uc77c R1C1\uc758 \ucc28\uc774\uc810\"><\/figure><\/div><p> \uc704\uc758 \ub450 \uc608\uc5d0\uc11c\ub294 \ub3d9\uc77c\ud55c \ud65c\uc131 \uc140\uc774 \uc788\uc9c0\ub9cc \uc140 \uc8fc\uc18c\ub294 \ub2e4\ub985\ub2c8\ub2e4. <strong><span style=\"color: #ea493f;\">\uc2e4\uc81c \ucc28\uc774\uc810\uc740<\/span><\/strong> \uc218\uc2dd\uc744 \uc791\uc131\ud558\uace0 \ub2e4\ub978 \uc140\uc5d0 \ub300\ud55c \ucc38\uc870\ub97c \uc0ac\uc6a9\ud560 \ub54c \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p><p> R1C1\uc5d0\uc11c\ub294 \uc140\uc744 \ucc38\uc870\ud560 \ub54c <strong><span style=\"color: #000000;\">\ud65c\uc131 \uc140\uacfc\uc758 \uac70\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec<\/span><\/strong> \ucc38\uc870\ub41c \uc140\uc758 \uc8fc\uc18c\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p><p> \uc608\ub97c \ub4e4\uc5b4 \uc140 A1\uc5d0\uc11c \uc140 B5\ub97c \ucc38\uc870\ud558\uba74 B5\uc758 \uc8fc\uc18c\ub294 R[4]C[1]\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/referer-b5-a-partir-de-a1-en-utilisant-le-style-de-reference-r1c1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\ucc38\uc870 \uc2a4\ud0c0\uc77c r1c1\uc744 \uc0ac\uc6a9\ud558\uc5ec a1\uc5d0\uc11c b5\ub97c \ucc38\uc870\ud569\ub2c8\ub2e4.\" width=\"312\" height=\"201\"><\/figure><\/div><p> \uc774\uc81c \uc774\ub807\uac8c \uc0dd\uac01\ud574\ubcf4\uc138\uc694. \uc140 B5\ub294 \uc140 A1\ubcf4\ub2e4 \uc544\ub798\ub85c 4\ud589, \uc55e\uc5d0 1\uc5f4\uc774\ubbc0\ub85c \ud574\ub2f9 \uc8fc\uc18c\ub294 R[4]C[1]\uc785\ub2c8\ub2e4.<\/p><p> \ud558\uc9c0\ub9cc \uc5ec\uae30\uc5d0 \ud0a4\ucee4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\ub978 \uc140\uc5d0\uc11c \ub3d9\uc77c\ud55c \uc140\uc744 \ucc38\uc870\ud558\uba74 \ud574\ub2f9 \uc140\uc758 \uc8fc\uc18c\uac00 \ub2ec\ub77c\uc9d1\ub2c8\ub2e4.<\/p><p> <strong>\uc774\ud574\ud574\uc57c \ud560 \uc810\uc740<\/strong> R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc5d0\ub294 \uc140\uc5d0 \ub300\ud55c \uc601\uad6c \uc8fc\uc18c\uac00 \uc5c6\uc73c\ubbc0\ub85c(\uc0c1\ub300 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0) \uc140 \uc8fc\uc18c\ub294 \ucc38\uc870 \uc704\uce58\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4.<\/p><p> R1C1 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc740 \uc140 \ucc38\uc870 \uc791\uc5c5\uc5d0 \ub300\ud55c \ud604\uc2e4\uc801\uc778 \uc811\uadfc \ubc29\uc2dd\uc785\ub2c8\ub2e4.<\/p><p> \uc774 \uae30\uc0ac\uc5d0 \uc55e\uc11c \uc774 \uc811\uadfc \ubc29\uc2dd\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uba3c\uc800 \ud65c\uc131\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubd05\uc2dc\ub2e4.<\/p><h2 class=\"wp-block-heading\"> Excel\uc5d0\uc11c R1C1 \uc140 \ucc38\uc870\ub97c \ud65c\uc131\ud654\ud558\ub294 \ubc29\ubc95 \u2013 \uac04\ub2e8\ud55c \ub2e8\uacc4<\/h2><p> R1C1\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 \uac00\uc7a5 \uba3c\uc800 \ud65c\uc131\ud654\ud574\uc57c \ud558\uba70 \uc774\ub97c \uc704\ud574 \uc544\ub798 \ubc29\ubc95 \uc911 \ud558\ub098\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> Excel \uc635\uc158\uc5d0\uc11c<\/h3><p> R1C1 \ucc38\uc870\ub97c \uae30\ubcf8\uac12\uc73c\ub85c \uc124\uc815\ud558\ub824\uba74 \ub2e4\uc74c\uc758 \uac04\ub2e8\ud55c \ub2e8\uacc4\ub97c \ub530\ub974\uc2ed\uc2dc\uc624.<\/p><ol><li> \ud30c\uc77c \ud0ed \u279c \uc635\uc158 \u279c \uc218\uc2dd \u279c \uc218\uc2dd \uc791\uc5c5\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/li><li> \u201c\ucc38\uc870 \uc2a4\ud0c0\uc77c R1C1\u201d\uc744 \ud655\uc778\ud558\uc138\uc694.<\/li><li> \ud655\uc778\uc744 \ud074\ub9ad\ud558\uc138\uc694. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/activer-le-style-de-reference-r1c1-a-partir-des-options-dans-Excel.png\" sizes=\"\" srcset=\"\" alt=\"Excel\uc758 \uc635\uc158\uc5d0\uc11c r1c1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \ud65c\uc131\ud654\ud569\ub2c8\ub2e4.\"><\/figure><\/div><h3 class=\"wp-block-heading\"> VBA \ucf54\ub4dc \uc0ac\uc6a9<\/h3><p> \ub9e4\ud06c\ub85c\uc5d0 \uc775\uc219\ud558\uace0 \uc2dc\uac04\uc744 \uc808\uc57d\ud558\uace0 \uc2f6\ub2e4\uba74 \uc544\ub798 \ub9e4\ud06c\ub85c \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc140 \ucc38\uc870 \uc2a4\ud0c0\uc77c \uac04\uc5d0 \uc804\ud658\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub ChangeCellRef() If Application.ReferenceStyle = xlA1 Then Application.ReferenceStyle = xlR1C1 Else Application.ReferenceStyle = xlA1 End If End Sub<\/code><\/pre><p> R1C1\uc744 \uae30\ubcf8 \ucc38\uc870 \uc2a4\ud0c0\uc77c\ub85c \uc9c0\uc815\ud558\uba74 \ubaa8\ub4e0 \ud1b5\ud569 \ubb38\uc11c \uc218\uc2dd\uc758 \ubaa8\ub4e0 \ucc38\uc870\uac00 \ubcc0\uacbd\ub429\ub2c8\ub2e4.<\/p><h2 class=\"wp-block-heading\"> R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc758 \uc791\ub3d9 \ubc29\uc2dd<\/h2><p> \uc774\uc81c \uc774 \uc2dc\uc810\uc5d0\uc11c R1C1\uc758 \ud55c \uac00\uc9c0 \uc0ac\ud56d\uc5d0 \ub300\ud574 \uba85\ud655\ud574\uc84c\uc2b5\ub2c8\ub2e4. \ud589 \ubc88\ud638\uc640 \uc5f4 \ubc88\ud638\uac00 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/nombres-pour-la-colonne-et-la-ligne-dans-le-style-r1c1.png\" sizes=\"\" srcset=\"\" alt=\"r1c1 \uc2a4\ud0c0\uc77c\uc758 \uc5f4 \ubc0f \ud589 \ubc88\ud638\"><\/figure><\/div><p> \ud558\uc9c0\ub9cc \uadf8\uac83\uc774 \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub294\uc9c0 \uc774\ud574\ud558\ub824\uba74 \ub2e4\uc591\ud55c \uc720\ud615\uc758 \ucc38\uace0 \ubb38\ud5cc\uc744 \ubaa8\ub450 \ubc30\uc6cc\uc57c \ud569\ub2c8\ub2e4. <\/p><figure class=\"wp-block-table is-style-stripes\"><table class=\"mtr-table mtr-thead-th\"><thead><tr><th class=\"mtr-th-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\"> \ucc38\uc870 \uc2a4\ud0c0\uc77c A1 <\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> \ucc38\uc870 \uc2a4\ud0c0\uc77c R1C1<\/div><\/th><th class=\"mtr-th-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> \ucc38\uc870 \uc720\ud615 <\/div><\/th><\/tr><\/thead><tbody><tr><td class=\"mtr-td-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\"> A1 <\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> R[-4]C[-1]<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> \uc0c1\ub300 \ucc38\uc870 <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\">$A$1 <\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> R1C1<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> \uc808\ub300 \ucc38\uc870 <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\">$A1 <\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> R[-4]C1<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> \uc0c1\ub300 \ud589\uacfc \uc808\ub300 \uc5f4 <\/div><\/td><\/tr><tr><td class=\"mtr-td-tag\" data-mtr-content=\"A1 Reference Style\"><div class=\"mtr-cell-content\">1 AUD <\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"R1C1 Reference Style\"><div class=\"mtr-cell-content\"> R1C[-1]<\/div><\/td><td class=\"mtr-td-tag\" data-mtr-content=\"Reference Type\"><div class=\"mtr-cell-content\"> \uc808\ub300 \ud589\uacfc \uc0c1\ub300 \uc5f4<\/div><\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\"> <em>\ub2e4\uc591\ud55c \uc720\ud615\uc758 \ucc38\uc870<\/em><\/figcaption><\/figure><p> A1\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c R1C1\uc5d0\uc11c\ub3c4 \uc704 \ud45c\uc5d0 \ud45c\uc2dc\ub41c \ub300\ub85c \ub124 \uac00\uc9c0 \ucc38\uc870 \uc720\ud615\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774\uc81c \uac01 \ucc38\uc870 \uc720\ud615\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> 1. \uc0c1\ub300 R1C1 \ucc38\uc870<\/h3><p> R1C1\uc5d0\uc11c \uc0c1\ub300 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uac04\ub2e8\ud569\ub2c8\ub2e4. \uc774 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc5d0\uc11c\ub294 \uc140\uc744 \ucc38\uc870\ud560 \ub54c \ud65c\uc131 \uc140\uacfc\uc758 \uac70\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucc38\uc870\ub41c \uc140\uc758 \uc8fc\uc18c\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-une-reference-relative-dans-le-style-r1c1.png\" sizes=\"\" srcset=\"\" alt=\"r1c1 \uc2a4\ud0c0\uc77c\uc758 \uc0c1\ub300 \ucc38\uc870 \uc0ac\uc6a9\"><\/figure><\/div><p> \ud65c\uc131 \uc140\uc758 \uc624\ub978\ucabd \uc5f4\ub85c \uc774\ub3d9\ud558\ub824\ub294 \uacbd\uc6b0 \uc22b\uc790\ub294 \uc591\uc218\uc774\uace0, \uc67c\ucabd \uc5f4\uc778 \uacbd\uc6b0 \uc74c\uc218\uc785\ub2c8\ub2e4. \ub77c\uc778\uc5d0 \ub300\ud574\uc11c\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\uc785\ub2c8\ub2e4. \uc544\ub798\ucabd\uc5d0\ub294 \uc591\uc218, \uc704\ucabd\uc5d0\ub294 \ud65c\uc131 \ub77c\uc778\uc5d0 \uc74c\uc218\uc785\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-exemple-pour-le-style-de-reference-r1c1-relatif.gif\" sizes=\"\" srcset=\"\" alt=\"\uc0c1\ub300 r1c1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc758 \uc608\"><\/figure><\/div><p> \uc704\uc758 \uc608\uc5d0\uc11c\ub294 \uc0c1\ub300 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc140\ubcf4\ub2e4 1\uc5f4 \uc55e\uc5d0 \uc788\ub294 \uc140\uacfc 2\uc5f4 \uc55e\uc5d0 \uc788\ub294 \uc140\uc744 \uacf1\ud588\uc2b5\ub2c8\ub2e4.<\/p><p> \uc774 \uc218\uc2dd\uc744 \ubcf5\uc0ac\ud558\uc5ec \uc6cc\ud06c\uc2dc\ud2b8\uc758 \ub2e4\ub978 \uc140\uc5d0 \ubd99\uc5ec \ub123\uc73c\uba74 \ud56d\uc0c1 \ud65c\uc131 \uc140 \uc55e\uc758 1\uc5f4 \uc140\uacfc 2\uc5f4 \uc55e\uc758 \uc140\uc774 \uacf1\ud574\uc9d1\ub2c8\ub2e4.<\/p><h3 class=\"wp-block-heading\"> 2. \uc808\ub300 \uae30\uc900 R1C1<\/h3><p> \uc704\uc758 \uc608\uc5d0\uc11c <strong>\ud589\uacfc \uc5f4 \ubc88\ud638\uc5d0 \ub300\uad04\ud638\uac00 \uc788\ub2e4\ub294<\/strong> \uc0ac\uc2e4\uc744 \ub208\uce58\ucc58\uc744 \uac83\uc785\ub2c8\ub2e4. \uc140 \ucc38\uc870\uc5d0 \ub300\uad04\ud638\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba74 \uc5b4\ub5a4 \uc77c\uc774 \ubc1c\uc0dd\ud558\ub294\uc9c0 \ubcf4\uc5ec \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-exemple-simple-pour-comprendre-la-reference-absolue-dans-r1c1.png\" sizes=\"\" srcset=\"\" alt=\"r1c1\uc758 \uc808\ub300 \ucc38\uc870\ub97c \uc774\ud574\ud558\ub294 \uac04\ub2e8\ud55c \uc608\"><\/figure><\/div><p> \uc704\uc758 \uc608\uc5d0\uc11c \uad04\ud638 \uc5c6\uc774 \ud589 2\uc640 \uc5f4 1\uc744 \uc0ac\uc6a9\ud558\uba74 <strong><span style=\"color: #ea493f;\">\ucc38\uc870\ud558\ub294 \uc140\uc774 \uc815\ud655\ud788 \ud589 2\uc640 \uc5f4 1\uc5d0 \uc704\uce58\ud55c\ub2e4\ub294<\/span><\/strong> \uc758\ubbf8\uc785\ub2c8\ub2e4.<\/p><p> \uc2e4\uc81c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. R1C1\uc5d0\uc11c \uc808\ub300 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\ub824\ub294 \uacbd\uc6b0 \ub300\uad04\ud638 \uc0ac\uc6a9\uc744 \ubb34\uc2dc\ud558\uba74 Excel\uc5d0\uc11c \uc140 R1C1(\uc140 A1)\uc744 \uc2dc\uc791\uc810\uc73c\ub85c \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/p><p> \uc608\ub97c \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-exemple-de-style-de-reference-r1c1-relatif-dans-Excel.gif\" sizes=\"\" srcset=\"\" alt=\"Excel\uc758 \uc0c1\ub300 r1c1 \ucc38\uc870 \uc2a4\ud0c0\uc77c \uc608\"><\/figure><\/div><p> \uc704\uc758 \uc608\uc5d0\uc11c\ub294 R1C1\uc758 2\ubc88\uc9f8 \ud589\uacfc 3\ubc88\uc9f8 \uc5f4\uc5d0 \uc788\ub294 \uc140 R2C3(\uc140 A1)\uacfc \ud65c\uc131 \uc140\ubcf4\ub2e4 1\uc5f4 \uc55e\uc5d0 \uc704\uce58\ud55c \uc140\uc744 \uacf1\ud588\uc2b5\ub2c8\ub2e4.<\/p><p> R2C3\uc5d0\ub294 \ub300\uad04\ud638\uac00 \uc5c6\uc73c\uba70 \uc218\uc2dd\uc744 \ub4dc\ub798\uadf8\ud574\ub3c4 <strong><span style=\"color: #ea493f;\">\uc140 \ucc38\uc870\uac00 \ubcc0\uacbd\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4<\/span><\/strong> .<\/p><h3 class=\"wp-block-heading\"> 3. R1C1 \ubc18\uc808\ub300\/\uc0c1\ub300<\/h3><p> \uc774\ub294 \uc808\ub300 \ub610\ub294 \uc0c1\ub300 \ub2e8\uc77c \uc5f4\uc774\ub098 \ud589\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\ub294 \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ub418\ub294 \ucc38\uc870 \uc2a4\ud0c0\uc77c \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc608\ub97c \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-une-reference-semi-absolue-et-relative-avec-r1c1.gif\" sizes=\"\" srcset=\"\" alt=\"r1c1\uacfc \ud568\uaed8 \ubc18\uc808\ub300 \ubc0f \uc0c1\ub300 \ucc38\uc870 \uc0ac\uc6a9\"><\/figure><\/div><p> \uc704\uc758 \uc608\uc5d0\uc11c\ub294 \uccab \ubc88\uc9f8 \ud589\uc758 \uac12\uc5d0 \uccab \ubc88\uc9f8 \uc5f4\uc758 \uac12\uc744 \uacf1\ud569\ub2c8\ub2e4.<\/p><ul><li> <strong>RC1:<\/strong> \ud589 \ubc88\ud638 \uc9c0\uc815\uc744 \ubb34\uc2dc\ud558\uba74 Excel\uc5d0\uc11c\ub294 \ud65c\uc131 \uc140\uc758 \ud589\uc744 \ucc38\uc870\ub85c \ucc98\ub9ac\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc5ec\uae30\uc11c \uc5f4\uc740 \ub3d9\uc77c\ud558\uac8c \uc720\uc9c0\ub418\uc9c0\ub9cc \uc218\uc2dd\uc744 \ubaa8\ub4e0 \uc140\ub85c \ub4dc\ub798\uadf8\ud558\uba74 \ud589\uc774 \ubcc0\uacbd\ub429\ub2c8\ub2e4.<\/li><li> <strong>A1C:<\/strong> \uc5f4 \ubc88\ud638 \uc9c0\uc815\uc744 \ubb34\uc2dc\ud558\uba74 Excel\uc5d0\uc11c\ub294 \ud65c\uc131 \uc140\uc758 \uc5f4\uc744 \ucc38\uc870\ub85c \ucc98\ub9ac\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc5ec\uae30\uc11c \ud589\uc740 \ub3d9\uc77c\ud558\uac8c \uc720\uc9c0\ub418\uc9c0\ub9cc \uc218\uc2dd\uc744 \ubaa8\ub4e0 \uc140\ub85c \ub4dc\ub798\uadf8\ud558\uba74 \uc5f4\uc774 \ubcc0\uacbd\ub429\ub2c8\ub2e4.<\/li><\/ul><h2 class=\"wp-block-heading\"> \uc218\uc2dd\uc5d0\uc11c R1C1 \ucc38\uc870 \uc0ac\uc6a9<\/h2><p> \uc2a4\ud0c0\uc77c A1\uc5d0\uc11c \uc2a4\ud0c0\uc77c R1C1\ub85c \uc804\ud658\ud558\uba74 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc758 \ubaa8\ub4e0 \uc218\uc2dd\uc774 \ubcc0\uacbd\ub41c \uac83\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \ucc98\uc74c\uc73c\ub85c \ud63c\ub780\uc2a4\ub7ec\uc6cc \ubcf4\uc77c \uc218\ub3c4 \uc788\uc9c0\ub9cc \uc2e4\uc81c\ub85c\ub294 \ub9e4\uc6b0 \uac04\ub2e8\ud569\ub2c8\ub2e4. \uac04\ub2e8\ud55c \ud569\uacc4 \uacf5\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc774\uac83\uc774 \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub294\uc9c0 \ubcf4\uc5ec \ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p><p> \uc544\ub798 \uc608\uc5d0\ub294 \ub05d\uc5d0 \ucd1d\uacc4 \uc5f4\uc774 \uc788\uace0 10\uac1c \uc81c\ud488\uc758 \uc6d4\uac04 \ud310\ub9e4\ub7c9\uc774 \uc788\ub294 \ub370\uc774\ud130 \ud14c\uc774\ube14\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-table-de-donnees-avec-le-style-a1.png\" sizes=\"\" srcset=\"\" alt=\"\uc2a4\ud0c0\uc77c\uc774 a1\uc778 \ub370\uc774\ud130 \ud14c\uc774\ube14\"><\/figure><\/div><p> \uc5ec\uae30\uc11c\ub294 A1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p><p> \uc774 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc5d0\uc11c \uac01 \ud569\uacc4 \uc140\uc5d0\ub294 \uc11c\ub85c \ub2e4\ub978 \uc140 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\ub294 \uc11c\ub85c \ub2e4\ub978 \uc218\uc2dd\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \uadf8\ub7ec\ub098 \ucc38\uc870\ub97c A1\uc5d0\uc11c R1C1\ub85c \ubcc0\uacbd\ud558\uc790\ub9c8\uc790 \ubaa8\ub4e0 \uc218\uc2dd\uc774 \ubcc0\uacbd\ub418\uc5c8\uc73c\uba70 \uac01 \uc804\uccb4 \uc140\uc5d0\uc11c \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/p><p> 10\uac1c\uc758 \uc140 \ubaa8\ub450\uc5d0 \uc544\ub798 \uacf5\uc2dd\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUM(RC[-12]:RC[-1])<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-table-de-donnees-avec-le-style-r1c1.png\" sizes=\"\" srcset=\"\" alt=\"r1c1 \uc2a4\ud0c0\uc77c\uc758 \ub370\uc774\ud130 \ud14c\uc774\ube14\"><\/figure><\/div><p> <strong>\uc774 \uacf5\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \ub9d0\ud569\ub2c8\ub2e4. \u201c\uac19\uc740 \ud589\uc5d0\uc11c \uc67c\ucabd\uc73c\ub85c 12\uac1c \uc5f4(C[-12]) \uc140\uc5d0\uc11c \uc67c\ucabd\uc73c\ub85c \ud55c \uc5f4(C[-1])\uc5d0 \uc788\ub294 \uc140\uae4c\uc9c0\uc758 \uac12 \ubc94\uc704\ub97c \ud569\uc0b0\ud569\ub2c8\ub2e4. \uac19\uc740 \ud589. \uc120 .<\/strong> \u201c<\/p><p> \ud569\uacc4\ub97c \uacc4\uc0b0\ud558\ub294 \ubaa8\ub4e0 \uc140\uc5d0\uc11c \uac12\uc758 \ubc94\uc704\uac00 \ub3d9\uc77c\ud55c \uc21c\uc11c\ub85c \ub418\uc5b4 \uc788\uae30 \ub54c\ubb38\uc5d0 \ubaa8\ub4e0 \uc140\uc5d0 \ub300\ud574 \ub3d9\uc77c\ud55c \uc218\uc2dd\uc774 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p><p> <em><strong><a href=\"http:\/\/amzn.to\/2wEgOEe\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\ucd08\ubcf4\uc790\ub97c \uc704\ud55c Excel 2016 \uc62c\uc778\uc6d0<\/a> \ud301<\/strong> : R1C1 \ud45c\uae30\ubc95\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubaa8\ub4e0 \uc218\uc2dd\uc744 \uc6cc\ud06c\uc2dc\ud2b8 \ud14c\uc774\ube14\uc5d0 \uc62c\ubc14\ub974\uac8c \ubcf5\uc0ac\ud588\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\uc5d0 \ubcf5\uc0ac\ub41c \uc218\uc2dd\uc774 \ud3ec\ud568\ub41c \ubaa8\ub4e0 \uc140\uc744 \ud1b5\ud574 \uc140 \ucee4\uc11c\ub97c \uc774\ub3d9\ud569\ub2c8\ub2e4. R1C1 \ud45c\uae30\ubc95\uc774 \uc801\uc6a9\ub418\ub294 \uacbd\uc6b0 \ud14c\uc774\ube14\uc758 \uc804\uccb4 \ud589 \ub610\ub294 \uc804\uccb4 \uc5f4\uc5d0 \uc788\ub294 \uc6d0\ub798 \uc218\uc2dd\uc758 \ubaa8\ub4e0 \ubcf5\uc0ac\ubcf8\uc740 \ud574\ub2f9 \uc140\uc744 \ud65c\uc131\ud654\ud560 \ub54c \uc218\uc2dd \uc785\ub825\uc904 \uc5d0 \ud45c\uc2dc\ub420 \ub54c \ub3d9\uc77c\ud574\uc57c \ud569\ub2c8\ub2e4.<\/em><\/p><h2 class=\"wp-block-heading\"> VBA\uc5d0\uc11c R1C1 \ucc38\uc870 \uc0ac\uc6a9<\/h2><p> \ub9e4\ud06c\ub85c\ub97c \uae30\ub85d\ud574 \ubcf4\uba74 \uc5d1\uc140\uc774 \uc140\uacfc \ubc94\uc704\ub97c \ucc38\uc870\ud558\uba74\uc11c R1C1 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc744 \ubcfc \uc218 \uc788\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/en-utilisant-la-reference-r1c1-dans-vba.gif\" sizes=\"\" srcset=\"\" alt=\"vba\uc5d0\uc11c r1c1 \ucc38\uc870 \uc0ac\uc6a9\"><\/figure><\/div><p> \uadf8\ub9ac\uace0 R1C1 \uac1c\ub150\uc744 \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uba74 \uae30\ub85d\ub41c \ub9e4\ud06c\ub85c \ucf54\ub4dc\ub97c \uc27d\uac8c \ud3b8\uc9d1\ud558\uace0 \ub9ce\uc740 \uc2dc\uac04\uc744 \uc808\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\ub824\uba74 FormulaR1C1 \uba54\uc11c\ub4dc\uac00 \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub294\uc9c0 \uc774\ud574\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p><p> \ud65c\uc131 \uc140 \uc67c\ucabd\uc5d0 \uc788\ub294 \ub450 \uac1c\uc758 \uc140\uc744 \uacf1\ud574\uc57c \ud558\ub294 \uc218\uc2dd\uc744 \ud65c\uc131 \uc140\uc5d0 \uc785\ub825\ud55c\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub R1C1Style() Selection.FormulaR1C1 = \"=RC[-2]*RC[-1]\" End Sub<\/code><\/pre><p> \uc67c\ucabd\uc73c\ub85c \ud55c \uc5f4 \ub5a8\uc5b4\uc9c4 \uc140\uc5d0 \ud65c\uc131 \uc140 \uc67c\ucabd\uc73c\ub85c \ub450 \uc5f4 \ub5a8\uc5b4\uc9c4 \uc140\uc744 \uacf1\ud569\ub2c8\ub2e4. \uc774\uc81c \uc774\uac83\uc758 \uac00\uc7a5 \uc88b\uc740 \ubd80\ubd84\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p><p> \ud14c\uc774\ube14 \uc704\uce58\ub97c \ubcc0\uacbd\ud558\uba74 \ub3d9\uc77c\ud55c \uc2a4\ud0a4\ub9c8\uc5d0\uc11c \uc791\ub3d9\ud558\ubbc0\ub85c \ucf54\ub4dc\ub97c \ubcc0\uacbd\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc5ec\uae30\uc11c R1C1 \ub300\uc2e0 A1 \ucc38\uc870\ub97c \uc0ac\uc6a9\ud558\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694?<\/p><p> \uc140 \ucc38\uc870\uac00 \uace0\uc815\ub418\ubbc0\ub85c \uac01 \uc140\uc5d0 \ub300\ud574 \uc774 \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4( <strong>\uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 Offset \uc18d\uc131\uc744 \uc0ac\uc6a9\ud574\uc57c \ud568<\/strong> ). <a href=\"https:\/\/powerspreadsheets.com\/r1c1-formular1c1-vba\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Jorge\uc758 \uac00\uc774\ub4dc<\/a> \uc5d0\uc11c Formula.R1C1 \uba54\uc18c\ub4dc\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc815\ubcf4\ub97c \uc5bb\uc73c\uc2ed\uc2dc\uc624.<\/p><h2 class=\"wp-block-heading\"> \uacb0\ub860<\/h2><p> R1C1\uc744 \uc774\ud574\ud558\uba74 \uc57d\uac04\uc758 \ub450\ub824\uc6c0\uc744 \ub290\ub07c\uaca0\uc9c0\ub9cc \uc77c\ub2e8 \uc774\ub97c \uadf9\ubcf5\ud558\uace0 \ub098\uba74 Excel \uc791\uc5c5\uc5d0 \ub300\ud55c \uc0c8\ub86d\uace0 \uc720\uc5f0\ud55c \uc811\uadfc \ubc29\uc2dd\uc744 \uac16\uac8c \ub420 \uac83\uc785\ub2c8\ub2e4.<\/p><p> \uc81c\uac00 \uc78a\uc5b4\ubc84\ub9b0 \ud55c \uac00\uc9c0 \uc0ac\uc2e4\uc740 F4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc0c1\ub300, \uc808\ub300 \ubc0f \ubc18\uc0c1\ub300 \uc140 \ucc38\uc870 \uc0ac\uc774\ub97c \uc804\ud658\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774 \ud29c\ud1a0\ub9ac\uc5bc\uc5d0\uc11c \uc5fc\ub450\uc5d0 \ub450\uc5b4\uc57c \ud560 \uba87 \uac00\uc9c0 \uc0ac\ud56d\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p><ol><li> R1C1\uc5d0\uc11c R\uc740 \ud589\uc744 \ub098\ud0c0\ub0b4\uace0 C\ub294 \uc5f4\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4 .<\/li><li> \ud65c\uc131 \uc140 \uc544\ub798\uc758 \ud589\uacfc \uc55e\uc758 \uc5f4\uc744 \ucc38\uc870\ud558\ub824\uba74 \uc591\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/li><li> \ud65c\uc131 \uc140 \uc704\uc758 \ud589\uacfc \ub4a4\uc758 \uc5f4\uc744 \ucc38\uc870\ud558\ub824\uba74 \uc74c\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/li><li> \ub300\uad04\ud638 \uc5c6\uc774 \ud589 \ub610\ub294 \uc5f4 \ubc88\ud638\ub97c \uc0ac\uc6a9\ud558\uba74 Excel\uc5d0\uc11c\ub294 \uc774\ub97c \uc808\ub300 \ucc38\uc870\ub85c \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/li><li> VBA\uc5d0\uc11c\ub294 R1C1\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 FormulaR1C1 \uba54\uc11c\ub4dc\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li><\/ol><p> \uc774 \uae30\uc0ac\uac00 \ub3c4\uc6c0\uc774 \ub418\uc5c8\uae30\ub97c \ubc14\ub77c\uba70 \uc774\uc81c \ud55c \uac00\uc9c0\ub9cc \ub9d0\uc500\ud574 \uc8fc\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p><p> <em>R1C1\uc744 \uc0ac\uc6a9\ud558\uc2dc\uaca0\uc2b5\ub2c8\uae4c?<\/em><\/p><p> \ub313\uae00 \uc139\uc158\uc5d0\uc11c \uc5ec\ub7ec\ubd84\uc758 \uc0dd\uac01\uc744 \uc800\uc640 \uacf5\uc720\ud574 \uc8fc\uc138\uc694. \uc5ec\ub7ec\ubd84\uc758 \uc758\uacac\uc744 \ub4e3\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc774 \uac8c\uc2dc\ubb3c\uc744 \uce5c\uad6c\ub4e4\uacfc \uacf5\uc720\ud558\ub294 \uac83\uc744 \uc78a\uc9c0 \ub9c8\uc138\uc694. \uce5c\uad6c\ub4e4\uc774 \uc774 \uac8c\uc2dc\ubb3c\uc744 \uc88b\uc544\ud560 \uac83\uc774\ub77c\uace0 \ud655\uc2e0\ud569\ub2c8\ub2e4.<\/p><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> Excel \uc218\uc2dd \ubaa9\ub85d<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \uad00\ub828 \uc218\uc2dd <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> Excel\uc758 3D \ucc38\uc870<\/li><li> Excel\uc758 \uc640\uc77c\ub4dc\uce74\ub4dc<\/li><li> Excel\uc5d0\uc11c \uc218\uc2dd \uc228\uae30\uae30 <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-40","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Excel\uc5d0\uc11c R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/title>\n<meta name=\"description\" content=\"R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc740 Microsoft\uac00 Apple Macintosh\uc6a9\uc73c\ub85c \uac1c\ubc1c\ud55c Multiplan\uc5d0\uc11c \ucc98\uc74c \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/ko\/r1c1\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel\uc5d0\uc11c R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?\" \/>\n<meta property=\"og:description\" content=\"R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc740 Microsoft\uac00 Apple Macintosh\uc6a9\uc73c\ub85c \uac1c\ubc1c\ud55c Multiplan\uc5d0\uc11c \ucc98\uc74c \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/ko\/r1c1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-11T07:00:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/r1c1\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/r1c1\/\",\"name\":\"\u25b7 Excel\uc5d0\uc11c R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/r1c1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/r1c1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png\",\"datePublished\":\"2023-11-18T17:51:00+00:00\",\"dateModified\":\"2023-12-11T07:00:34+00:00\",\"description\":\"R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc740 Microsoft\uac00 Apple Macintosh\uc6a9\uc73c\ub85c \uac1c\ubc1c\ud55c Multiplan\uc5d0\uc11c \ucc98\uc74c \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/r1c1\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/ko\/r1c1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/r1c1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/r1c1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\uc9d1\",\"item\":\"https:\/\/exceladvisor.org\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\uc5d0\uc11c r1c1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"name\":\"Excel Advisor\",\"description\":\"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Excel\uc5d0\uc11c R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?","description":"R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc740 Microsoft\uac00 Apple Macintosh\uc6a9\uc73c\ub85c \uac1c\ubc1c\ud55c Multiplan\uc5d0\uc11c \ucc98\uc74c \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4.","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:\/\/exceladvisor.org\/ko\/r1c1\/","og_locale":"ko_KR","og_type":"article","og_title":"\u25b7 Excel\uc5d0\uc11c R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?","og_description":"R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc740 Microsoft\uac00 Apple Macintosh\uc6a9\uc73c\ub85c \uac1c\ubc1c\ud55c Multiplan\uc5d0\uc11c \ucc98\uc74c \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4.","og_url":"https:\/\/exceladvisor.org\/ko\/r1c1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-11T07:00:34+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/ko\/r1c1\/","url":"https:\/\/exceladvisor.org\/ko\/r1c1\/","name":"\u25b7 Excel\uc5d0\uc11c R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/ko\/r1c1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/r1c1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png","datePublished":"2023-11-18T17:51:00+00:00","dateModified":"2023-12-11T07:00:34+00:00","description":"R1C1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc740 Microsoft\uac00 Apple Macintosh\uc6a9\uc73c\ub85c \uac1c\ubc1c\ud55c Multiplan\uc5d0\uc11c \ucc98\uc74c \ub3c4\uc785\ub418\uc5c8\uc2b5\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/ko\/r1c1\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/ko\/r1c1\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/r1c1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Utiliser-le-style-de-reference-R1C1-dans-Excel-2-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/ko\/r1c1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\uc9d1","item":"https:\/\/exceladvisor.org\/ko\/"},{"@type":"ListItem","position":2,"name":"Excel\uc5d0\uc11c r1c1 \ucc38\uc870 \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/ko\/#website","url":"https:\/\/exceladvisor.org\/ko\/","name":"Excel Advisor","description":"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!","publisher":{"@id":"https:\/\/exceladvisor.org\/ko\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/ko\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/ko\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/40","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/comments?post=40"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/40\/revisions"}],"predecessor-version":[{"id":851,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/40\/revisions\/851"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/media?parent=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}