{"id":6332,"date":"2025-01-07T17:44:48","date_gmt":"2025-01-07T17:44:48","guid":{"rendered":"https:\/\/howtogeek.blog\/ko\/?p=6332"},"modified":"2025-01-07T17:44:48","modified_gmt":"2025-01-07T17:44:48","slug":"how-to-use-the-new-trimrange-function-for-cleaning-up-excel-worksheets","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/ko\/how-to-use-the-new-trimrange-function-for-cleaning-up-excel-worksheets\/","title":{"rendered":"Excel \uc6cc\ud06c\uc2dc\ud2b8 \uc815\ub9ac\ub97c \uc704\ud55c \uc0c8\ub85c\uc6b4 TRIMRANGE \ud568\uc218 \uc0ac\uc6a9 \ubc29\ubc95"},"content":{"rendered":"<p>\uc2dc\uac01\uc801\uc73c\ub85c \ub9e4\ub825\uc801\uc774\uace0 \uace0\ud488\uc9c8\uc758 Excel \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \ub9cc\ub4e4\uba74 \uc804\ubb38\uc801\uc778 \uc774\ubbf8\uc9c0\uac00 \uac15\ud654\ub418\uace0 \ub370\uc774\ud130 \ubd84\uc11d\uc774 \uac1c\uc120\ub429\ub2c8\ub2e4. \ud560 \uc218 \uc788\ub294 \uc911\uc694\ud55c \uac1c\uc120 \uc0ac\ud56d \uc911 \ud558\ub098\ub294 \ub370\uc774\ud130 \ud504\ub808\uc820\ud14c\uc774\uc158\uc744 \uc5b4\uc9c0\ub7fd\ud790 \uc218 \uc788\ub294 \ube48 \ud589\uc774\ub098 \uacf5\ubc31 \ud589\uc744 \uc81c\uac70\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\ud589\ud788\ub3c4 Microsoft Excel\uc5d0\ub294 \uc774\uc81c <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/announcing-trimrange-and-accompanying-trim-references\/ba-p\/4230202\" rel=\"noopener noreferrer\" target=\"_blank\">TRIMRANGE \ud568\uc218\uac00<\/a> \uc788\uc2b5\ub2c8\ub2e4 . \uc774 \ud601\uc2e0\uc801\uc778 \ucd94\uac00 \uae30\ub2a5\uc740 \ub370\uc774\ud130 \ubc94\uc704\uc5d0\uc11c \ube48 \ud589\uc744 \uc81c\uac70\ud558\ub294 \uc791\uc5c5\uc744 \uac04\uc18c\ud654\ud558\uc5ec \uacc4\uc0b0 \uc911 \uc624\ub958\ub97c \ud53c\ud558\uace0 \uc6cc\ud06c\uc2dc\ud2b8\uc758 \uc804\ubc18\uc801\uc778 \ubaa8\uc591\uc744 \ud5a5\uc0c1\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n<h2 id=\"steps-to-effectively-utilize-the-trimrange-function-in-excel\">Excel\uc5d0\uc11c TRIMRANGE \ud568\uc218\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \ud65c\uc6a9\ud558\uae30 \uc704\ud55c \ud544\uc218 \ub2e8\uacc4<\/h2>\n<figure class=\"wp-block-image\"><img alt=\"Microsoft Excel\uc5d0\uc11c TRIMRANGE \ud568\uc218 \ub2e8\uacc4\uc5d0 \ub300\ud55c \uc2dc\uac01\uc801 \uac00\uc774\ub4dc\" class=\"wp-image\" decoding=\"async\" height=\"490\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/Steps-on-How-to-Utilize-TRIMRANGE-Function-on-Microsoft-Excel.webp\" title=\"Microsoft Excel\uc5d0\uc11c TRIMRANGE \ud568\uc218 \ub2e8\uacc4\uc5d0 \ub300\ud55c \uc2dc\uac01\uc801 \uac00\uc774\ub4dc\" width=\"800\"\/><\/figure>\n<p>TRIMRANGE \ud568\uc218\ub294 Excel\uc5d0\uc11c \uad00\ub828 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub41c \uc140\ub9cc \ud45c\uc2dc\ud558\uc5ec \uc9c0\uc815\ub41c \ubc94\uc704 \ub0b4\uc5d0\uc11c \uc6d0\uce58 \uc54a\ub294 \uacb0\uacfc\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \ud2b8\ub9ac\ubc0d\ud558\ub824\ub294 \uc0ac\uc6a9\uc790\ub97c \uc704\ud574 \ub9de\ucda4 \uc81c\uc791\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \ud568\uc218\uc758 \uc7a5\uc810\uc740 \ub3d9\uc801 \ud2b9\uc131\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \uc138\ud2b8\uc5d0 \ucd94\uac00 \uac12\uc744 \uacc4\uc18d \uc785\ub825\ud558\uba74 \uacb0\uacfc\uac00 \uc790\ub3d9\uc73c\ub85c \uc870\uc815\ub418\uc5b4 \uc774\ub7ec\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc744 \ubc18\uc601\ud569\ub2c8\ub2e4.<\/p>\n<p>TRIMRANGE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 Excel \uc218\uc2dd\uc5d0 \uc9c1\uc811 \uad6c\ud604\ud558\uba74 \ub429\ub2c8\ub2e4. \uc608: <code>=LEN(TRIMRANGE(A:A))<\/code>. \uc774 \uc218\uc2dd\uc740 \uc9c0\uc815\ub41c \ubc94\uc704(\uc774 \uacbd\uc6b0 \uc5f4 A)\uc5d0\uc11c \uad00\ub828 \uc5c6\ub294 \uacf5\ubc31\uc774\ub098 0\uc774 \ud3ec\ud568\ub420 \uc218 \uc788\ub294 \ubd88\ud544\uc694\ud55c \uacb0\uacfc\ub97c \uc81c\uac70\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uc5b4 A1\uc5d0\uc11c A14\uae4c\uc9c0 \ub370\uc774\ud130\uac00 \ucc44\uc6cc\uc9c4\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc5f4 C\uc5d0 LEN \ubc0f TRIMRANGE \ud568\uc218\ub97c \uc801\uc6a9\ud558\uba74 \ucd9c\ub825\uc5d0\ub294 C14\uae4c\uc9c0 \uc720\ud6a8\ud55c \uacb0\uacfc\ub9cc \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ub610\ud55c A15, A16 \ubc0f A17\uc5d0 \uc0c8 \ub370\uc774\ud130\uac00 \uc785\ub825\ub418\uba74 \ud574\ub2f9 \uc5c5\ub370\uc774\ud2b8\uac00 C15, C16 \ubc0f C17\uc5d0 \uc790\ub3d9\uc73c\ub85c \ubc18\uc601\ub429\ub2c8\ub2e4.<\/p>\n<p>Excel\uc5d0\uc11c TRIMRANGE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \uad6c\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4 <code>=TRIMRANGE(range,[trim_rows],[trim_cols])<\/code>. \uc774 \uad6c\ubb38\uc5d0\uc11c\ub294 \uc815\ub9ac\ud558\ub824\ub294 \uc140 \ubc94\uc704\ub97c \uc9c0\uc815\ud558\uace0 \ud544\uc694\uc5d0 \ub530\ub77c \uc81c\uc678\ud560 \ud589\uacfc \uc5f4\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n<h2 id=\"conclusion\">\uacb0\ub860<\/h2>\n<p>Excel \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \uc815\ub9ac\ud558\uba74 \ub370\uc774\ud130\uac00 \uc138\ub828\ub418\uac8c \ubcf4\uc77c \ubfd0\ub9cc \uc544\ub2c8\ub77c \ubd88\ud544\uc694\ud55c \uc7a1\ub3d9\uc0ac\ub2c8\ub97c \uc81c\uac70\ud558\uc5ec \uba85\ud655\uc131\uc744 \ucd09\uc9c4\ud569\ub2c8\ub2e4. \ub2e4\uc74c \ub370\uc774\ud130 \uc815\ub9ac\ub97c \uc704\ud574 TRIMRANGE \ud568\uc218\ub97c \ucc44\ud0dd\ud558\uc138\uc694. \uc815\ubcf4\ub97c \ub354 \ud6a8\uacfc\uc801\uc73c\ub85c \ud45c\ud604\ud558\ub294 \ub370 \ud070 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>\ucd94\uac00 \ud1b5\ucc30\ub825<\/h3>\n<h4><strong>1. TRIMRANGE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc5b4\ub5a4 \uc720\ud615\uc758 \ub370\uc774\ud130\ub97c \uc815\ub9ac\ud560 \uc218 \uc788\ub098\uc694?<\/strong><\/h4>\n<p>TRIMRANGE \ud568\uc218\ub294 \ub2e4\uc7ac\ub2e4\ub2a5\ud558\uba70 \ube48 \ud589\uc774\ub098 \uad00\ub828 \uc5c6\ub294 \ub370\uc774\ud130\uac00 \uc788\ub294 Excel\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130 \uc138\ud2b8\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 \ub2e4\uc591\ud55c \uc5f4\uc5d0 \uac78\uce5c \uc22b\uc790, \ud14d\uc2a4\ud2b8 \ub610\ub294 \ud63c\ud569 \ub370\uc774\ud130 \uc720\ud615\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n<h4><strong>2. TRIMRANGE\ub97c \ub2e4\ub978 Excel \ud568\uc218\uc640 \ud568\uaed8 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub098\uc694?<\/strong><\/h4>\n<p>\ubb3c\ub860\uc785\ub2c8\ub2e4! TRIMRANGE \ud568\uc218\ub294 LEN, COUNT, AVERAGE, SUM\uacfc \uac19\uc740 \ub2e4\uc591\ud55c Excel \ud568\uc218\uc640 \uc6d0\ud65c\ud558\uac8c \uc791\ub3d9\ud558\uc5ec \ubcf5\uc7a1\ud55c \uacc4\uc0b0\uc744 \ucd5c\uc801\ud654\ud558\ub294 \ub3d9\uc2dc\uc5d0 \uae54\ub054\ud55c \ub370\uc774\ud130 \ud45c\ud604\uc744 \uc720\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h4><strong>3. TRIMRANGE \ud568\uc218\ub294 \ubaa8\ub4e0 Excel \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub098\uc694?<\/strong><\/h4>\n<p>TRIMRANGE \ud568\uc218\ub294 Microsoft Excel\uc758 \ucd5c\uc2e0 \uc5c5\ub370\uc774\ud2b8\uc758 \uc77c\ubd80\uc785\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc5d0 \uc561\uc138\uc2a4\ud558\ub824\uba74 \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub97c \ucd5c\uc2e0 \ubc84\uc804\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\uc804 \ubc84\uc804\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><a class=\"xiaomi\" href=\"https:\/\/www.windowsdispatch.com\/use-new-trimrange-function-to-clean-up-excel-worksheet\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">\ucd9c\ucc98 \ubc0f \uc774\ubbf8\uc9c0<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc2dc\uac01\uc801\uc73c\ub85c \ub9e4\ub825\uc801\uc774\uace0 \uace0\ud488\uc9c8\uc758 Excel \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub97c \ub9cc\ub4e4\uba74 \uc804\ubb38\uc801\uc778 \uc774\ubbf8\uc9c0\uac00 \uac15\ud654\ub418\uace0 \ub370\uc774\ud130 \ubd84\uc11d\uc774 \uac1c\uc120\ub429\ub2c8\ub2e4. \ud560 \uc218 \uc788\ub294 \uc911\uc694\ud55c \uac1c\uc120 \uc0ac\ud56d \uc911 \ud558\ub098\ub294 \ub370\uc774\ud130 \ud504\ub808\uc820\ud14c\uc774\uc158\uc744 \uc5b4\uc9c0\ub7fd\ud790 \uc218 \uc788\ub294 \ube48 \ud589\uc774\ub098 \uacf5\ubc31 \ud589\uc744 \uc81c\uac70\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \ub2e4\ud589\ud788\ub3c4 Microsoft Excel\uc5d0\ub294 \uc774\uc81c TRIMRANGE \ud568\uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4 . \uc774 \ud601\uc2e0\uc801\uc778 \ucd94\uac00 \uae30\ub2a5\uc740 \ub370\uc774\ud130 \ubc94\uc704\uc5d0\uc11c \ube48 \ud589\uc744 \uc81c\uac70\ud558\ub294 \uc791\uc5c5\uc744 \uac04\uc18c\ud654\ud558\uc5ec \uacc4\uc0b0 \uc911 \uc624\ub958\ub97c \ud53c\ud558\uace0 \uc6cc\ud06c\uc2dc\ud2b8\uc758 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[9],"class_list":["post-6332","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-windows"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/6332","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=6332"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/6332\/revisions"}],"predecessor-version":[{"id":6333,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/6332\/revisions\/6333"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/media?parent=6332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/categories?post=6332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/tags?post=6332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}