{"id":11109,"date":"2026-02-11T21:56:36","date_gmt":"2026-02-11T21:56:36","guid":{"rendered":"https:\/\/howtogeek.blog\/ko\/?p=11109"},"modified":"2026-02-11T21:56:36","modified_gmt":"2026-02-11T21:56:36","slug":"%ec%97%91%ec%85%80%ec%97%90%ec%84%9c-%ec%9d%91%eb%8b%b5%ed%95%98%ec%a7%80-%ec%95%8a%eb%8a%94-%eb%93%9c%eb%a1%ad%eb%8b%a4%ec%9a%b4-%eb%aa%a9%eb%a1%9d%ec%9d%84-%ec%88%98%ec%a0%95%ed%95%98%eb%8a%94","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/ko\/%ec%97%91%ec%85%80%ec%97%90%ec%84%9c-%ec%9d%91%eb%8b%b5%ed%95%98%ec%a7%80-%ec%95%8a%eb%8a%94-%eb%93%9c%eb%a1%ad%eb%8b%a4%ec%9a%b4-%eb%aa%a9%eb%a1%9d%ec%9d%84-%ec%88%98%ec%a0%95%ed%95%98%eb%8a%94\/","title":{"rendered":"\uc5d1\uc140\uc5d0\uc11c \uc751\ub2f5\ud558\uc9c0 \uc54a\ub294 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc744 \uc218\uc815\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"<p>\uc5d1\uc140 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc5d0 \ubb38\uc81c\uac00 \uc788\uc73c\uc2e0\uac00\uc694? \ub370\uc774\ud130 \uc785\ub825\uc774\ub098 \ubd84\uc11d \uc791\uc5c5\uc744 \ud55c\ucc3d \uc9c4\ud589 \uc911\uc77c \ub54c \uac11\uc790\uae30 \uc791\ub3d9\uc774 \uba48\ucd94\uba74 \uc815\ub9d0 \uc9dc\uc99d \ub098\uc8e0.\uc124\uc815 \uc624\ub958\uc77c \uc218\ub3c4 \uc788\uace0, \ud30c\uc77c\uc774 \uc57d\uac04 \uc190\uc0c1\ub418\uc5c8\uc744 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.\ud558\uc9c0\ub9cc \ucf54\ub4dc\ub97c \uae4a\uc774 \ud30c\uace0\ub4e4\uc9c0 \uc54a\uace0\ub3c4 \uac04\ub2e8\ud558\uac8c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\ub4e4\uc774 \uc788\uc2b5\ub2c8\ub2e4.\ubb3c\ub860 \uc774\ub7f0 \uc0ac\uc18c\ud55c \ubb38\uc81c \ub54c\ubb38\uc5d0 \uc791\uc5c5 \ud750\ub984\uc774 \ub04a\uae30\uba74 \ub2f5\ub2f5\ud558\uaca0\uc9c0\ub9cc, \ub2e4\ud589\ud788 \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 \ud574\uacb0\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c \ub2e8\uacc4\ub97c \ub530\ub974\uba74 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \ub2e4\uc2dc \uc791\ub3d9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uc228\uaca8\uc9c4 \uac1c\uccb4, \uc190\uc0c1\ub41c \ud30c\uc77c, \uc798\ubabb\ub41c \ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac \uc124\uc815 \ub610\ub294 \uc798\ubabb\ub41c \uc18c\uc2a4 \ucc38\uc870\uc640 \uac19\uc740 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778\uc744 \ub2e4\ub8f9\ub2c8\ub2e4.\uc6d0\uc778\uc740 \ub2e4\uc591\ud558\uc9c0\ub9cc, \ubb38\uc81c\uac00 \ud574\uacb0\ub418\uba74 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \ud45c\uc2dc\ub420 \uac83\uc785\ub2c8\ub2e4.\uc5d1\uc140\uc740 \ub54c\ub54c\ub85c \uc608\uce21\ud560 \uc218 \uc5c6\ub294 \uacbd\uc6b0\uac00 \uc788\uc73c\ubbc0\ub85c, \uc774 \ud574\uacb0 \ubc29\ubc95 \uc911 \ud558\ub098\uac00 \ud6a8\uacfc\uac00 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.\uba87 \uac00\uc9c0 \ubc29\ubc95\uc744 \uc2dc\ub3c4\ud574 \ubd10\uc57c \ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2>\uc5d1\uc140 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc774 \uc791\ub3d9\ud558\uc9c0 \uc54a\uc744 \ub54c \ud574\uacb0 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc778\uac00\uc694?<\/h2>\n<h3>\uc5d1\uc140\uc5d0\uc11c \uc228\uaca8\uc9c4 \uac1c\uccb4 \ucc3e\uae30<\/h3>\n<p>\ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc774 \uc0ac\ub77c\uc9c0\ub294 \uacbd\uc6b0 \uc6cc\ud06c\uc2dc\ud2b8\uc5d0\uc11c \uac1c\uccb4\uac00 \uc228\uaca8\uc838 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\ubbff\uae30 \uc5b4\ub835\uaca0\uc9c0\ub9cc, Excel\uc5d0\uc11c \uac1c\uccb4 \ud45c\uc2dc \uae30\ub2a5\uc774 \uaebc\uc838 \uc788\uc73c\uba74 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc774 \uc608\uace0 \uc5c6\uc774 \uc0ac\ub77c\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\ud2b9\ud788 \uc124\uc815\uc744 \ubcc0\uacbd\ud558\uac70\ub098 \ub2e4\ub978 \ucef4\ud4e8\ud130\uc5d0\uc11c \ud30c\uc77c\uc744 \uc5f4 \ub54c \uc774\ub7ec\ud55c \ubb38\uc81c\uac00 \uc790\uc8fc \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li><strong>\ud30c\uc77c<\/strong> \uba54\ub274 \ub85c \uc774\ub3d9\ud55c \ub2e4\uc74c <strong>\uc635\uc158\uc744<\/strong> \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<li><strong>&#8216;\uace0\uae09&#8217;<\/strong> \uc744 \ud074\ub9ad\ud558\uc138\uc694.<\/li>\n<li><strong>\uc774 \ud1b5\ud569 \ubb38\uc11c\uc758 \ud45c\uc2dc \uc635\uc158<\/strong> \uc774\ub77c\ub294 \uc139\uc158\uae4c\uc9c0 \uc544\ub798\ub85c \uc2a4\ud06c\ub864\ud558\uc2ed\uc2dc\uc624.<\/li>\n<li><strong>&#8216;\ubaa8\ub450<\/strong> &#8216; \ub77c\ub514\uc624 \ubc84\ud2bc\uc774 &#8216; <strong>\uc5c6\uc74c(\uac1c\uccb4 \uc228\uae30\uae30)&#8217;<\/strong> \ub300\uc2e0 \uc120\ud0dd\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc2ed\uc2dc\uc624.<\/li>\n<li><strong>\ud655\uc778\uc744<\/strong> \ub204\ub974\uace0 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \ub2e4\uc2dc \ub098\ud0c0\ub098\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<\/ul>\n<p>\uc81c\uac00 \uc2dc\ub3c4\ud574 \ubcf8 \ud55c \ud658\uacbd\uc5d0\uc11c\ub294 \ud574\ub2f9 \uc124\uc815\uc744 \uaed0\ub2e4 \ucf1c\ub294 \uac83\ub9cc\uc73c\ub85c \ud574\uacb0\ub410\uc2b5\ub2c8\ub2e4.\ub2e4\ub978 \ud658\uacbd\uc5d0\uc11c\ub294 \uc7ac\uc2dc\uc791\uc774 \ud544\uc694\ud588\ub294\ub370, \uac00\ub054\uc529 \ubd88\uc548\uc815\ud55c \uac83 \uac19\uc2b5\ub2c8\ub2e4.\ud558\uc9c0\ub9cc \uc77c\ubc18\uc801\uc73c\ub85c \uac1c\uccb4 \uc228\uae30\uae30\uac00 \ubb38\uc81c\uc758 \uc6d0\uc778\uc778 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\ud30c\uc77c\uc744 \uc5f4\uace0 \ubcf5\uad6c\ud558\uc138\uc694<\/h3>\n<p>\uc5d1\uc140 \ud30c\uc77c\uc774 \uc774\uc0c1\ud558\uac8c \uc791\ub3d9\ud558\uac70\ub098 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \ub354 \uc774\uc0c1 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub294 \ub4f1\uc758 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud55c\ub2e4\uba74 \ud30c\uc77c \uc190\uc0c1 \ub54c\ubb38\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uc5d1\uc140 \ud30c\uc77c\uc740 \ud2b9\ubcc4\ud55c \uc774\uc720 \uc5c6\uc774 \uc190\uc0c1\ub418\ub294 \uacbd\uc6b0\uac00 \uc788\ub294\ub370, \ud2b9\ud788 \ud30c\uc77c\uc744 \ub9ce\uc774 \ud3b8\uc9d1\ud588\uac70\ub098 \uc608\uae30\uce58 \uc54a\uac8c \ucef4\ud4e8\ud130\uac00 \uc885\ub8cc\ub41c \uacbd\uc6b0\uc5d0 \uadf8\ub807\uc2b5\ub2c8\ub2e4.\uc774\ub7f4 \ub54c\ub294 \ub0b4\uc7a5\ub41c \ud30c\uc77c \ubcf5\uad6c \uae30\ub2a5\uc744 \ud65c\uc6a9\ud574 \ubcf4\uc138\uc694.<\/p>\n<ol>\n<li>\uc5d1\uc140\uc744 \uc2e4\ud589\ud558\uc138\uc694.<\/li>\n<li><strong>\ud30c\uc77c\uc744<\/strong> \ud074\ub9ad\ud55c \ub2e4\uc74c <strong>\uc5f4\uae30\ub97c<\/strong> \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<li>\ubb38\uc81c\uac00 \uc788\ub294 \ud30c\uc77c\uc744 \ucc3e\uc740 \ub2e4\uc74c \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<li><strong>&#8216;\uc5f4\uae30&#8217;<\/strong> \ubc84\ud2bc \uc606\uc5d0 \uc788\ub294 \uc791\uc740 \ud654\uc0b4\ud45c\ub97c \ud074\ub9ad\ud558\uace0 <strong>&#8216;\uc5f4\uae30 \ubc0f \ubcf5\uad6c&#8217;\ub97c<\/strong> \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<li>\uc635\uc158\uc5d0\uc11c <strong>&#8216;\ubcf5\uad6c&#8217;\ub97c<\/strong> \uc120\ud0dd\ud558\uc138\uc694.\uadf8\ub798\ub3c4 \ubb38\uc81c\uac00 \ud574\uacb0\ub418\uc9c0 \uc54a\uc73c\uba74 <strong>&#8216;\ub370\uc774\ud130 \ucd94\ucd9c&#8217;\uc744<\/strong> \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694.<\/li>\n<li>\uc791\uc5c5\uc774 \uc644\ub8cc\ub418\uba74 \ubcf5\uad6c\ub41c \ud30c\uc77c\uc744 \ub2e4\uc2dc \uc5f4\uc5b4 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \ub2e4\uc2dc \uc791\ub3d9\ud558\ub294\uc9c0 \ud655\uc778\ud558\uc2ed\uc2dc\uc624.<\/li>\n<\/ol>\n<p>\ub54c\ub85c\ub294 \uac04\ub2e8\ud55c \ubcf5\uad6c\ub9cc\uc73c\ub85c \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \ub2e4\uc2dc \ub098\ud0c0\ub0a0 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\ud558\uc9c0\ub9cc \ub54c\ub85c\ub294 \ubc31\uc5c5 \ud30c\uc77c\uc744 \uc0b4\ud3b4\ubd10\uc57c \ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.\uadf8\ub798\ub3c4 \uc2dc\ub3c4\ud574 \ubcfc \uac00\uce58\ub294 \ucda9\ubd84\ud569\ub2c8\ub2e4.<\/p>\n<h3>\ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac \uc124\uc815\uc744 \ud655\uc778\ud558\uc138\uc694<\/h3>\n<p>\ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc774 \ube44\uc5b4 \uc788\uac70\ub098 \ud074\ub9ad\ud574\ub3c4 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub294\ub2e4\uba74 \ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac \ubb38\uc81c\uc77c \uac00\ub2a5\uc131\uc774 \ub192\uc2b5\ub2c8\ub2e4.\uc6d0\ubcf8 \ubc94\uc704\uc5d0 \ube48 \uc140\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uac70\ub098 \uc140 \ub0b4 \ub4dc\ub86d\ub2e4\uc6b4\uc5d0 \ub300\ud55c \uc720\ud6a8\uc131 \uac80\uc0ac\uac00 \uc62c\ubc14\ub974\uac8c \uc124\uc815\ub418\uc9c0 \uc54a\uc558\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uc774\ub7ec\ud55c \ubd80\ubd84\uc744 \ud655\uc778\ud558\uace0 \uc218\uc815\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \uac04\ub2e8\ud55c \ud574\uacb0 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \uc788\ub294 \uc140 \ub610\ub294 \ubc94\uc704\ub97c \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<li><strong>\ub370\uc774\ud130<\/strong> \ud0ed \uc73c\ub85c \uc774\ub3d9\ud55c \ub2e4\uc74c <strong>\ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac\ub97c<\/strong> \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uc6d0\ubcf8<\/strong> \ud544\ub4dc\ub97c \ud655\uc778\ud558\uc5ec \ube48 \uc140 \uc5c6\uc774 \uc62c\ubc14\ub978 \ubc94\uc704\ub97c \uac00\ub9ac\ud0a4\ub294\uc9c0 \ud655\uc778\ud558\uc2ed\uc2dc\uc624.<\/li>\n<li>\uc6d0\ubcf8\uc5d0 \ube48 \uc140\uc774\ub098 \ucd94\uac00 \uacf5\ubc31\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294 \uacbd\uc6b0, \uc774\ub97c \uc815\ub9ac\ud558\uac70\ub098 \ubc94\uc704\ub97c \ub2e4\uc2dc \uc815\uc758\ud558\uc2ed\uc2dc\uc624.<\/li>\n<li>\ud654\uc0b4\ud45c\uac00 \ud45c\uc2dc\ub418\ub3c4\ub85d <strong>\uc140 \ub0b4 \ub4dc\ub86d\ub2e4\uc6b4<\/strong> \ud655\uc778\ub780\uc774 \uc120\ud0dd\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc2ed\uc2dc\uc624.<\/li>\n<\/ol>\n<p>\uc774\ub7f0 \uc0ac\uc18c\ud55c \uc2e4\uc218\ub294 \ud754\ud788 \ubc1c\uc0dd\ud558\ub294\ub370, \ud2b9\ud788 \ub370\uc774\ud130\ub97c \ubcf5\uc0ac\ud558\uac70\ub098 \uc774\ub3d9\ud560 \ub54c \uadf8\ub807\uc2b5\ub2c8\ub2e4.\uc18c\uc2a4 \ubaa9\ub85d\uc744 \uc218\uc815\ud558\uba74 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \ub9c8\ubc95\ucc98\ub7fc \ub2e4\uc2dc \ub098\ud0c0\ub098\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\uc720\ud6a8\uc131 \uac80\uc0ac\ub97c \uc704\ud574 \ubd99\uc5ec\ub123\uae30 \uc635\uc158\uc5d0\uc11c \ud2b9\uc218 \ubd99\uc5ec\ub123\uae30\ub97c \uc0ac\uc6a9\ud558\uc138\uc694.<\/h3>\n<p>\ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac\ub97c \uc9c1\uc811 \ubcf5\uc0ac\ud558\uba74 \uc801\uc6a9\ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.\uc774\ub7f4 \ub54c\ub294 &#8216; <strong>\ubd99\uc5ec\ub123\uae30 \uc635\uc158&#8217;<\/strong> \uc5d0\uc11c &#8216;\uc720\ud6a8\uc131 \uac80\uc0ac \ud3ec\ud568&#8217; \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.\uc880 \uc774\uc0c1\ud558\uac8c \ub4e4\ub9b4 \uc218\ub3c4 \uc788\uc9c0\ub9cc, \ud2b9\ud788 \uc774\uc804 \ubc84\uc804\uc758 Excel\uc5d0\uc11c\ub294 \uc774 \ubc29\ubc95\uc774 \ud6a8\uacfc\uc801\uc785\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\uc6d0\ubcf8 \uc140 \ub610\ub294 \ubc94\uc704\ub97c \ubcf5\uc0ac\ud558\uc138\uc694.<\/li>\n<li>\ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\ub97c \ud45c\uc2dc\ud560 \uc140\uc744 \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ubd99\uc5ec\ub123\uae30 \uc635\uc158\uc5d0\uc11c &#8216;\ubd99\uc5ec\ub123\uae30 \uc635\uc158&#8217;\uc744<\/strong> \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<li>\ub300\ud654 \uc0c1\uc790\uc5d0\uc11c <strong>\uc720\ud6a8\uc131 \uac80\uc0ac\ub97c<\/strong> \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ud655\uc778\uc744<\/strong> \ub204\ub974\uba74 \uc720\ud6a8\uc131 \uac80\uc0ac \uc815\ubcf4\uac00 \uc81c\ub300\ub85c \ubcf5\uc0ac\ub420 \uac83\uc785\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\uc77c\ubd80 \uc124\uc815\uc5d0\uc11c\ub294 \uc77c\ubc18 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30\uac00 \uc2e4\ud328\ud588\uc744 \ub54c \uc774 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\uba74 \ubaa9\ub85d\uc774 \ub2e4\uc2dc \uc815\uc0c1\uc801\uc73c\ub85c \uc791\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<h3>\uc140 \ub0b4 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \ud65c\uc131\ud654\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/h3>\n<p>\ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac \uc544\ub798\uc758 \ud655\uc778\ub780\uc774 \uc120\ud0dd\ub418\uc5b4 \uc788\uc9c0 \uc54a\uc73c\uba74 \ud654\uc0b4\ud45c\uac00 \ud45c\uc2dc\ub418\uc9c0 \uc54a\uc544 \ubaa9\ub85d\uc774 \uc0ac\ub77c\uc9c4 \uac83\ucc98\ub7fc \ubcf4\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.\uac04\ub2e8\ud558\uac8c \ud574\uacb0\ud558\ub824\uba74 \ud574\ub2f9 \ud655\uc778\ub780\uc744 \ub2e4\uc2dc \uc120\ud0dd\ud558\uc138\uc694.<\/p>\n<ol>\n<li>\ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uc5d0\uc11c \ud574\ub2f9 \uc140\uc744 \uc120\ud0dd\ud558\uc138\uc694.<\/li>\n<li><strong>\ub370\uc774\ud130<\/strong> &gt; <strong>\ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac<\/strong> \ub85c \uc774\ub3d9\ud558\uc138\uc694.<\/li>\n<li><strong>\uc140 \ub0b4 \ub4dc\ub86d\ub2e4\uc6b4<\/strong> \uc0c1\uc790\uac00 \uc120\ud0dd\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc2ed\uc2dc\uc624.<\/li>\n<li><strong>\ud655\uc778\uc744<\/strong> \ub204\ub974\uace0 \ud654\uc0b4\ud45c\uac00 \ub098\ud0c0\ub098\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<\/ol>\n<p>\uc774\ub294 \uae30\ubcf8\uc801\uc774\uc9c0\ub9cc \uc885\uc885 \uac04\uacfc\ub418\ub294 \ubd80\ubd84\uc785\ub2c8\ub2e4.\uc774\ub7ec\ud55c \uc124\uc815\uc774 \uaebc\uc838 \uc788\uc73c\uba74 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \ubcf4\uc774\uc9c0 \uc54a\ub294 \uac83\uc740 \ub2f9\uc5f0\ud55c \uc77c\uc785\ub2c8\ub2e4.<\/p>\n<h3>OFFSET\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubaa9\ub85d\uc744 \ub3d9\uc801\uc73c\ub85c \uc720\uc9c0\ud558\uc138\uc694<\/h3>\n<p>\ubaa9\ub85d\uc5d0 \ud56d\ubaa9\uc744 \uc790\uc8fc \ucd94\uac00\ud558\ub294 \ubc94\uc704\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294\ub370, \uc218\ub3d9\uc73c\ub85c \uc18c\uc2a4\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\uc9c0 \uc54a\uc73c\uba74 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc5d0 \uc0c8 \ud56d\ubaa9\uc774 \ud45c\uc2dc\ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0 OFFSET \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.\uc774 \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc0c8 \ub370\uc774\ud130\uac00 \ucd94\uac00\ub420 \ub54c \ubaa9\ub85d\uc774 \uc790\ub3d9\uc73c\ub85c \ud655\uc7a5\ub418\ubbc0\ub85c \ub9e4\ubc88 \uc720\ud6a8\uc131 \uac80\uc0ac \uc18c\uc2a4\ub97c \ud3b8\uc9d1\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \uc788\ub294 \uc140\uc744 \uc120\ud0dd\ud558\uace0 <strong>\ub370\uc774\ud130<\/strong> &gt; <strong>\ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac<\/strong> \ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uc124\uc815 &gt; <\/strong><strong>\uc18c\uc2a4<\/strong> \uc0c1\uc790 \uc5d0 \ub2e4\uc74c \uc744 \uc785\ub825\ud558\uc138\uc694.<\/li>\n<li><code>=OFFSET($B$2, 0, 0, COUNTA($B:$B)-1)<\/code><\/li>\n<li>\ubaa9\ub85d\uc758 \uc2dc\uc791 \uc9c0\uc810\uc5d0 \ub530\ub77c \uc140 \ucc38\uc870\ub97c \uc870\uc815\ud558\uc138\uc694.<strong>B2<\/strong> \ub294 \ub2e8\uc9c0 \uc608\uc2dc\uc77c \ubfd0\uc785\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\uc880 \uc774\uc0c1\ud558\uac8c \ub4e4\ub9b4 \uc218\ub3c4 \uc788\uc9c0\ub9cc, \uc2dc\uac04\uc774 \uc9c0\ub0a8\uc5d0 \ub530\ub77c \ubaa9\ub85d\uc774 \ub298\uc5b4\ub098\ub3c4 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \uae68\uc9c0\uc9c0 \uc54a\uac8c \ud558\ub294 \ub370 \uc544\uc8fc \ud6a8\uacfc\uc801\uc785\ub2c8\ub2e4.\uba87\uba87 \uc2dc\ud2b8\uc5d0\uc11c\ub294 \uc774 \uae30\ub2a5 \ub355\ubd84\uc5d0 \uace8\uce58 \uc544\ud508 \ubb38\uc81c\ub97c \ub9ce\uc774 \ud574\uacb0\ud560 \uc218 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\ub9ac\uc2a4\ud2b8 \uc774\ub984\uc5d0 \uacf5\ubc31\uc774 \uc788\ub294 \uacbd\uc6b0 INDIRECT \ubc0f SUBSTITUTE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc138\uc694.<\/h3>\n<p>\ubaa9\ub85d \uc774\ub984\uc5d0 \uacf5\ubc31\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uace0 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uc5d0 \ub370\uc774\ud130\uac00 \uc81c\ub300\ub85c \ud45c\uc2dc\ub418\uc9c0 \uc54a\ub294\ub2e4\uba74 \ucc38\uc870 \uc124\uc815 \ubc29\uc2dd \ub54c\ubb38\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. INDIRECT \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \ub3d9\uc801 \ucc38\uc870\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uace0, SUBSTITUTE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uacf5\ubc31\uc744 \ubc11\uc904\ub85c \ubc14\uafd4 \uc218\uc2dd\uc774 \uc6d0\ud65c\ud558\uac8c \uc791\ub3d9\ud558\ub3c4\ub85d \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\uc140\uc744 \uc120\ud0dd\ud558\uace0 <strong>\ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac<\/strong> \ub97c \ud074\ub9ad\ud558\uc138\uc694.<\/li>\n<li><strong>\uc18c\uc2a4<\/strong> \uc0c1\uc790 \uc5d0 \ub2e4\uc74c\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n<li><code>=INDIRECT(SUBSTITUTE(C1, \u201c \u201d, \u201c_\u201d))<\/code><\/li>\n<li><strong>C1 \uc140\uc744<\/strong> \ubaa9\ub85d \uc774\ub984\uc774 \uc788\ub294 \uc140\ub85c \ubc14\uafb8\uc138\uc694.<\/li>\n<li><strong>\ud655\uc778<\/strong> \uc744 \ud074\ub9ad\ud558\uc138\uc694.<\/li>\n<\/ol>\n<p>\uc774 \ubc29\ubc95\uc740 \uc57d\uac04 \uad50\ubb18\ud558\uc9c0\ub9cc, \uc774\ub984\uc5d0 \uacf5\ubc31\uc774 \uc788\ub294 \ubaa9\ub85d\uc744 \uc624\ub958 \uc5c6\uc774 \uc0ac\uc6a9\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.\ud2b9\ud788 \uc5ec\ub7ec \ubaa9\ub85d\uc744 \ubcd1\ud569\ud558\uac70\ub098 \ubc94\uc704\ub97c \uc774\ub984 \ubcc0\uacbd\ud560 \ub54c \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p>\uacb0\ub860\uc801\uc73c\ub85c, \uc5d1\uc140\uc758 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc740 \ub54c\ub54c\ub85c \uae4c\ub2e4\ub85c\uc6b8 \uc218 \uc788\uc9c0\ub9cc, \ub300\ubd80\ubd84\uc758 \ubb38\uc81c\ub294 \uc27d\uac8c \uc218\uc815\ud560 \uc218 \uc788\ub294 \uc124\uc815\uc774\ub098 \uac04\ub2e8\ud55c \ud30c\uc77c \ubcf5\uad6c\ub85c \ud574\uacb0\ub429\ub2c8\ub2e4.\uc5d1\uc140 \ubc84\uc804\uc774\ub098 \ud30c\uc77c \uc0dd\uc131 \ubc29\uc2dd\uc5d0 \ub530\ub77c \ud574\uacb0 \ubc29\ubc95\uc774 \ub2e4\ub97c \uc218 \uc788\uc73c\ubbc0\ub85c, \uacbd\uc6b0\uc5d0 \ub530\ub77c \uc5ec\ub7ec \uac00\uc9c0 \ud574\uacb0 \ubc29\ubc95\uc744 \uc870\ud569\ud574\uc57c \ud560 \uc218\ub3c4 \uc788\ub2e4\ub294 \uc810\uc744 \uc720\ub150\ud558\uc138\uc694.\uc774 \uc815\ubcf4\uac00 \ub204\uad70\uac00\uc5d0\uac8c \uc2dc\uac04 \ub0ad\ube44\ub098 \ubd88\ud3b8\ud568\uc744 \uc904\uc774\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub418\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n<h2>\uc694\uc57d<\/h2>\n<ul>\n<li>\uac1d\uccb4 \uac00\uc2dc\uc131 \ubc0f \ud45c\uc2dc \uc635\uc158\uc744 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<li>\ud30c\uc77c\uc774 \uc81c\ub300\ub85c \uc791\ub3d9\ud558\uc9c0 \uc54a\uc73c\uba74 \ud30c\uc77c &gt; \uc5f4\uae30 \ubc0f \ubcf5\uad6c\ub97c \uc2e4\ud589\ud558\uc138\uc694.<\/li>\n<li>\ub370\uc774\ud130 \uc720\ud6a8\uc131 \uac80\uc0ac \uc18c\uc2a4 \ubc94\uc704 \ubc0f \uc140 \ub0b4 \ub4dc\ub86d\ub2e4\uc6b4\uc744 \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n<li>\ud544\uc694\ud55c \uacbd\uc6b0 \ubcf5\uc0ac &gt; \uc720\ud6a8\uc131 \uac80\uc0ac\ub97c \ud3ec\ud568\ud55c \ubd99\uc5ec\ub123\uae30 \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc138\uc694.<\/li>\n<li>\ub3d9\uc801 \ub9ac\uc2a4\ud2b8\uc5d0 \ub300\ud574 OFFSET\uc744 \uad6c\ud604\ud558\uc138\uc694<\/li>\n<li>\ub9ac\uc2a4\ud2b8 \uc774\ub984\uc5d0 \uacf5\ubc31\uc774 \ud3ec\ud568\ub41c \uacbd\uc6b0 INDIRECT \ubc0f SUBSTITUTE\ub97c \uc0ac\uc6a9\ud558\uc138\uc694.<\/li>\n<\/ul>\n<h2>\ub9c8\ubb34\ub9ac<\/h2>\n<p>\uc774 \ud574\uacb0 \ubc29\ubc95\ub4e4\uc740 \uc5d1\uc140\uc5d0\uc11c \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 \uc0ac\ub77c\uc9c0\uac70\ub098 \uc791\ub3d9\ud558\uc9c0 \uc54a\ub294 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778\ub4e4\uc744 \ub2e4\ub8f9\ub2c8\ub2e4.\ub54c\ub85c\ub294 \ud574\uacb0\ud558\uae30\uac00 \uc5b4\ub824\uc6b8 \uc218 \uc788\uc9c0\ub9cc, \uc124\uc815\uc774 \uc62c\ubc14\ub974\uac8c \ub9de\ucdb0\uc9c0\uba74 \ubaa8\ub4e0 \uac83\uc774 \uc81c\uc790\ub9ac\ub97c \ucc3e\uc744 \uac83\uc785\ub2c8\ub2e4.\ud55c \uac00\uc9c0 \ud574\uacb0 \ubc29\ubc95\uc774 \ud6a8\uacfc\uac00 \uc5c6\ub2e4\uba74, \ub2e4\ub978 \ubc29\ubc95\uc744 \uc2dc\ub3c4\ud574 \ubcf4\uc138\uc694.\uc774 \ubc29\ubc95\ub4e4\uc774 \uc5ec\ub7ec\ubd84\uc758 \uc2dc\uac04 \ub0ad\ube44\ub97c \uc904\uc5ec\uc904 \uc218 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.\ubb3c\ub860 \ubcf4\uc7a5\ud560 \uc218\ub294 \uc5c6\uc9c0\ub9cc, \uc2dc\ub3c4\ud574 \ubcfc \uac00\uce58\ub294 \ucda9\ubd84\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc5d1\uc140 \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc5d0 \ubb38\uc81c\uac00 \uc788\uc73c\uc2e0\uac00\uc694? \ub370\uc774\ud130 \uc785\ub825\uc774\ub098 \ubd84\uc11d \uc791\uc5c5\uc744 \ud55c\ucc3d \uc9c4\ud589 \uc911\uc77c \ub54c \uac11\uc790\uae30 \uc791\ub3d9\uc774 \uba48\ucd94\uba74 \uc815\ub9d0 \uc9dc\uc99d \ub098\uc8e0.\uc124\uc815 \uc624\ub958\uc77c \uc218\ub3c4 \uc788\uace0, \ud30c\uc77c\uc774 \uc57d\uac04 \uc190\uc0c1\ub418\uc5c8\uc744 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.\ud558\uc9c0\ub9cc \ucf54\ub4dc\ub97c \uae4a\uc774 \ud30c\uace0\ub4e4\uc9c0 \uc54a\uace0\ub3c4 \uac04\ub2e8\ud558\uac8c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\ub4e4\uc774 \uc788\uc2b5\ub2c8\ub2e4.\ubb3c\ub860 \uc774\ub7f0 \uc0ac\uc18c\ud55c \ubb38\uc81c \ub54c\ubb38\uc5d0 \uc791\uc5c5 \ud750\ub984\uc774 \ub04a\uae30\uba74 \ub2f5\ub2f5\ud558\uaca0\uc9c0\ub9cc, \ub2e4\ud589\ud788 \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 \ud574\uacb0\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ub2e4\uc74c \ub2e8\uacc4\ub97c \ub530\ub974\uba74 \ub4dc\ub86d\ub2e4\uc6b4 \uba54\ub274\uac00 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-11109","post","type-post","status-publish","format-standard","hentry","category-how-to"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/11109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/comments?post=11109"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/11109\/revisions"}],"predecessor-version":[{"id":11110,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/11109\/revisions\/11110"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/media?parent=11109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/categories?post=11109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/tags?post=11109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}