{"id":9889,"date":"2025-01-04T01:20:19","date_gmt":"2025-01-04T01:20:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/04\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar\/"},"modified":"2025-01-04T01:20:19","modified_gmt":"2025-01-04T01:20:19","slug":"quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/04\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar\/","title":{"rendered":"Quick Access Toolbar l\u00e0 g\u00ec? T\u1ea1i sao l\u1ea1i ph\u1ea3i d\u00f9ng Quick Access Toolbar?"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\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-67788cd2a94f6\" 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-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Quick_Access_Toolbar_la_gi\" title=\"Quick Access Toolbar l\u00e0 g\u00ec?\">Quick Access Toolbar l\u00e0 g\u00ec?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Cach_them_nut_lenh_vao_Quick_Access_Toolbar\" title=\"C\u00e1ch th\u00eam n\u00fat l\u1ec7nh v\u00e0o Quick Access Toolbar\">C\u00e1ch th\u00eam n\u00fat l\u1ec7nh v\u00e0o Quick Access Toolbar<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Cach_them_cac_nut_lenh_khong_co_san_trong_thanh_Ribbon\" title=\"C\u00e1ch th\u00eam c\u00e1c n\u00fat l\u1ec7nh kh\u00f4ng c\u00f3 s\u1eb5n trong thanh Ribbon.\">C\u00e1ch th\u00eam c\u00e1c n\u00fat l\u1ec7nh kh\u00f4ng c\u00f3 s\u1eb5n trong thanh Ribbon.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Cach_xoa_bo_nut_lenh_khoi_Quick_Access_Toolbar\" title=\"C\u00e1ch x\u00f3a b\u1ecf n\u00fat l\u1ec7nh kh\u1ecfi Quick Access Toolbar\">C\u00e1ch x\u00f3a b\u1ecf n\u00fat l\u1ec7nh kh\u1ecfi Quick Access Toolbar<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Thay_doi_vi_tri_cac_nut_lenh_trong_Quick_Access_Toolbar\" title=\"Thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c n\u00fat l\u1ec7nh trong Quick Access Toolbar\">Thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c n\u00fat l\u1ec7nh trong Quick Access Toolbar<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Cach_them_phan_tach_nhom_cac_nut_lenh_voi_Separator_va_Tuy_bien_Quick_Access_Toolbar_tu_Options\" title=\"C\u00e1ch th\u00eam ph\u00e2n t\u00e1ch nh\u00f3m c\u00e1c n\u00fat l\u1ec7nh v\u1edbi Separator v\u00e0\u00a0T\u00f9y bi\u1ebfn Quick Access Toolbar t\u1eeb Options\">C\u00e1ch th\u00eam ph\u00e2n t\u00e1ch nh\u00f3m c\u00e1c n\u00fat l\u1ec7nh v\u1edbi Separator v\u00e0\u00a0T\u00f9y bi\u1ebfn Quick Access Toolbar t\u1eeb Options<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Cach_thiet_lap_lai_thanh_Quick_Access_Toolbar_ve_nguyen_trang_ban_dau_Reset_Quick_Access_Toolbar\" title=\"C\u00e1ch thi\u1ebft l\u1eadp l\u1ea1i thanh Quick Access Toolbar v\u1ec1 nguy\u00ean tr\u1ea1ng ban \u0111\u1ea7u (Reset Quick Access Toolbar)\">C\u00e1ch thi\u1ebft l\u1eadp l\u1ea1i thanh Quick Access Toolbar v\u1ec1 nguy\u00ean tr\u1ea1ng ban \u0111\u1ea7u (Reset Quick Access Toolbar)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Cach_them_nut_lenh_goi_Macro_VBA_va_tuy_chinh_bieu_tuong_cho_nut_lenh\" title=\"C\u00e1ch th\u00eam n\u00fat l\u1ec7nh g\u1ecdi Macro VBA v\u00e0 t\u00f9y ch\u1ec9nh bi\u1ec3u t\u01b0\u1ee3ng cho n\u00fat l\u1ec7nh\">C\u00e1ch th\u00eam n\u00fat l\u1ec7nh g\u1ecdi Macro VBA v\u00e0 t\u00f9y ch\u1ec9nh bi\u1ec3u t\u01b0\u1ee3ng cho n\u00fat l\u1ec7nh<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Buoc_1_Chon_Ghi_macro_va_cac_thiet_lap_ban_dau\" title=\"B\u01b0\u1edbc 1:\u00a0Ch\u1ecdn Ghi macro v\u00e0 c\u00e1c thi\u1ebft l\u1eadp ban \u0111\u1ea7u\">B\u01b0\u1edbc 1:\u00a0Ch\u1ecdn Ghi macro v\u00e0 c\u00e1c thi\u1ebft l\u1eadp ban \u0111\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Buoc_2_Thuc_hien_cac_thao_tac_de_Macro_ghi_lai\" title=\"B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c \u0111\u1ec3 Macro ghi l\u1ea1i.\">B\u01b0\u1edbc 2: Th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c \u0111\u1ec3 Macro ghi l\u1ea1i.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Buoc_3_Mo_cua_so_lap_trinh_VBA_va_tim_module_da_ghi_trong_Project_Personalxlsb\" title=\"B\u01b0\u1edbc 3: M\u1edf c\u1eeda s\u1ed5 l\u1eadp tr\u00ecnh VBA, v\u00e0 t\u00ecm\u00a0module \u0111\u00e3 ghi trong Project Personal.xlsb\">B\u01b0\u1edbc 3: M\u1edf c\u1eeda s\u1ed5 l\u1eadp tr\u00ecnh VBA, v\u00e0 t\u00ecm\u00a0module \u0111\u00e3 ghi trong Project Personal.xlsb<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Buoc_4_Chinh_sua_noi_dung_doan_code_VBA\" title=\"B\u01b0\u1edbc 4: Ch\u1ec9nh s\u1eeda n\u1ed9i dung \u0111o\u1ea1n code VBA.\">B\u01b0\u1edbc 4: Ch\u1ec9nh s\u1eeda n\u1ed9i dung \u0111o\u1ea1n code VBA.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Buoc_5_Gan_Macro_PasteValue_Transpose_vao_Quick_Access_Toolbar\" title=\"B\u01b0\u1edbc 5: G\u00e1n Macro PasteValue_Transpose v\u00e0o Quick Access Toolbar.\">B\u01b0\u1edbc 5: G\u00e1n Macro PasteValue_Transpose v\u00e0o Quick Access Toolbar.<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/quick-access-toolbar-la-gi-tai-sao-lai-phai-dung-quick-access-toolbar.html#Loi_ket_Tai_sao_lai_phai_dung_Quick_Access_Toolbar\" title=\"L\u1eddi k\u1ebft: T\u1ea1i sao l\u1ea1i ph\u1ea3i d\u00f9ng Quick Access Toolbar?\">L\u1eddi k\u1ebft: T\u1ea1i sao l\u1ea1i ph\u1ea3i d\u00f9ng Quick Access Toolbar?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Quick_Access_Toolbar_la_gi\"><\/span>Quick Access Toolbar l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Quick Access Toolbar l\u00e0 thanh c\u00f4ng c\u1ee5 ch\u1ee9a nh\u1eefng n\u00fat l\u1ec7nh t\u00f9y bi\u1ebfn gi\u00fap b\u1ea1n ch\u1ecdn nhanh trong giao di\u1ec7n c\u00e1c \u1ee9ng d\u1ee5ng c\u1ee7a Microsoft, nh\u01b0 Microsoft Windows v\u1edbi My Computer (Windows Explorer) hay Microsoft Office (bao g\u1ed3m Word, Excel, PowerPoint, Outlook\u2026).<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/quickaccesstoolbar-hocexcelonline.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22847\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/quickaccesstoolbar-hocexcelonline.jpg\" width=\"1002\" height=\"431\" title=\"quickaccesstoolbar-hocexcelonline\"><\/a><\/p>\n<p>C\u00f3 th\u1ec3 t\u00f9y ch\u1ecdn n\u1eb1m \u1edf 2 v\u1ecb tr\u00ed g\u1ea7n thanh Ribbon (thanh Ribbon l\u00e0 thanh menu g\u1ed3m c\u00e1c tab l\u1ec7nh: File, Home\u2026.)<\/p>\n<ol>\n<li>Ngay b\u00ean tr\u00ean thanh\u00a0Ribbon\u00a0(Show Above the Ribbon) \u2013 n\u1eb1m c\u00f9ng v\u1ecb tr\u00ed v\u1edbi ti\u00eau \u0111\u1ec1 file \u2013 t\u00ean \u1ee9ng d\u1ee5ng.<\/li>\n<li>Ngay b\u00ean d\u01b0\u1edbi\u00a0thanh Ribbon\u00a0(Show Below the Ribbon) \u2013 n\u1eb1m b\u00ean d\u01b0\u1edbi thanh Ribbon, v\u00e0 ngay ph\u00eda tr\u00ean thanh c\u00f4ng th\u1ee9c Fx.<\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"Cach_them_nut_lenh_vao_Quick_Access_Toolbar\"><\/span>C\u00e1ch th\u00eam n\u00fat l\u1ec7nh v\u00e0o Quick Access Toolbar<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u00ed d\u1ee5 b\u1ea1n c\u1ea7n th\u00eam n\u00fat <strong>Evaluate Formula<\/strong>\u00a0(ph\u1ea7n ki\u1ec3m tra\/debug c\u00f4ng th\u1ee9c r\u1ea5t hay m\u00e0 \u00edt ng\u01b0\u1eddi bi\u1ebft t\u1edbi) v\u00e0o Quick Access Toolbar<\/p>\n<ol>\n<li>Ch\u1ecdn tab ch\u1ecdn tab Formulas, n\u01a1i ch\u1ee9a n\u00fat l\u1ec7nh c\u1ea7n th\u00eam v\u00e0o Quick Access Toolbar.<\/li>\n<li>Click ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng c\u1ee7a Evaluate Formula, ch\u1ecdn Add to Quick Access\u00a0 Toolbar.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/them-nut-lenh-vao-quick-access-toolbar.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22848\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/them-nut-lenh-vao-quick-access-toolbar.jpg\" width=\"734\" height=\"198\" title=\"them-nut-lenh-vao-quick-access-toolbar\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_them_cac_nut_lenh_khong_co_san_trong_thanh_Ribbon\"><\/span>C\u00e1ch th\u00eam c\u00e1c n\u00fat l\u1ec7nh kh\u00f4ng c\u00f3 s\u1eb5n trong thanh Ribbon.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ed1i v\u1edbi c\u00e1c n\u00fat l\u1ec7nh kh\u00f4ng c\u00f3 s\u1eb5n tr\u00ean thanh Ribbon, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u0169i t\u00ean xu\u1ed1ng ngo\u00e0i c\u00f9ng b\u00ean ph\u1ea3i c\u1ee7a thanh Quick Access Toolbar, v\u00e0 ch\u1ecdn <strong>More Commands\u2026<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/quick-access-toolbar-more-commands.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22850\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/quick-access-toolbar-more-commands.jpg\" width=\"543\" height=\"434\" title=\"quick-access-toolbar-more-commands\"><\/a><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-2.gif\" title=\"vba101_92019-nho-2\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-105.gif\" title=\"ex101_92019-nho-105\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Cach_xoa_bo_nut_lenh_khoi_Quick_Access_Toolbar\"><\/span>C\u00e1ch x\u00f3a b\u1ecf n\u00fat l\u1ec7nh kh\u1ecfi Quick Access Toolbar<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u00f4i l\u00fac c\u00f3 c\u00e1c n\u00fat l\u1ec7nh, b\u1ea1n th\u1ea5y \u00edt d\u00f9ng t\u1edbi, v\u00e0 mu\u1ed1n b\u1ecf \u0111i \u0111\u1ec3 cho g\u1ecdn ho\u1eb7c th\u00eam n\u00fat m\u1edbi v\u00e0o. B\u1ea1n c\u00f3 th\u1ec3 click ph\u1ea3i v\u00e0o n\u00fat l\u1ec7nh (command), v\u00e0 ch\u1ecdn Remove from Quick Access Toolbar.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/remove-from-quick-access-toolbar.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22849\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/remove-from-quick-access-toolbar.jpg\" width=\"693\" height=\"169\" title=\"remove-from-quick-access-toolbar\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Thay_doi_vi_tri_cac_nut_lenh_trong_Quick_Access_Toolbar\"><\/span>Thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c n\u00fat l\u1ec7nh trong Quick Access Toolbar<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong ph\u1ea7n Excel Options, ph\u1ea7n Quick Access Toolbar (khi b\u1ea1n ch\u1ecdn More Commands b\u00ean ph\u1ea7n tr\u00ean), b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn n\u00fat l\u1ec7nh c\u1ea7n di chuy\u1ec3n v\u1ecb tr\u00ed, v\u00e0 ch\u1ecdn n\u00fat m\u0169i t\u00ean l\u00ean\/xu\u1ed1ng \u0111\u1ec3 di chuy\u1ec3n v\u1ecb tr\u00ed t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 trong m\u1ee5c n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam c\u00e1c n\u00fat l\u1ec7nh kh\u00e1c, b\u1eb1ng <strong>Add &gt;&gt;<\/strong>.\u00a0 Ho\u1eb7c g\u1ee1 b\u1ecf n\u00fat l\u1ec7nh kh\u1ecfi Quick Access Toolbar, b\u1eb1ng c\u00e1ch ch\u1ecdn n\u00fat l\u1ec7nh v\u00e0 ch\u1ecdn <strong>&lt;&lt; Remove<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/up-down.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22852\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/up-down.jpg\" width=\"1156\" height=\"405\" title=\"up-down\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_them_phan_tach_nhom_cac_nut_lenh_voi_Separator_va_Tuy_bien_Quick_Access_Toolbar_tu_Options\"><\/span>C\u00e1ch th\u00eam ph\u00e2n t\u00e1ch nh\u00f3m c\u00e1c n\u00fat l\u1ec7nh v\u1edbi Separator v\u00e0\u00a0T\u00f9y bi\u1ebfn Quick Access Toolbar t\u1eeb Options<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u00ed d\u1ee5 v\u1edbi \u1ea3nh minh h\u1ecda b\u00ean d\u01b0\u1edbi, ch\u00fang ta c\u00f3 th\u1ec3 th\u00eam d\u1ea5u g\u1ea1ch ph\u00e2n t\u00e1ch nh\u00f3m c\u00e1c n\u00fat l\u1ec7nh tr\u00ean thanh Quick Access Toolbar gi\u00fap c\u00e1c n\u00fat l\u1ec7nh chia t\u00e1ch ra, v\u00e0 tr\u00e1nh click nh\u1ea7m sai s\u00f3t.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/separator-quick-access-toolbar-group.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22854 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/separator-quick-access-toolbar-group.jpg\" width=\"536\" height=\"387\" title=\"separator-quick-access-toolbar-group\"><\/a><\/p>\n<p>\u0110\u1ec3 th\u00eam d\u1ea5u ph\u00e2n t\u00e1ch nh\u00f3m Separator trong Quick Access Toolbar, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn <strong>Popular Commands<\/strong> \u1edf ph\u1ea7n<strong> Choose command from:<\/strong>, b\u1ea1n s\u1ebd th\u1ea5y <strong>&lt;Separator&gt;<\/strong> \u0111\u01b0\u1ee3c \u1edf n\u00fat l\u1ec7nh \u0111\u1ea7u ti\u00ean. B\u1ea1n ch\u1ecdn n\u00fat l\u1ec7nh, v\u00e0 ch\u1ecdn Add &gt;&gt;, sau \u0111\u00f3 ch\u1ecdn l\u00ean\/xu\u1ed1ng \u0111\u1ec3 \u0111\u1eb7t v\u1ecb tr\u00ed ph\u00f9 h\u1ee3p.<\/p>\n<p>Ngo\u00e0i danh s\u00e1ch Popular Commands, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nh\u00f3m l\u1ec7nh theo tabs ch\u1ee9c n\u0103ng, ho\u1eb7c ch\u1ecdn All Commands \u0111\u1ec3 xem t\u1ea5t c\u1ea3 c\u00e1c n\u00fat l\u1ec7nh theo th\u1ee9 t\u1ef1 ABC c\u00f3 th\u1ec3 th\u00eam v\u00e0o Quick Access Toolbar. Khi li\u1ec7t k\u00ea, b\u1ea1n c\u00f3 th\u1ec3 g\u00f5 t\u1eeb \u0111\u1ea7u ti\u00ean c\u1ee7a t\u00ean n\u00fat l\u1ec7nh \u0111\u1ec3 t\u00ecm cho nhanh.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/separator-quick-access-toolbar.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22853 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/separator-quick-access-toolbar.jpg\" width=\"836\" height=\"688\" title=\"separator-quick-access-toolbar\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_thiet_lap_lai_thanh_Quick_Access_Toolbar_ve_nguyen_trang_ban_dau_Reset_Quick_Access_Toolbar\"><\/span>C\u00e1ch thi\u1ebft l\u1eadp l\u1ea1i thanh Quick Access Toolbar v\u1ec1 nguy\u00ean tr\u1ea1ng ban \u0111\u1ea7u (Reset Quick Access Toolbar)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Khi Quick Access Toolbar, \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp l\u1ed9n x\u1ed9n b\u1edfi ai \u0111\u00f3, ho\u1eb7c \u0111\u01a1n gi\u1ea3n b\u1ea1n mu\u1ed1n cho thanh Quick Access Toolbar t\u01b0\u01a1i m\u1edbi h\u01a1n. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn n\u00fat <strong>Reset<\/strong>, v\u00e0 ch\u1ecdn <strong>Reset only Quick Access Toolbar<\/strong>.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/reset-quick-access-toolbar.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22856 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/reset-quick-access-toolbar.jpg\" width=\"836\" height=\"688\" title=\"reset-quick-access-toolbar\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cach_them_nut_lenh_goi_Macro_VBA_va_tuy_chinh_bieu_tuong_cho_nut_lenh\"><\/span>C\u00e1ch th\u00eam n\u00fat l\u1ec7nh g\u1ecdi Macro VBA v\u00e0 t\u00f9y ch\u1ec9nh bi\u1ec3u t\u01b0\u1ee3ng cho n\u00fat l\u1ec7nh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00f3 b\u1ea1n \u0111\u00e3 h\u1ecfi r\u1eb1ng, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 th\u00eam n\u00fat l\u1ec7nh c\u00f3 ch\u1ee9c n\u0103ng <strong>Paste Value<\/strong> &amp; \u0111\u1ed3ng th\u1eddi <strong>Transpose<\/strong> lu\u00f4n k\u1ebft qu\u1ea3 (ch\u1ee9c n\u0103ng n\u00e0y c\u00f3 trong ph\u1ea7n <strong>Paste Special<\/strong>) nh\u01b0ng l\u1ea1i kh\u00f4ng c\u00f3 s\u1eb5n trong danh s\u00e1ch All Commands \u0111\u1ec3 th\u00eam v\u00e0o Quick Access Toolbar. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 th\u00eam n\u00fat l\u1ec7nh \u0111\u00f3 gi\u00fap b\u1ea1n thao t\u00e1c nhanh h\u01a1n trong c\u00f4ng vi\u1ec7c?<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/add-paste-value-transpose-paste-special-quick-access-toolbar.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22858 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/add-paste-value-transpose-paste-special-quick-access-toolbar.jpg\" width=\"942\" height=\"383\" title=\"add-paste-value-transpose-paste-special-quick-access-toolbar\"><\/a><\/p>\n<p>C\u00e1ch l\u00e0m kh\u00e1 \u0111\u01a1n gi\u1ea3n, c\u0169ng kh\u00f4ng \u0111\u00f2i h\u1ecfi b\u1ea1n ph\u1ea3i c\u00f3 k\u1ef9 n\u0103ng l\u1eadp tr\u00ecnh VBA, h\u00e3y s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Record Macro \u0111\u1ec3 ghi l\u1ea1i thao t\u00e1c VBA, v\u00e0 khi c\u1ea7n ch\u00fang ta ch\u1ec9 vi\u1ec7c g\u1ecdi l\u1ec7nh Macro VBA \u0111\u00f3 ra l\u00e0 xong. B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft: <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tu-hoc-vba-hieu-qua-voi-chuc-nang-record-macro.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ef1 h\u1ecdc VBA th\u00f4ng qua Record Macro<\/strong><\/a>.<\/p>\n<p>C\u00e1ch l\u00e0m tu\u1ea7n t\u1ef1 nh\u01b0 sau:<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Buoc_1_Chon_Ghi_macro_va_cac_thiet_lap_ban_dau\"><\/span><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0Ch\u1ecdn Ghi macro v\u00e0 c\u00e1c thi\u1ebft l\u1eadp ban \u0111\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ol>\n<li>B\u1ea1n ch\u1ecdn <strong>Record Macro <\/strong>t\u1eeb th\u1ebb<strong> Developer<\/strong>.<\/li>\n<li>Sau \u0111\u00f3 \u0111\u1eb7t t\u00ean cho Macro name t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<li>G\u00e1n Shortcut Key (ph\u00edm t\u1eaft n\u00f3ng) v\u00ed d\u1ee5 \u0111\u1ec3 g\u00e1n ph\u00edm CTRL+SHIFT+V th\u00ec m\u00ecnh s\u1ebd nh\u1ea5n SHIFT+V.<\/li>\n<li>Ch\u1ecdn ph\u1ea7n <strong>Store macro in<\/strong> l\u00e0:\u00a0<strong>Personal Macro Workbook<\/strong>. V\u00ec l\u01b0u v\u00e0o \u0111\u00e2y, m\u1ed7i khi b\u1ea1n kh\u1edfi \u0111\u1ed9ng Excel th\u00ec file Personal Macro Workbook c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c kh\u1edfi \u0111\u1ed9ng c\u00f9ng. N\u1ebfu b\u1ea1n ch\u1ecdn kh\u00e1c \u0111i th\u00ec ch\u1ec9 n\u1eb1m \u1edf Workbook b\u1ea1n ch\u1ecdn.<\/li>\n<li>Sau \u0111\u00f3 ph\u1ea7n Ghi ch\u00fa (Description), b\u1ea1n c\u00f3 th\u1ec3 ch\u00fa th\u00edch,\u00a0do\u00a0VBA ch\u01b0a h\u1ed7 tr\u1ee3 t\u1ed1t Unicode, n\u00ean b\u1ea1n s\u1ebd ph\u1ea3i g\u00f5 ti\u1ebfng Vi\u1ec7t kh\u00f4ng d\u1ea5u.<\/li>\n<li>V\u00e0 cu\u1ed1i c\u00f9ng ch\u1ecdn <strong>OK<\/strong>, l\u00fac n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 d\u1eebng l\u1ea1i, kh\u00f4ng ch\u1ecdn hay l\u00e0m b\u1ea5t k\u1ef3 \u0111i\u1ec1u g\u00ec trong Excel. L\u00fac n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y n\u00fat Record Macro, chuy\u1ec3n tr\u1ea1ng th\u00e1i th\u00e0nh: <strong>Stop Recording\u2026\u00a0<\/strong><\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/record-macro-name-shortcut-key-macro.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22859\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/record-macro-name-shortcut-key-macro.jpg\" width=\"794\" height=\"562\" title=\"record-macro-name-shortcut-key-macro\"><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"Buoc_2_Thuc_hien_cac_thao_tac_de_Macro_ghi_lai\"><\/span><strong>B\u01b0\u1edbc 2:<\/strong> Th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c \u0111\u1ec3 Macro ghi l\u1ea1i.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>1. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea5t k\u1ef3, kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i c\u00f3 d\u1eef li\u1ec7u, v\u00e0 ch\u1ecdn COPY (b\u1eb1ng c\u00e1ch nh\u1ea5n CTRL+C)<\/p>\n<p>2. Ti\u1ebfp t\u1ee5c, click ph\u1ea3i v\u00e0o \u00f4 d\u1eef li\u1ec7u b\u1ea5t k\u1ef3, v\u00e0 <strong>ch\u1ecdn Paste Special\u2026<\/strong><\/p>\n<p>3. C\u1eeda s\u1ed5 <strong>Paste Special\u2026<\/strong> hi\u1ec7n ra, b\u1ea1n ch\u1ecdn [x] Values, v\u00e0 ch\u1ecdn [x] Transpose, sau \u0111\u00f3 nh\u1ea5n OK.<\/p>\n<p>4. Sau \u0111\u00f3, b\u1ea1n ch\u1ecdn <strong>Stop Recording<\/strong> \u0111\u1ec3 ng\u1eebng ghi Macro.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/step-1-2-Copy-Paste-Special-Values-Transpose.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22862\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/step-1-2-copy-paste-special-values-transpose.jpg\" width=\"1345\" height=\"467\" title=\"step-1-2-copy-paste-special-values-transpose\"><\/a><\/p>\n<p><strong>Ghi ch\u00fa:<\/strong> N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ed5i ph\u00edm t\u1eaft \u0111\u00e3 g\u00e1n cho Macro, th\u00ec b\u1ea1n ch\u1ecdn v\u00e0o Macros [1] \u1edf tab Developer, v\u00e0 ch\u1ecdn t\u00ean Macro, sau \u0111\u00f3 ch\u1ecdn Options [2], v\u00e0 thay \u0111\u1ed5i [3] ph\u00edm t\u1eaft ph\u00f9 h\u1ee3p h\u01a1n cho b\u1ea1n.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/macro-options-shortcutkey.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22870\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/macro-options-shortcutkey.jpg\" width=\"873\" height=\"539\" title=\"macro-options-shortcutkey\"><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"Buoc_3_Mo_cua_so_lap_trinh_VBA_va_tim_module_da_ghi_trong_Project_Personalxlsb\"><\/span>B\u01b0\u1edbc 3: M\u1edf c\u1eeda s\u1ed5 l\u1eadp tr\u00ecnh VBA, v\u00e0 t\u00ecm\u00a0module \u0111\u00e3 ghi trong Project Personal.xlsb<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ol>\n<li>B\u1ea1n nh\u1ea5n ALT+F11, ho\u1eb7c ch\u1ecdn tab Developer, v\u00e0 ch\u1ecdn Visual Basic.<\/li>\n<li>L\u00fac n\u00e0y c\u1eeda s\u1ed5 l\u1eadp tr\u00ecnh VBA s\u1ebd m\u1edf ra. B\u1ea1n ch\u1ecdn menu View -&gt; Project Explorer (ho\u1eb7c nh\u1ea5n\u00a0CTRL+R), l\u00fac n\u00e0y b\u1ea1n s\u1ebd th\u1ea5y Project c\u00f3 t\u00ean l\u00e0 <strong>Personal.xlsb. <\/strong>B\u1ea1n click\u00a0m\u1edf ph\u1ea7n <strong>Modules<\/strong>, v\u00e0 <strong>click nhanh 2 l\u1ea7n (double click)<\/strong>\u00a0v\u00e0o <strong>Module1<\/strong><\/li>\n<li>L\u00fac n\u00e0y b\u1ea1n s\u1ebd th\u1ea5y c\u1eeda s\u1ed5 code VBA hi\u1ec7n ra, \u0111o\u1ea1n code ch\u1ee9a n\u1ed9i dung b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n \u1edf b\u01b0\u1edbc 2.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/vba-alt-f11-project-module-personal-macro.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22864\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba-alt-f11-project-module-personal-macro.jpg\" width=\"1195\" height=\"582\" title=\"vba-alt-f11-project-module-personal-macro\"><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"Buoc_4_Chinh_sua_noi_dung_doan_code_VBA\"><\/span>B\u01b0\u1edbc 4: Ch\u1ec9nh s\u1eeda n\u1ed9i dung \u0111o\u1ea1n code VBA.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ol>\n<li>B\u1ea1n s\u1ebd th\u1ea5y n\u1ed9i dung \u0111o\u1ea1n code b\u00ean d\u01b0\u1edbi, m\u00ecnh khoanh v\u00f9ng l\u00e0 [1]. N\u1ed9i dung \u0111o\u1ea1n code [1] c\u00f3 ngh\u0129a nh\u01b0 sau: \u0110\u1ea7u ti\u00ean, ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u t\u1eeb B3:D3 v\u00e0 th\u1ef1c hi\u1ec7n l\u1ec7nh Copy \u0111o\u1ea1n \u0111\u00f3, sau \u0111\u00f3 ch\u1ecdn v\u00f9ng (\u00f4) D4. \u0110\u00e2y\u00a0l\u00e0 nh\u1eefng thao t\u00e1c d\u01b0 th\u1eeba, ch\u00fang ta c\u1ea7n b\u1ecf \u0111i, \u0111\u1ec3 khi g\u1ecdi macro n\u00f3 kh\u00f4ng th\u1ef1c hi\u1ec7n l\u1ea1i c\u00e1c thao t\u00e1c \u0111\u00f3. B\u1edfi v\u00ec, ch\u00fang ta s\u1ebd copy nh\u1eefng v\u00f9ng d\u1eef li\u1ec7u kh\u00e1c, v\u00e0 ch\u00fang ta s\u1ebd d\u00e1n \u1edf nh\u1eefng ch\u1ed7 kh\u00e1c nhau, ch\u1ee9 kh\u00f4ng c\u1ed1 \u0111\u1ecbnh l\u00e0 copy v\u00f9ng B3:D3, r\u1ed3i d\u00e1n ra v\u00f9ng D4.<\/li>\n<li>Ti\u1ebfp t\u1ee5c, ch\u00fang ta ch\u1ecdn L\u01b0u l\u1ea1i c\u00e1c ch\u1ec9nh s\u1eeda (File &gt; Save ho\u1eb7c nh\u1ea5n CTRL+S). N\u1ed9i dung \u0111o\u1ea1n code cu\u1ed1i c\u00f9ng [2] c\u00f3 ngh\u0129a nh\u01b0 sau: T\u1ea1i v\u1ecb tr\u00ed \u00f4 ch\u1ecdn \u1edf ngo\u00e0i Excel, b\u1ea1n th\u1ef1c hi\u1ec7n thao t\u00e1c Paste Special v\u1edbi l\u1ef1a ch\u1ecdn [x] Values v\u00e0 \u0111\u1ed3ng th\u1eddi s\u1ebd [x] Transpose d\u1eef li\u1ec7u (V\u00ed d\u1ee5: v\u00f9ng copy ch\u1ee9a c\u00f4ng th\u1ee9c theo c\u1ed9t, th\u00ec d\u00e1n ra s\u1ebd theo d\u00f2ng v\u00e0 chuy\u1ec3n c\u00f4ng th\u1ee9c th\u00e0nh gi\u00e1 tr\u1ecb c\u1ee7a k\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c \u0111\u00f3).<\/li>\n<\/ol>\n<p>Ghi ch\u00fa:<\/p>\n<ul>\n<li>V\u1edbi c\u00e1c d\u00f2ng ch\u1eef b\u1eaft \u0111\u1ea7u v\u1edbi d\u1ea5u nh\u00e1y \u0111\u01a1n c\u00f3 m\u00e0u xanh l\u00e1 c\u00e2y, \u0111\u00e2y l\u00e0 nh\u1eefng ghi ch\u00fa (comment) s\u1ebd kh\u00f4ng th\u1ef1c thi l\u1ec7nh trong VBA, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam c\u00e1c d\u00f2ng ghi ch\u00fa t\u00f9y th\u00edch, ho\u1eb7c x\u00f3a \u0111i n\u1ebfu c\u1ea3m th\u1ea5y kh\u00f4ng c\u1ea7n thi\u1ebft.<\/li>\n<li>V\u1edbi c\u00e1c d\u00f2ng l\u1ec7nh d\u00e0i, VBA s\u1ebd t\u1ef1 th\u00eam d\u1ea5u \u201d _\u201d (c\u00f3 1 kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc d\u1ea5u g\u1ea1ch d\u01b0\u1edbi), \u0111\u1ec3 n\u1ed1i 2 d\u00f2ng th\u00e0nh 1 c\u00e2u l\u1ec7nh VBA li\u00ean t\u1ee5c. V\u00ec v\u1eady n\u1ebfu b\u1ea1n mu\u1ed1n x\u00f3a v\u1ec1 c\u00f9ng 1 d\u00f2ng, th\u00ec x\u00f3a lu\u00f4n d\u1ea5u g\u1ea1ch v\u00e0 ch\u1eeba kho\u1ea3ng tr\u1eafng. N\u1ebfu b\u1ea1n c\u1ea7n xu\u1ed1ng d\u00f2ng, th\u00ec l\u01b0u \u00fd ch\u1ed7 ng\u1eaft l\u1ec7nh ph\u00f9 h\u1ee3p, v\u00e0 lu\u00f4n c\u00f3 1 kho\u1ea3ng tr\u1eafng ph\u00eda tr\u01b0\u1edbc d\u1ea5u g\u1ea1ch d\u01b0\u1edbi.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/vba-code-remove-selection.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22865\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba-code-remove-selection.jpg\" width=\"881\" height=\"478\" title=\"vba-code-remove-selection\"><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"Buoc_5_Gan_Macro_PasteValue_Transpose_vao_Quick_Access_Toolbar\"><\/span>B\u01b0\u1edbc 5: G\u00e1n Macro PasteValue_Transpose v\u00e0o Quick Access Toolbar.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<ol>\n<li>Tr\u1edf l\u1ea1i v\u1edbi<strong> Excel Options<\/strong>, ph\u1ea7n<strong> Quick Access Toolbar<\/strong>, ph\u1ea7n <strong>Choose commands from:<\/strong> b\u1ea1n ch\u1ecdn <strong>Macros<\/strong>.<\/li>\n<li>L\u00fac n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y<strong> PERSONAL.XLSB!PasteValue_Transp\u2026<\/strong> xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch, v\u00e0 b\u1ea1n n\u00fat l\u1ec7nh n\u00e0y.<\/li>\n<li>Ch\u1ecdn <strong>Add &gt;&gt;<\/strong> \u0111\u1ec3 th\u00eam v\u00e0o Quick Access Toolbar.<\/li>\n<li>V\u00e0 n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ed5i bi\u1ec3u t\u01b0\u1ee3ng Macro m\u1eb7c \u0111\u1ecbnh theo c\u00e1c icon t\u00f9y ch\u1ec9nh kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn t\u00ean n\u00fat l\u1ec7nh \u0111\u00e3 th\u00eam, v\u00e0 ch\u1ecdn <strong>Modify\u2026<\/strong> Ch\u1ecdn icon t\u00f9y th\u00edch, r\u1ed3i ch\u1ecdn OK.<\/li>\n<li>V\u1eady l\u00e0 xong, b\u1ea1n c\u00f3 1 n\u00fat l\u1ec7nh, v\u00e0 bao g\u1ed3m lu\u00f4n 1 ph\u00edm t\u1eaft <strong>CTRL+SHIFT+V<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n l\u1ec7nh PASTE VALUE + TRANSPOSE theo nh\u01b0 mong mu\u1ed1n c\u1ee7a m\u00ecnh r\u1ed3i.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/add-macro-quick-access-change-icon.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22866\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/add-macro-quick-access-change-icon.jpg\" width=\"838\" height=\"685\" title=\"add-macro-quick-access-change-icon\"><\/a><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Loi_ket_Tai_sao_lai_phai_dung_Quick_Access_Toolbar\"><\/span><strong>L\u1eddi k\u1ebft: T\u1ea1i sao l\u1ea1i ph\u1ea3i d\u00f9ng Quick Access Toolbar?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Cu\u1ed1i c\u00f9ng, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng Quick Access Toolbar v\u1edbi t\u1eadp h\u1ee3p c\u00e1c n\u00fat l\u1ec7nh nhanh, v\u00e0 c\u00e1c ph\u00edm t\u1eaft k\u1ebft h\u1ee3p. V\u00ed d\u1ee5, khi b\u1ea1n nh\u1ea5n ALT, tr\u00ean thanh Quick Access Toolbar, s\u1ebd xu\u1ea5t hi\u1ec7n c\u00e1c con s\u1ed1 t\u01b0\u01a1ng \u1ee9ng theo th\u1ee9 t\u1ef1 n\u00fat l\u1ec7nh. B\u1ea1n ch\u1ecdn s\u1ed1 ph\u00f9 h\u1ee3p, v\u1eady l\u00e0 b\u1ea1n c\u00f3 th\u00eam 1 ph\u00edm t\u1eaft nhanh m\u00e0 c\u0169ng ch\u1eb3ng c\u1ea7n ph\u1ea3i thu\u1ed9c l\u00f2ng ph\u00edm t\u1eaft.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/alt-key-shortcut-quick-access-toolbar.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-22869\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/alt-key-shortcut-quick-access-toolbar.jpg\" width=\"808\" height=\"340\" title=\"alt-key-shortcut-quick-access-toolbar\"><\/a><\/p>\n<p>Ngo\u00e0i ra, v\u1edbi c\u00e1c Macro b\u1ea1n ghi l\u1ea1i n\u00fat l\u1ec7nh, b\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c nhanh h\u01a1n r\u1ed3i \u0111\u00fang kh\u00f4ng? Ngo\u00e0i l\u1ec7nh\u00a0VBA v\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 c\u00e1c kh\u00f3a h\u1ecdc VBA c\u1ee7a HocExcel.Online \u0111\u1ec3 trang b\u1ecb t\u1ed1t h\u01a1n ki\u1ebfn th\u1ee9c VBA \u0111\u1ec3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1c t\u1eadp l\u1ec7nh VBA ph\u1ee9c t\u1ea1p h\u01a1n.<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-2.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9890,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9889","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\/9889","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=9889"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9889\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9890"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9889"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}