{"id":12542,"date":"2025-01-15T09:25:24","date_gmt":"2025-01-15T09:25:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/10-thu-thuat-giup-ban-them-hieu-qua-voi-excel\/"},"modified":"2025-01-15T09:25:24","modified_gmt":"2025-01-15T09:25:24","slug":"10-thu-thuat-giup-ban-them-hieu-qua-voi-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/10-thu-thuat-giup-ban-them-hieu-qua-voi-excel\/","title":{"rendered":"10 th\u1ee7 thu\u1eadt gi\u00fap b\u1ea1n th\u00eam hi\u1ec7u qu\u1ea3 v\u1edbi Excel"},"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-67877f014e226\" 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\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Chon_toan_bo_bang_tinh\" title=\"Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh\">Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Mo_cung_luc_nhieu_file_Excel\" title=\"M\u1edf c\u00f9ng l\u00fac nhi\u1ec1u file Excel\">M\u1edf c\u00f9ng l\u00fac nhi\u1ec1u file Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Chuyen_giua_cac_cua_so_Excel\" title=\"Chuy\u1ec3n gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 Excel\">Chuy\u1ec3n gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Them_1_chuc_nang_vao_thanh_Quick_Access_Toolbar_cua_Excel\" title=\"Th\u00eam 1 ch\u1ee9c n\u0103ng v\u00e0o thanh Quick Access Toolbar c\u1ee7a Excel\">Th\u00eam 1 ch\u1ee9c n\u0103ng v\u00e0o thanh Quick Access Toolbar c\u1ee7a Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Them_vien_cheo_trong_1_o_Excel\" title=\"Th\u00eam vi\u1ec1n ch\u00e9o trong 1 \u00f4 Excel\">Th\u00eam vi\u1ec1n ch\u00e9o trong 1 \u00f4 Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Them_nhieu_dong_hay_nhieu_cot_cung_luc\" title=\"Th\u00eam nhi\u1ec1u d\u00f2ng hay nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac\">Th\u00eam nhi\u1ec1u d\u00f2ng hay nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Copy_hay_di_chuyen_nhanh_1_vung_du_lieu\" title=\"Copy hay di chuy\u1ec3n nhanh 1 v\u00f9ng d\u1eef li\u1ec7u\">Copy hay di chuy\u1ec3n nhanh 1 v\u00f9ng d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Tim_kiem_ki_tu_dac_biet_trong_Excel_dau_hoi_cham_dau_hoa_thi_%E2%80%A6\" title=\"T\u00ecm ki\u1ebfm k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel (d\u1ea5u h\u1ecfi ch\u1ea5m, d\u1ea5u hoa th\u1ecb, \u2026)\">T\u00ecm ki\u1ebfm k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel (d\u1ea5u h\u1ecfi ch\u1ea5m, d\u1ea5u hoa th\u1ecb, \u2026)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Chuyen_du_lieu_hang_thanh_cot_voi_Copy_Transpose\" title=\"Chuy\u1ec3n d\u1eef li\u1ec7u h\u00e0ng th\u00e0nh c\u1ed9t v\u1edbi Copy Transpose\">Chuy\u1ec3n d\u1eef li\u1ec7u h\u00e0ng th\u00e0nh c\u1ed9t v\u1edbi Copy Transpose<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Danh_so_dien_thoai_trong_Excel_ma_van_giu_duoc_so_0_dang_truoc\" title=\"\u0110\u00e1nh s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel m\u00e0 v\u1eabn gi\u1eef \u0111\u01b0\u1ee3c s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc\">\u0110\u00e1nh s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel m\u00e0 v\u1eabn gi\u1eef \u0111\u01b0\u1ee3c s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/20-thu-thuat-giup-ban-hieu-qua-voi-excel.html#Kham_pha_them_that_nhieu_kien_thuc_voi_Hoc_Excel_Online\" title=\"\nKh\u00e1m ph\u00e1 th\u00eam th\u1eadt nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1edbi H\u1ecdc Excel Online:\"><br \/>\nKh\u00e1m ph\u00e1 th\u00eam th\u1eadt nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1edbi H\u1ecdc Excel Online:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chon_toan_bo_bang_tinh\"><\/span>Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ngo\u00e0i c\u00e1ch b\u1ea5m v\u00e0o b\u1ea5t k\u00ec \u00f4 n\u00e0o tr\u00ean 1 b\u1ea3ng t\u00ednh Excel r\u1ed3i s\u1eed d\u1ee5ng <a href=\"http:\/\/www.hocexcel.online\/tong-hop-hon-200-phim-tat-trong-excel-cac-phien-ban.html\" target=\"_blank\">ph\u00edm t\u1eaft<\/a> <strong>CTRL + A <\/strong>th\u00ec b\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m v\u00e0o \u00f4 \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i b\u1ea3ng t\u00ednh nh\u01b0 trong h\u00ecnh.<\/p>\n<p>\u00a0<\/p>\n<p><a href=\"http:\/\/www.hocexcel.online\/wp-content\/uploads\/2016\/10\/01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-863\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/01-300x248-1.png\" alt=\"01\" width=\"300\" height=\"248\" title=\"01-300x248-1\"><\/a><\/p>\n<p>\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mo_cung_luc_nhieu_file_Excel\"><\/span>M\u1edf c\u00f9ng l\u00fac nhi\u1ec1u file Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 m\u1edf c\u00f9ng l\u00fac nhi\u1ec1u file Excel, \u1edf trong c\u1eeda s\u1ed5 Windows Explorer, b\u1ea5m gi\u1eef n\u00fat <strong>CTRL<\/strong> v\u00e0 ch\u1ecdn nh\u1eefng file Excel c\u1ea7n \u0111\u01b0\u1ee3c m\u1edf ra r\u1ed3i b\u1ea5m ph\u00edm Enter tr\u00ean b\u00e0n ph\u00edm<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chuyen_giua_cac_cua_so_Excel\"><\/span>Chuy\u1ec3n gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 d\u1ecbch chuy\u1ec3n gi\u1eefa c\u00e1c c\u1eeda s\u1ed5 Excel \u0111ang m\u1edf, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft <strong>CTRL + TAB<\/strong><\/p>\n<p><a href=\"http:\/\/www.hocexcel.online\/wp-content\/uploads\/2016\/10\/Screen-Shot-2016-10-25-at-11.05.51.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-864\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2016-10-25-at-11-05-51-300x116-1.png\" alt=\"screen-shot-2016-10-25-at-11-05-51\" width=\"300\" height=\"116\" title=\"screen-shot-2016-10-25-at-11-05-51-300x116-1\"><\/a><\/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-411.gif\" title=\"ex101_92019-nho-411\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Them_1_chuc_nang_vao_thanh_Quick_Access_Toolbar_cua_Excel\"><\/span>Th\u00eam 1 ch\u1ee9c n\u0103ng v\u00e0o thanh Quick Access Toolbar c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 g\u00e1n 1 s\u1ed1 ch\u1ee9c n\u0103ng hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00ean tr\u00ean Quick Access Toolbar \u0111\u1ec3 c\u00f3 th\u1ec3 d\u00f9ng ch\u00fang m\u1ed9t c\u00e1ch nhanh h\u01a1n, ti\u1ebft ki\u1ec7m th\u1eddi gian h\u01a1n. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p>Ch\u1ecdn th\u1ebb File &gt; Options &gt; Quick Access Toolbar. Ch\u1ecdn ch\u1ee9c n\u0103ng mu\u1ed1n th\u00eam v\u00e0o Quick Access Toolbar v\u00e0 b\u1ea5m n\u00fat OK<\/p>\n<p><a href=\"http:\/\/www.hocexcel.online\/wp-content\/uploads\/2016\/10\/Screen-Shot-2016-10-25-at-11.08.59.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-865\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2016-10-25-at-11-08-59-300x146-1.png\" alt=\"screen-shot-2016-10-25-at-11-08-59\" width=\"300\" height=\"146\" title=\"screen-shot-2016-10-25-at-11-08-59-300x146-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Them_vien_cheo_trong_1_o_Excel\"><\/span>Th\u00eam vi\u1ec1n ch\u00e9o trong 1 \u00f4 Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/www.hocexcel.online\/wp-content\/uploads\/2016\/10\/Screen-Shot-2016-10-25-at-11.12.14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-866\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2016-10-25-at-11-12-14-284x300-1.png\" alt=\"screen-shot-2016-10-25-at-11-12-14\" width=\"284\" height=\"300\" title=\"screen-shot-2016-10-25-at-11-12-14-284x300-1\"><\/a><\/p>\n<p>\u0110\u1ec3 th\u00eam \u0111\u01b0\u1ee3c \u0111\u01b0\u1eddng vi\u1ec1n ch\u00e9o trong 1 \u00f4 c\u1ee7a Excel, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<ol>\n<li>Ch\u1ecdn \u00f4 c\u1ea7n th\u00eam vi\u1ec1n<\/li>\n<li>S\u1eed d\u1ee5ng <a href=\"http:\/\/www.hocexcel.online\/tong-hop-hon-200-phim-tat-trong-excel-cac-phien-ban.html\" target=\"_blank\">ph\u00edm t\u1eaft<\/a> <strong>CTRL + 1\u00a0<\/strong>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Format Cells, <\/strong>ch\u1ecdn th\u1ebb <strong>Border<\/strong><\/li>\n<li>Trong th\u1ebb Border, ch\u1ecdn \u0111\u01b0\u1eddng ch\u00e9o nh\u01b0 h\u00ecnh v\u1ebd ph\u00eda tr\u00ean r\u1ed3i b\u1ea5m OK<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Them_nhieu_dong_hay_nhieu_cot_cung_luc\"><\/span>Th\u00eam nhi\u1ec1u d\u00f2ng hay nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 th\u00eam nhi\u1ec1u d\u00f2ng hay nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac, ch\u00fang ta ch\u1ecdn s\u1ed1 d\u00f2ng v\u00e0 s\u1ed1 c\u1ed9t c\u1ea7n th\u00eam sau \u0111\u00f3 b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o nh\u1eefng d\u00f2ng ho\u1eb7c c\u1ed9t \u0111\u00e3 ch\u1ecdn r\u1ed3i b\u1ea5m <strong>Insert<\/strong><\/p>\n<p><a href=\"http:\/\/www.hocexcel.online\/wp-content\/uploads\/2016\/10\/aaa.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-867\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/aaa-300x104-1.jpg\" alt=\"aaa\" width=\"300\" height=\"104\" title=\"aaa-300x104-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Copy_hay_di_chuyen_nhanh_1_vung_du_lieu\"><\/span>Copy hay di chuy\u1ec3n nhanh 1 v\u00f9ng d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 copy hay di chuy\u1ec3n nhanh 1 v\u00f9ng d\u1eef li\u1ec7u trong Excel ch\u00fang ta c\u00f3 th\u1ec3 theo nh\u1eefng b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y:<\/p>\n<ol>\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n copy hay di chuy\u1ec3n<\/li>\n<li>Di chuy\u1ec3n con chu\u1ed9t v\u00e0o m\u00e9p c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u \u0111\u00f3<\/li>\n<li>N\u1ebfu copy: b\u1ea5m gi\u1eef ph\u00edm CTRL \u0111\u1ed3ng th\u1eddi click chu\u1ed9t di chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ebfn n\u01a1i c\u1ea7n copy. N\u1ebfu di chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u th\u00ec kh\u00f4ng c\u1ea7m b\u1ea5m gi\u1eef ph\u00edm CTRL<\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.hocexcel.online\/wp-content\/uploads\/2016\/10\/aaaa.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-868\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/aaaa-300x240-1.jpg\" alt=\"aaaa\" width=\"300\" height=\"240\" title=\"aaaa-300x240-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tim_kiem_ki_tu_dac_biet_trong_Excel_dau_hoi_cham_dau_hoa_thi_%E2%80%A6\"><\/span>T\u00ecm ki\u1ebfm k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel (d\u1ea5u h\u1ecfi ch\u1ea5m, d\u1ea5u hoa th\u1ecb, \u2026)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p c\u00e1c b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a c\u00e1c k\u00ed t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel, \u0111\u1eb7c bi\u1ec7t l\u00e0 d\u1ea5u <strong>?<\/strong> ho\u1eb7c d\u1ea5u <strong>*\u00a0<\/strong>th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau: S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p <a href=\"http:\/\/www.hocexcel.online\/tong-hop-hon-200-phim-tat-trong-excel-cac-phien-ban.html\" target=\"_blank\">ph\u00edm t\u1eaft<\/a> <strong>CTRL + F <\/strong>r\u1ed3i th\u1ef1c hi\u1ec7n vi\u1ec7c t\u00ecm ki\u1ebfm nh\u01b0 h\u00ecnh minh ho\u1ea1, l\u01b0u \u00fd th\u00eam d\u1ea5u\u00a0<strong>~ <\/strong>\u0111\u1eb1ng tr\u01b0\u1edbc k\u00ed t\u1ef1 c\u1ea7n t\u00ecm ki\u1ebfm<\/p>\n<p><a href=\"http:\/\/www.hocexcel.online\/wp-content\/uploads\/2016\/10\/aaaaa.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-869\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/aaaaa-300x105-1.jpg\" alt=\"aaaaa\" width=\"300\" height=\"105\" title=\"aaaaa-300x105-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chuyen_du_lieu_hang_thanh_cot_voi_Copy_Transpose\"><\/span>Chuy\u1ec3n d\u1eef li\u1ec7u h\u00e0ng th\u00e0nh c\u1ed9t v\u1edbi Copy Transpose<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u01b0\u1edbc 1: \u0111\u00e1nh d\u1ea5u b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n chuy\u1ec3n<\/p>\n<p>B\u01b0\u1edbc 2: b\u1ea5m <a href=\"http:\/\/www.hocexcel.online\/tong-hop-hon-200-phim-tat-trong-excel-cac-phien-ban.html\" target=\"_blank\">ph\u00edm t\u1eaft<\/a> <strong>CTRL + C<\/strong> \u0111\u1ec3 copy v\u00f9ng d\u1eef li\u1ec7u<\/p>\n<p>B\u01b0\u1edbc 3: B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng c\u1ea7n d\u00e1n d\u1eef li\u1ec7u v\u00e0 ch\u1ecdn <strong>Paste Special \u2026<\/strong><\/p>\n<p>B\u01b0\u1edbc 4: Trong h\u1ed9p tho\u1ea1i <strong>Paste Special \u2026, <\/strong>ch\u1ecdn Transpose r\u1ed3i b\u1ea5m OK<\/p>\n<p><a href=\"http:\/\/www.hocexcel.online\/wp-content\/uploads\/2016\/10\/Screen-Shot-2016-10-25-at-11.31.41.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-870\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2016-10-25-at-11-31-41-289x300-1.png\" alt=\"screen-shot-2016-10-25-at-11-31-41\" width=\"289\" height=\"300\" title=\"screen-shot-2016-10-25-at-11-31-41-289x300-1\"><\/a><\/p>\n<p>\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Danh_so_dien_thoai_trong_Excel_ma_van_giu_duoc_so_0_dang_truoc\"><\/span><strong>\u0110\u00e1nh s\u1ed1 \u0111i\u1ec7n tho\u1ea1i trong Excel m\u00e0 v\u1eabn gi\u1eef \u0111\u01b0\u1ee3c s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i m\u00e0 v\u1eabn gi\u1eef \u0111\u01b0\u1ee3c s\u1ed1 0 ho\u1eb7c d\u1ea5u + \u0111\u1eb1ng tr\u01b0\u1edbc th\u00ec tr\u01b0\u1edbc khi nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i v\u00e0o 1 \u00f4 trong Excel, ch\u00fang ta s\u1ebd c\u1ea7n th\u00eam 1 d\u1ea5u \u00a0<strong> \u2018 .\u00a0<\/strong>Sau \u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadp s\u1ed1 \u0111i\u1ec7n tho\u1ea1i nh\u01b0 b\u00ecnh th\u01b0\u1eddng m\u00e0 v\u1eabn gi\u1eef \u0111\u01b0\u1ee3c s\u1ed1 0 \u0111\u1eb1ng tr\u01b0\u1edbc.<\/p>\n<p><a href=\"http:\/\/www.hocexcel.online\/wp-content\/uploads\/2016\/10\/Screen-Shot-2016-10-25-at-11.35.40.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-871\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/screen-shot-2016-10-25-at-11-35-40-300x122-1.png\" alt=\"screen-shot-2016-10-25-at-11-35-40\" width=\"300\" height=\"122\" title=\"screen-shot-2016-10-25-at-11-35-40-300x122-1\"><\/a><\/p>\n<p>\u00a0<\/p>\n<h2>\nKh\u00e1m ph\u00e1 th\u00eam th\u1eadt nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1edbi H\u1ecdc Excel Online:<\/h2>\n<p>? H\u1ecdc Excel, C\u00f3 Vi\u1ec7c Ngay: <a href=\"http:\/\/bit.ly\/heoEDM01a\">http:\/\/bit.ly\/heoEDM01a<\/a><br \/>\n? L\u1eadp tr\u00ecnh VBA n\u00e2ng cao kh\u1ea3 n\u0103ng Excel: <a href=\"http:\/\/bit.ly\/heoEDM02a\">http:\/\/bit.ly\/heoEDM02a<\/a><br \/>\n? Tr\u1edf th\u00e0nh si\u00eau nh\u00e2n b\u00e1o c\u00e1o v\u00e0 bi\u1ec3u \u0111\u1ed3: <a href=\"http:\/\/bit.ly\/heoEDM05a\">http:\/\/bit.ly\/heoEDM05a<\/a><br \/>\n? Excel t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn chuy\u00ean gia: <a href=\"http:\/\/bit.ly\/heoEDM06a\">http:\/\/bit.ly\/heoEDM06a<\/a><br \/>\n? H\u00e3y \u0111\u1ec3 Excel 2010 gi\u00fap b\u1ea1n: <a href=\"http:\/\/bit.ly\/heoEDM07a\">http:\/\/bit.ly\/heoEDM07a<\/a><\/p>\n<p>\u00a0<\/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-411.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12543,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12542","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\/12542","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=12542"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12542\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12543"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}