{"id":29,"date":"2025-09-07T15:49:12","date_gmt":"2025-09-07T08:49:12","guid":{"rendered":"https:\/\/teencode.vip\/blog\/?p=29"},"modified":"2025-09-07T15:49:13","modified_gmt":"2025-09-07T08:49:13","slug":"huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel","status":"publish","type":"post","link":"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o QR Code trong Excel v\u1edbi qrexcel.pro (nhanh, nh\u1eb9, chu\u1ea9n Excel)"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;29&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;3&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (3 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u01b0\u1edbng d\u1eabn t\u1ea1o QR Code trong Excel v\u1edbi qrexcel.pro (nhanh, nh\u1eb9, chu\u1ea9n Excel)&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (3 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#1_Vi_sao_nen_tao_QR_trong_Excel\" >1) V\u00ec sao n\u00ean t\u1ea1o QR trong Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#2_Yeu_cau_nhanh\" >2) Y\u00eau c\u1ea7u nhanh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#3_Cong_thuc_co_ban_mot_o_%E2%86%92_mot_QR\" >3) C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n (m\u1ed9t \u00f4 \u2192 m\u1ed9t QR)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#4_Tao_QR_hang_loat_keo_cong_thuc\" >4) T\u1ea1o QR h\u00e0ng lo\u1ea1t (k\u00e9o c\u00f4ng th\u1ee9c)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#5_Tuy_chinh_kich_thuoc_mau_co_ban\" >5) Tu\u1ef3 ch\u1ec9nh k\u00edch th\u01b0\u1edbc &amp; m\u00e0u (c\u01a1 b\u1ea3n)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#6_Dung_tren_Google_Sheets\" >6) D\u00f9ng tr\u00ean Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#7_Mau_ap_dung_thuc_te_copy_dung_ngay\" >7) M\u1eabu \u00e1p d\u1ee5ng th\u1ef1c t\u1ebf (copy d\u00f9ng ngay)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#a_QR_cho_lien_ket_tai_vi_du_link_tai_lieu_tren_website_ban\" >a) QR cho li\u00ean k\u1ebft t\u1ea3i (v\u00ed d\u1ee5: link t\u00e0i li\u1ec7u tr\u00ean website b\u1ea1n)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#b_QR_cho_ma_lolot_ghep_tu_nhieu_o\" >b) QR cho m\u00e3 l\u00f4\/lot (gh\u00e9p t\u1eeb nhi\u1ec1u \u00f4)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#c_QR_cho_vCard_danh_ba_dang_van_ban\" >c) QR cho vCard danh b\u1ea1 (d\u1ea1ng v\u0103n b\u1ea3n)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#8_Dinh_dang_in_an_cho_dep\" >8) \u0110\u1ecbnh d\u1ea1ng &amp; in \u1ea5n cho \u0111\u1eb9p<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#9_Kiem_tra_quet_QR\" >9) Ki\u1ec3m tra &amp; qu\u00e9t QR<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#10_Loi_thuong_gap_cach_xu_ly\" >10) L\u1ed7i th\u01b0\u1eddng g\u1eb7p &amp; c\u00e1ch x\u1eed l\u00fd<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#11_Meo_hay_cho_dan_van_phongkho\" >11) M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng\/kho<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/#12_Bao_mat_luu_y\" >12) B\u1ea3o m\u1eadt &amp; l\u01b0u \u00fd<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Vi_sao_nen_tao_QR_trong_Excel\"><\/span>1) V\u00ec sao n\u00ean t\u1ea1o QR trong Excel?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>T\u1ef1 \u0111\u1ed9ng theo d\u1eef li\u1ec7u<\/strong>: \u0111\u1ed5i n\u1ed9i dung \u00f4 \u2192 QR c\u1eadp nh\u1eadt ngay.<\/li>\n\n\n\n<li><strong>Kh\u00f4ng c\u00e0i ph\u1ea7n m\u1ec1m<\/strong>: ch\u1ec9 c\u1ea7n c\u00f4ng th\u1ee9c.<\/li>\n\n\n\n<li><strong>D\u00f9ng \u0111\u01b0\u1ee3c cho nhi\u1ec1u m\u1ee5c \u0111\u00edch<\/strong>: tem nh\u00e3n kho, m\u00e3 \u0111\u01a1n h\u00e0ng, link t\u1ea3i t\u00e0i li\u1ec7u, th\u00f4ng tin li\u00ean h\u1ec7, URL n\u1ed9i b\u1ed9, v.v.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Yeu_cau_nhanh\"><\/span>2) Y\u00eau c\u1ea7u nhanh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Excel cho Microsoft 365<\/strong> (h\u1ed7 tr\u1ee3 h\u00e0m <code>IMAGE<\/code>).<\/li>\n\n\n\n<li>K\u1ebft n\u1ed1i Internet (\u0111\u1ec3 Excel t\u1ea3i \u1ea3nh QR t\u1eeb qrexcel.pro).<\/li>\n\n\n\n<li>C\u1ed9t d\u1eef li\u1ec7u c\u1ea7n m\u00e3 ho\u00e1 (v\u00ed d\u1ee5: m\u00e3 h\u00e0ng, URL, s\u1ed1 seri\u2026).<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>N\u1ebfu b\u1ea1n d\u00f9ng Google Sheets, c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1\u2014m\u00ecnh ghi \u1edf ph\u1ea7n 6.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Cong_thuc_co_ban_mot_o_%E2%86%92_mot_QR\"><\/span>3) C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n (m\u1ed9t \u00f4 \u2192 m\u1ed9t QR)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Gi\u1ea3 s\u1eed n\u1ed9i dung c\u1ea7n t\u1ea1o QR n\u1eb1m \u1edf \u00f4 <strong>A2<\/strong>.<\/p>\n\n\n\n<p><strong>C\u00f4ng th\u1ee9c Excel (Microsoft 365):<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IMAGE(\"https:\/\/qrexcel.pro\/qr.php?d=\" &amp; ENCODEURL(A2) &amp; \"&amp;size=300x300\", \"QR qrexcel.pro\")\n<\/code><\/pre>\n\n\n\n<p><strong>Gi\u1ea3i th\u00edch tham s\u1ed1:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>d=<\/code> d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o (\u0111\u01b0\u1ee3c m\u00e3 ho\u00e1 an to\u00e0n b\u1eb1ng <code>ENCODEURL<\/code>).<\/li>\n\n\n\n<li><code>size=300x300<\/code> k\u00edch th\u01b0\u1edbc \u1ea3nh (r\u1ed9ng x cao, t\u00ednh theo pixel). B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ed5i sang <code>150x150<\/code>, <code>512x512<\/code>\u2026<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>M\u1eb9o: \u0111\u1eb7t <strong>chi\u1ec1u r\u1ed9ng c\u1ed9t<\/strong> \u2248 <strong>chi\u1ec1u cao h\u00e0ng<\/strong> \u0111\u1ec3 \u00f4 vu\u00f4ng \u0111\u1eb9p m\u1eaft (VD: c\u1ed9t ~50\u201360 px, h\u00e0ng ~50\u201360 px cho QR 300).<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Tao_QR_hang_loat_keo_cong_thuc\"><\/span>4) T\u1ea1o QR h\u00e0ng lo\u1ea1t (k\u00e9o c\u00f4ng th\u1ee9c)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Gi\u1ea3 s\u1eed danh s\u00e1ch d\u1eef li\u1ec7u \u1edf c\u1ed9t <strong>A<\/strong> t\u1eeb <strong>A2:A100<\/strong>. T\u1ea1i \u00f4 <strong>B2<\/strong> nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0 <strong>k\u00e9o xu\u1ed1ng<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IMAGE(\"https:\/\/qrexcel.pro\/qr.php?d=\" &amp; ENCODEURL(A2) &amp; \"&amp;size=300x300\", \"QR qrexcel.pro\")\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>M\u1ed7i d\u00f2ng t\u1ea1i c\u1ed9t <strong>B<\/strong> s\u1ebd l\u00e0 QR t\u01b0\u01a1ng \u1ee9ng v\u1edbi d\u00f2ng d\u1eef li\u1ec7u \u1edf <strong>A<\/strong>.<\/li>\n\n\n\n<li>\u0110\u1ec3 in \u0111\u1eb9p: ch\u1ecdn v\u00f9ng QR \u2192 <strong>Page Layout > Print Area > Set Print Area<\/strong> \u2192 xem tr\u01b0\u1edbc in.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_Tuy_chinh_kich_thuoc_mau_co_ban\"><\/span>5) Tu\u1ef3 ch\u1ec9nh k\u00edch th\u01b0\u1edbc &amp; m\u00e0u (c\u01a1 b\u1ea3n)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ed5i k\u00edch th\u01b0\u1edbc v\u00e0 m\u00e0u QR:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IMAGE(\n \"https:\/\/qrexcel.pro\/qr.php?d=\" &amp; ENCODEURL(A2) &amp;\n \"&amp;size=256x256\" &amp;\n \"&amp;color=000000\",     \/* m\u00e0u \u0111en (hex RGB) *\/\n \"QR qrexcel.pro\"\n)\n<\/code><\/pre>\n\n\n\n<p><strong>G\u1ee3i \u00fd:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>size=<\/code>: 150&#215;150, 256&#215;256, 300&#215;300, 512&#215;512\u2026<\/li>\n\n\n\n<li><code>color=<\/code>: m\u00e3 hex RGB kh\u00f4ng c\u00f3 d\u1ea5u # (v\u00ed d\u1ee5 <code>FF0000<\/code> l\u00e0 \u0111\u1ecf, <code>00AA66<\/code> l\u00e0 xanh ng\u1ecdc).<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>L\u01b0u \u00fd: \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o m\u00e1y qu\u00e9t d\u1ec5 \u0111\u1ecdc, n\u00ean gi\u1eef <strong>\u0111\u1ed9 t\u01b0\u01a1ng ph\u1ea3n cao<\/strong> (QR \u0111\u1eadm tr\u00ean n\u1ec1n s\u00e1ng).<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_Dung_tren_Google_Sheets\"><\/span>6) D\u00f9ng tr\u00ean <strong>Google Sheets<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00fa ph\u00e1p t\u01b0\u01a1ng \u0111\u01b0\u01a1ng (Sheets c\u0169ng c\u00f3 <code>IMAGE<\/code> &amp; <code>ENCODEURL<\/code>):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IMAGE(\"https:\/\/qrexcel.pro\/qr.php?d=\" &amp; ENCODEURL(A2) &amp; \"&amp;size=300x300\")\n<\/code><\/pre>\n\n\n\n<p><strong>T\u1ea1o h\u00e0ng lo\u1ea1t b\u1eb1ng ARRAYFORMULA (t\u1ef1 \u0111\u1ed5 c\u1ea3 c\u1ed9t):<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ARRAYFORMULA( IF(A2:A=\"\",, IMAGE(\"https:\/\/qrexcel.pro\/qr.php?d=\" &amp; ENCODEURL(A2:A) &amp; \"&amp;size=300x300\")) )\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_Mau_ap_dung_thuc_te_copy_dung_ngay\"><\/span>7) M\u1eabu \u00e1p d\u1ee5ng th\u1ef1c t\u1ebf (copy d\u00f9ng ngay)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"a_QR_cho_lien_ket_tai_vi_du_link_tai_lieu_tren_website_ban\"><\/span>a) QR cho <strong>li\u00ean k\u1ebft t\u1ea3i<\/strong> (v\u00ed d\u1ee5: link t\u00e0i li\u1ec7u tr\u00ean website b\u1ea1n)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>=IMAGE(\"https:\/\/qrexcel.pro\/qr.php?d=\" &amp; ENCODEURL(\"https:\/\/dl4drive.com\/file\/ten-tai-lieu\") &amp; \"&amp;size=300x300\")\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"b_QR_cho_ma_lolot_ghep_tu_nhieu_o\"><\/span>b) QR cho <strong>m\u00e3 l\u00f4\/lot<\/strong> (gh\u00e9p t\u1eeb nhi\u1ec1u \u00f4)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Gi\u1ea3 s\u1eed:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ng\u00e0y: <code>TEXT(C2,\"yymmdd\")<\/code><\/li>\n\n\n\n<li>Nh\u00e0 cung c\u1ea5p: <code>D2<\/code><\/li>\n\n\n\n<li>S\u1ed1 khu\u00f4n: <code>E2<\/code><\/li>\n\n\n\n<li>Ca l\u00e0m vi\u1ec7c: <code>F2<\/code><\/li>\n<\/ul>\n\n\n\n<p>T\u1ea1o chu\u1ed7i d\u1eef li\u1ec7u:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TEXT(C2,\"yymmdd\") &amp; D2 &amp; E2 &amp; F2\n<\/code><\/pre>\n\n\n\n<p>R\u1ed3i \u0111\u01b0a v\u00e0o QR:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IMAGE(\"https:\/\/qrexcel.pro\/qr.php?d=\" &amp; ENCODEURL(TEXT(C2,\"yymmdd\") &amp; D2 &amp; E2 &amp; F2) &amp; \"&amp;size=300x300\")\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"c_QR_cho_vCard_danh_ba_dang_van_ban\"><\/span>c) QR cho <strong>vCard danh b\u1ea1<\/strong> (d\u1ea1ng v\u0103n b\u1ea3n)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>(\u0110\u01a1n gi\u1ea3n ho\u00e1 v\u00ed d\u1ee5, xu\u1ed1ng d\u00f2ng b\u1eb1ng <code>CHAR(10)<\/code>)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=LET(\n v, \"BEGIN:VCARD\" &amp; CHAR(10) &amp;\n    \"VERSION:3.0\" &amp; CHAR(10) &amp;\n    \"FN:Tran Van Hoa\" &amp; CHAR(10) &amp;\n    \"TEL:+84889676186\" &amp; CHAR(10) &amp;\n    \"EMAIL:contact@teencode.vip\" &amp; CHAR(10) &amp;\n    \"END:VCARD\",\n IMAGE(\"https:\/\/qrexcel.pro\/qr.php?d=\" &amp; ENCODEURL(v) &amp; \"&amp;size=300x300\", \"QR vCard\")\n)\n<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Qu\u00e9t QR n\u00e0y tr\u00ean \u0111i\u1ec7n tho\u1ea1i s\u1ebd g\u1ee3i \u00fd l\u01b0u danh b\u1ea1.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8_Dinh_dang_in_an_cho_dep\"><\/span>8) \u0110\u1ecbnh d\u1ea1ng &amp; in \u1ea5n cho \u0111\u1eb9p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>C\u0103n gi\u1eefa \u1ea3nh<\/strong>: ch\u1ecdn c\u1ed9t ch\u1ee9a QR \u2192 <strong>Home > Alignment<\/strong> \u2192 Center (ngang) &amp; Middle (d\u1ecdc).<\/li>\n\n\n\n<li><strong>T\u1ec9 l\u1ec7 \u00f4 vu\u00f4ng<\/strong>: v\u00ed d\u1ee5 QR 300&#215;300 \u2192 \u0111\u1eb7t chi\u1ec1u r\u1ed9ng c\u1ed9t ~45\u201355, chi\u1ec1u cao h\u00e0ng ~160\u2013170 (tu\u1ef3 DPI m\u00e0n h\u00ecnh) \u0111\u1ec3 hi\u1ec3n th\u1ecb \u201cg\u1ea7n vu\u00f4ng\u201d.<\/li>\n\n\n\n<li><strong>In nhi\u1ec1u tem<\/strong>: d\u00f9ng <strong>Page Break Preview<\/strong> \u0111\u1ec3 canh s\u1ed1 nh\u00e3n m\u1ed7i trang.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"9_Kiem_tra_quet_QR\"><\/span>9) Ki\u1ec3m tra &amp; qu\u00e9t QR<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>D\u00f9ng camera m\u1eb7c \u0111\u1ecbnh tr\u00ean iOS\/Android ho\u1eb7c app \u0111\u1ecdc QR.<\/li>\n\n\n\n<li>Ki\u1ec3m tra v\u1edbi nhi\u1ec1u thi\u1ebft b\u1ecb (\u00e1nh s\u00e1ng y\u1ebfu\/m\u1ea1nh, kho\u1ea3ng c\u00e1ch xa\/g\u1ea7n).<\/li>\n\n\n\n<li>N\u1ebfu kh\u00f3 qu\u00e9t, th\u1eed:\n<ul class=\"wp-block-list\">\n<li>T\u0103ng k\u00edch th\u01b0\u1edbc (v\u00ed d\u1ee5 256 \u2192 300 ho\u1eb7c 512).<\/li>\n\n\n\n<li>D\u00f9ng m\u00e0u QR <strong>\u0111\u1eadm<\/strong> v\u00e0 n\u1ec1n <strong>s\u00e1ng<\/strong>.<\/li>\n\n\n\n<li>Tr\u00e1nh \u0111\u1eb7t logo\/ho\u1ea1 ti\u1ebft \u0111\u00e8 l\u00ean v\u00f9ng m\u00e3.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"10_Loi_thuong_gap_cach_xu_ly\"><\/span>10) L\u1ed7i th\u01b0\u1eddng g\u1eb7p &amp; c\u00e1ch x\u1eed l\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u1ea2nh kh\u00f4ng hi\u1ec7n<\/strong>: ki\u1ec3m tra Internet; th\u1eed m\u1edf URL t\u1ea1o b\u1edfi c\u00f4ng th\u1ee9c trong tr\u00ecnh duy\u1ec7t.<\/li>\n\n\n\n<li><strong>D\u1eef li\u1ec7u c\u00f3 d\u1ea5u, kho\u1ea3ng tr\u1eafng, k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t<\/strong>: b\u1eaft bu\u1ed9c d\u00f9ng <code>ENCODEURL(...)<\/code>.<\/li>\n\n\n\n<li><strong>\u00d4 hi\u1ec3n th\u1ecb \u201c#VALUE!\u201d<\/strong>: phi\u00ean b\u1ea3n Excel kh\u00f4ng h\u1ed7 tr\u1ee3 <code>IMAGE<\/code>.\n<ul class=\"wp-block-list\">\n<li><strong>C\u00e1ch thay th\u1ebf (ng\u1eafn g\u1ecdn)<\/strong>: d\u00f9ng Excel 2019 tr\u1edf xu\u1ed1ng \u2192 t\u1ea1o URL QR b\u1eb1ng c\u00f4ng th\u1ee9c, sau \u0111\u00f3 <strong>Copy<\/strong> URL \u2192 <strong>Insert > Pictures > This Device<\/strong> (t\u1ea3i \u1ea3nh t\u1eeb URL tr\u01b0\u1edbc) ho\u1eb7c d\u00f9ng Power Query\/VBA \u0111\u1ec3 n\u1ea1p \u1ea3nh (gi\u1ea3i ph\u00e1p n\u00e2ng cao).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11_Meo_hay_cho_dan_van_phongkho\"><\/span>11) M\u1eb9o hay cho d\u00e2n v\u0103n ph\u00f2ng\/kho<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Tem k\u1ec7 h\u00e0ng<\/strong>: m\u1ed7i m\u00e3 k\u1ec7 l\u00e0 m\u1ed9t QR \u2192 qu\u00e9t \u0111\u1ec3 m\u1edf chi ti\u1ebft t\u1ed3n kho.<\/li>\n\n\n\n<li><strong>Phi\u1ebfu giao vi\u1ec7c<\/strong>: QR d\u1eabn \u0111\u1ebfn Google Form ho\u1eb7c file h\u01b0\u1edbng d\u1eabn.<\/li>\n\n\n\n<li><strong>Ho\u00e1 \u0111\u01a1n\/phi\u1ebfu xu\u1ea5t<\/strong>: QR ch\u1ee9a URL tra c\u1ee9u ch\u1ee9ng t\u1eeb.<\/li>\n\n\n\n<li><strong>S\u1ea3n xu\u1ea5t\/QA<\/strong>: gh\u00e9p nhi\u1ec1u tr\u01b0\u1eddng (ng\u00e0y-th\u00e1ng, ca, m\u00e1y, khu\u00f4n, lot\u2026) th\u00e0nh m\u1ed9t chu\u1ed7i r\u1ed3i chuy\u1ec3n th\u00e0nh QR \u0111\u1ec3 truy v\u1ebft nhanh.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12_Bao_mat_luu_y\"><\/span>12) B\u1ea3o m\u1eadt &amp; l\u01b0u \u00fd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ch\u1ec9 nh\u00fang <strong>n\u1ed9i dung c\u1ea7n thi\u1ebft<\/strong> v\u00e0o QR (tr\u00e1nh th\u00f4ng tin nh\u1ea1y c\u1ea3m).<\/li>\n\n\n\n<li>V\u1edbi URL n\u1ed9i b\u1ed9, c\u00e2n nh\u1eafc d\u00f9ng <strong>li\u00ean k\u1ebft r\u00fat g\u1ecdn c\u00f3 ki\u1ec3m so\u00e1t truy c\u1eadp<\/strong>.<\/li>\n\n\n\n<li>QR l\u00e0 \u1ea3nh t\u0129nh\u2014mu\u1ed1n v\u00f4 hi\u1ec7u ho\u00e1, h\u00e3y <strong>\u0111\u1ed5i n\u1ed9i dung li\u00ean k\u1ebft<\/strong> \u1edf ph\u00eda m\u00e1y ch\u1ee7.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>S\u1eed d\u1ee5ng <strong>qrexcel.pro<\/strong> gi\u00fap b\u1ea1n t\u1ea1o QR ngay trong Excel\/Sheets ch\u1ec9 b\u1eb1ng <strong>m\u1ed9t d\u00f2ng c\u00f4ng th\u1ee9c<\/strong>, c\u1ef1c nhanh v\u00e0 linh ho\u1ea1t. H\u00e3y th\u1eed:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=IMAGE(\"https:\/\/qrexcel.pro\/qr.php?d=\" &amp; ENCODEURL(A2) &amp; \"&amp;size=300x300\")\n<\/code><\/pre>\n\n\n\n<p>Sau \u0111\u00f3 k\u00e9o c\u00f4ng th\u1ee9c cho c\u1ea3 danh s\u00e1ch\u2014b\u1ea1n s\u1ebd c\u00f3 ngay <strong>b\u1ed9 QR s\u1eb5n s\u00e0ng in<\/strong> cho tem nh\u00e3n, kho, s\u1ea3n xu\u1ea5t, ho\u1eb7c t\u00e0i li\u1ec7u chia s\u1ebb.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1) V\u00ec sao n\u00ean t\u1ea1o QR trong Excel? 2) Y\u00eau c\u1ea7u nhanh N\u1ebfu b\u1ea1n d\u00f9ng Google Sheets, c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1\u2014m\u00ecnh ghi \u1edf ph\u1ea7n 6. 3) C\u00f4ng th\u1ee9c c\u01a1 b\u1ea3n (m\u1ed9t \u00f4 \u2192 m\u1ed9t QR) Gi\u1ea3 s\u1eed n\u1ed9i dung c\u1ea7n t\u1ea1o QR n\u1eb1m \u1edf \u00f4 A2. C\u00f4ng th\u1ee9c Excel (Microsoft 365): Gi\u1ea3i th\u00edch tham s\u1ed1: &#8230; <a title=\"H\u01b0\u1edbng d\u1eabn t\u1ea1o QR Code trong Excel v\u1edbi qrexcel.pro (nhanh, nh\u1eb9, chu\u1ea9n Excel)\" class=\"read-more\" href=\"https:\/\/teencode.vip\/blog\/huong-dan-tao-qr-code-trong-excel-voi-qrexcel-pro-nhanh-nhe-chuan-excel\/\" aria-label=\"\u0110\u1ecdc th\u00eam v\u1ec1 H\u01b0\u1edbng d\u1eabn t\u1ea1o QR Code trong Excel v\u1edbi qrexcel.pro (nhanh, nh\u1eb9, chu\u1ea9n Excel)\">\u0110\u1ecdc ti\u1ebfp<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mo_disable_npp":"","pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[26],"tags":[29,31,27,30,32,28],"class_list":["post-29","post","type-post","status-publish","format-standard","hentry","category-cntt","tag-qr-excel","tag-qrcode","tag-tao-qr","tag-tao-qr-code-hang-loat-tren-excel","tag-tao-qr-code-tren-excel","tag-tao-qr-tren-excel"],"_links":{"self":[{"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/posts\/29","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/comments?post=29"}],"version-history":[{"count":1,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":30,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/posts\/29\/revisions\/30"}],"wp:attachment":[{"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/media?parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/categories?post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/tags?post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}