{"id":10070,"date":"2025-01-08T01:27:23","date_gmt":"2025-01-08T01:27:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/cach-thiet-lap-va-ap-dung-named-ranges-hay-gap-khi-thi-mos\/"},"modified":"2025-01-08T01:27:23","modified_gmt":"2025-01-08T01:27:23","slug":"cach-thiet-lap-va-ap-dung-named-ranges-hay-gap-khi-thi-mos","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/08\/cach-thiet-lap-va-ap-dung-named-ranges-hay-gap-khi-thi-mos\/","title":{"rendered":"C\u00e1ch thi\u1ebft l\u1eadp v\u00e0 \u00e1p d\u1ee5ng Named Ranges hay g\u1eb7p khi thi MOS"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>\u0110\u1ec3 d\u1ec5 d\u00e0ng nh\u1eadn bi\u1ebft v\u00e0 \u00e1p d\u1ee5ng m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u c\u1ee5 th\u1ec3 trong c\u00e1c thao t\u00e1c v\u1edbi Excel, b\u1ea1n c\u00f3 th\u1ec3 <strong>thi\u1ebft l\u1eadp v\u00e0 \u00e1p d\u1ee5ng Named Ranges<\/strong> (\u0111\u1eb7t t\u00ean cho v\u00f9ng). C\u00e1ch \u0111\u1eb7t t\u00ean ra sao, h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-677dd47a4a9e1\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/thiet-lap-va-ap-dung-named-ranges-mos.html#Thiet_lap_va_ap_dung_Named_Ranges\" title=\"Thi\u1ebft l\u1eadp v\u00e0 \u00e1p d\u1ee5ng Named Ranges\">Thi\u1ebft l\u1eadp v\u00e0 \u00e1p d\u1ee5ng Named Ranges<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/thiet-lap-va-ap-dung-named-ranges-mos.html#Thiet_lap_Named_Ranges\" title=\"Thi\u1ebft l\u1eadp Named Ranges\">Thi\u1ebft l\u1eadp Named Ranges<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/thiet-lap-va-ap-dung-named-ranges-mos.html#Chinh_sua_Named_Ranges\" title=\"Ch\u1ec9nh s\u1eeda Named Ranges\">Ch\u1ec9nh s\u1eeda Named Ranges<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/thiet-lap-va-ap-dung-named-ranges-mos.html#Xoa_Named_Ranges\" title=\"X\u00f3a Named Ranges\">X\u00f3a Named Ranges<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/thiet-lap-va-ap-dung-named-ranges-mos.html#Ap_dung_Named_Ranges\" title=\"\u00c1p d\u1ee5ng Named Ranges\">\u00c1p d\u1ee5ng Named Ranges<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Thiet_lap_va_ap_dung_Named_Ranges\"><\/span><strong>Thi\u1ebft l\u1eadp v\u00e0 \u00e1p d\u1ee5ng Named Ranges<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_Named_Ranges\"><\/span><strong>Thi\u1ebft l\u1eadp Named Ranges<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_21093\" aria-describedby=\"caption-attachment-21093\" style=\"width: 614px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21093 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-name-manager.png\" width=\"614\" height=\"588\" title=\"mos-excel-2010-name-manager\"><figcaption id=\"caption-attachment-21093\" class=\"wp-caption-text\">2 b\u01b0\u1edbc m\u1edf h\u1ed9p tho\u1ea1i Name Manager<\/figcaption><\/figure>\n<p>\u0110\u1ec3 thi\u1ebft l\u1eadp Named Ranges, ta v\u00e0o th\u1ebb <strong>Formulas, <\/strong>nh\u00f3m <strong>Defined Names<\/strong>, ch\u1ecdn <strong>Name manager. <\/strong>Trong h\u1ed9p tho\u1ea1i <strong>Name Manager<\/strong> ch\u1ecdn <strong>New\u2026<\/strong>, sau \u0111\u00f3 ti\u1ebfn h\u00e0nh thao t\u00e1c v\u1edbi h\u1ed9p tho\u1ea1i <strong>New Name <\/strong>nh\u01b0 sau:<\/p>\n<p>\u2013<em>Name: <\/em>Nh\u1eadp t\u00ean v\u00f9ng mu\u1ed1n \u0111\u1eb7t v\u00e0o.<\/p>\n<p><strong>L\u01b0u \u00fd: <\/strong>T\u00ean \u0111\u00fang kh\u00f4ng \u0111\u01b0\u1ee3c c\u00f3 nh\u1eefng \u0111i\u1ec1u sau:<\/p>\n<ul>\n<li>Kh\u00f4ng b\u1eaft \u0111\u1ea7u v\u1edbi ch\u1eef c\u00e1i ho\u1eb7c d\u1ea5u g\u1ea1ch d\u01b0\u1edbi.<\/li>\n<li>S\u1eed d\u1ee5ng kho\u1ea3ng tr\u1eafng ho\u1eb7c k\u00ed t\u1ef1 kh\u00f4ng h\u1ee3p l\u1ec7.<\/li>\n<li>Tr\u00f9ng v\u1edbi t\u00ean \u0111\u00e3 c\u00f3 s\u1eb5n.<\/li>\n<\/ul>\n<p>N\u1ebfu nh\u1eadp sai, h\u1ed9p tho\u1ea1i b\u00e1o l\u1ed7i s\u1ebd hi\u1ec7n ra v\u00e0 y\u00eau c\u1ea7u nh\u1eadp l\u1ea1i.<\/p>\n<p>\u2013<em>Scope: <\/em>Ph\u1ea1m vi s\u1eed d\u1ee5ng t\u00ean. V\u1edbi scope <strong>workbook<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng t\u00ean v\u1eeba \u0111\u1eb7t cho to\u00e0n b\u1ed9 c\u00e1c trang t\u00ednh. V\u1edbi c\u00e1c scope nh\u1ecf h\u01a1n l\u00e0 t\u00ean c\u00e1c trang t\u00ednh, b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho ri\u00eang trang t\u00ednh \u0111\u00f3 m\u00e0 th\u00f4i.<\/p>\n<p>\u2013<em>Comment:<\/em> Th\u00eam th\u00f4ng tin li\u00ean quan \u0111\u1ebfn v\u00f9ng \u0111\u1eb7t t\u00ean (kh\u00f4ng b\u1eaft bu\u1ed9c).<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-129.gif\" title=\"ex101_92019-nho-129\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u2013<em>Refers to:<\/em> V\u00f9ng mu\u1ed1n \u00e1p d\u1ee5ng t\u00ean.<\/p>\n<p>Sau khi \u0111\u00e3 ho\u00e0n th\u00e0nh vi\u1ec7c \u0111\u1eb7t t\u00ean, b\u1ea5m OK \u0111\u1ec3 \u00e1p d\u1ee5ng.<\/p>\n<figure id=\"attachment_21095\" aria-describedby=\"caption-attachment-21095\" style=\"width: 557px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21095\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-new-name.png\" width=\"557\" height=\"348\" title=\"mos-excel-2010-new-name\"><figcaption id=\"caption-attachment-21095\" class=\"wp-caption-text\">\u0110\u1eb7t t\u00ean m\u1edbi<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Chinh_sua_Named_Ranges\"><\/span><strong>Ch\u1ec9nh s\u1eeda Named Ranges<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 ti\u1ebfn h\u00e0nh ch\u1ec9nh s\u1eeda v\u00f9ng \u0111\u1eb7t t\u00ean, ta m\u1edf h\u1ed9p tho\u1ea1i <strong>Name Manager<\/strong>, sau \u0111\u00f3 ch\u1ecdn t\u00ean mu\u1ed1n ch\u1ec9nh s\u1eeda v\u00e0 \u1ea5n <strong>Edit\u2026<\/strong><\/p>\n<figure id=\"attachment_21096\" aria-describedby=\"caption-attachment-21096\" style=\"width: 595px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21096\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-edit-name.png\" width=\"595\" height=\"281\" title=\"mos-excel-2010-edit-name\"><figcaption id=\"caption-attachment-21096\" class=\"wp-caption-text\">H\u1ed9p tho\u1ea1i Edit name<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Xoa_Named_Ranges\"><\/span><strong>X\u00f3a Named Ranges<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 x\u00f3a Named Ranages, trong h\u1ed9p tho\u1ea1i <strong>Name Manager<\/strong>, ch\u1ecdn t\u00ean mu\u1ed1n x\u00f3a sau \u0111\u00f3 \u1ea5n <strong>Delete.<\/strong><\/p>\n<figure id=\"attachment_21097\" aria-describedby=\"caption-attachment-21097\" style=\"width: 566px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21097\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-delete-name.png\" width=\"566\" height=\"455\" title=\"mos-excel-2010-delete-name\"><figcaption id=\"caption-attachment-21097\" class=\"wp-caption-text\">X\u00f3a name range<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Ap_dung_Named_Ranges\"><\/span><strong>\u00c1p d\u1ee5ng Named Ranges<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Named Ranges c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng trong nhi\u1ec1u thao t\u00e1c v\u1edbi trang t\u00ednh. Ng\u01b0\u1eddi s\u1eed d\u1ee5ng c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm v\u00f9ng t\u00ean b\u1eb1ng c\u00e1ch g\u00f5 Named Ranges v\u00e0o trong Namebox, ho\u1eb7c s\u1eed d\u1ee5ng Named Ranges trong c\u00f4ng th\u1ee9c. Ngo\u00e0i ra c\u00f2n h\u00e0ng lo\u1ea1t \u1ee9ng d\u1ee5ng kh\u00e1c t\u00f9y theo nhu c\u1ea7u ng\u01b0\u1eddi d\u00f9ng Excel.<\/p>\n<figure id=\"attachment_21098\" aria-describedby=\"caption-attachment-21098\" style=\"width: 299px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21098\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-nameboxx.png\" width=\"299\" height=\"286\" title=\"mos-excel-2010-nameboxx\"><figcaption id=\"caption-attachment-21098\" class=\"wp-caption-text\">T\u00ecm ki\u1ebfm th\u00f4ng qua namebox<\/figcaption><\/figure>\n<figure id=\"attachment_21099\" aria-describedby=\"caption-attachment-21099\" style=\"width: 429px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-21099\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/mos-excel-2010-cal-name-range.png\" width=\"429\" height=\"387\" title=\"mos-excel-2010-cal-name-range\"><figcaption id=\"caption-attachment-21099\" class=\"wp-caption-text\">Ho\u1eb7c s\u1eed d\u1ee5ng Named Ranges trong c\u00f4ng th\u1ee9c hay c\u00e1c h\u00e0m<\/figcaption><\/figure>\n<p><strong>Xem th\u00eam:<\/strong> <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tao-name-va-su-dung-name-trong-vba-excel.html\">\u0110\u1eb7t Named Ranges trong VBA<\/a><\/p>\n<p>B\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u1ef1 tin h\u01a1n khi thi mos v\u1edbi ph\u1ea7n thi\u1ebft l\u1eadp v\u00e0 \u00e1p d\u1ee5ng Named ranges r\u1ed3i \u0111\u00f3. Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng<strong> H\u1ecdc Excel Online<\/strong>, v\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo nh\u00e9!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-129.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10071,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10070","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=10070"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10070\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10071"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}