{"id":2938,"date":"2024-12-02T09:45:59","date_gmt":"2024-12-02T09:45:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010\/"},"modified":"2024-12-02T09:45:59","modified_gmt":"2024-12-02T09:45:59","slug":"huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 3 c\u00e1ch thay \u0111\u1ed5i ch\u1eef th\u01b0\u1eddng th\u00e0nh ch\u1eef hoa v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Excel 2016, 2013, 2010"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y,\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1c c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i ch\u1eef vi\u1ebft hoa th\u00e0nh vi\u1ebft th\u01b0\u1eddng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i,\u00a0vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean b\u1eb1ng h\u00e0m Excel ho\u1eb7c VBA Macros v\u00e0 Microsoft Word<\/em><\/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-674d81d612bc1\" 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\/huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010.html#Ham_thay_doi_cach_viet_hoa_thanh_viet_thuong_va_nguoc_lai_trong_Excel\" title=\"H\u00e0m thay \u0111\u1ed5i c\u00e1ch vi\u1ebft hoa th\u00e0nh vi\u1ebft th\u01b0\u1eddng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Excel:\">H\u00e0m thay \u0111\u1ed5i c\u00e1ch vi\u1ebft hoa th\u00e0nh vi\u1ebft th\u01b0\u1eddng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Excel:<\/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\/huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010.html#Nhap_cong_thuc_Excel\" title=\"Nh\u1eadp c\u00f4ng th\u1ee9c Excel\">Nh\u1eadp c\u00f4ng th\u1ee9c Excel<\/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\/huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010.html#Sao_chep_cong_thuc_xuong_cac_o_khac_trong_cot\" title=\"Sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t\">Sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t<\/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\/huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010.html#Xoa_cot_phu\" title=\"X\u00f3a c\u1ed9t ph\u1ee5\">X\u00f3a c\u1ed9t ph\u1ee5<\/a><\/li>\n<\/ul>\n<\/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\/huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010.html#Su_dung_Microsoft_Word_de_thay_doi_viet_hoaviet_thuong_trong_Excel\" title=\"S\u1eed d\u1ee5ng Microsoft Word \u0111\u1ec3 thay \u0111\u1ed5i vi\u1ebft hoa\/vi\u1ebft th\u01b0\u1eddng trong Excel:\">S\u1eed d\u1ee5ng Microsoft Word \u0111\u1ec3 thay \u0111\u1ed5i vi\u1ebft hoa\/vi\u1ebft th\u01b0\u1eddng trong Excel:<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-thay-doi-chu-thuong-thanh-chu-hoa-va-nguoc-lai-trong-excel-2016-2013-2010.html#Chuyen_doi_viet_hoaviet_thuong_bang_VBA_macro\" title=\"Chuy\u1ec3n \u0111\u1ed5i vi\u1ebft hoa\/vi\u1ebft th\u01b0\u1eddng b\u1eb1ng VBA macro\">Chuy\u1ec3n \u0111\u1ed5i vi\u1ebft hoa\/vi\u1ebft th\u01b0\u1eddng b\u1eb1ng VBA macro<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_thay_doi_cach_viet_hoa_thanh_viet_thuong_va_nguoc_lai_trong_Excel\"><\/span><strong>H\u00e0m thay \u0111\u1ed5i c\u00e1ch vi\u1ebft hoa th\u00e0nh vi\u1ebft th\u01b0\u1eddng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Microsoft Excel c\u00f3 ba h\u00e0m \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 thay \u0111\u1ed5i c\u00e1ch vi\u1ebft hoa\/vi\u1ebft th\u01b0\u1eddng. Ch\u00fang l\u00e0 <strong>UPPER<\/strong>, <strong>LOWER <\/strong>V\u00c0 <strong>PROPER. <\/strong>H\u00e0m <strong>UPPER <\/strong>cho ph\u00e9p b\u1ea1n chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 ch\u1eef in th\u01b0\u1eddng th\u00e0nh ch\u1eef in hoa. <a href=\"http:\/\/blog.ezworkapp.com\/tag\/ham-lower\">H\u00e0m <strong>LOWER<\/strong><\/a> cho ph\u00e9p b\u1ea1n chuy\u1ec3n \u0111\u1ed5i t\u1ea5t c\u1ea3 ch\u1eef in hoa th\u00e0nh ch\u1eef in th\u01b0\u1eddng. H\u00e0m <strong>PROPER<\/strong> gi\u00fap b\u1ea1n vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed7i t\u1eeb v\u00e0 c\u00e1c ch\u1eef c\u00e1i kh\u00e1c trong t\u1eeb \u0111\u01b0\u1ee3c in th\u01b0\u1eddng.<\/p>\n<p style=\"text-align: justify\">T\u1ea5t c\u1ea3 ba t\u00f9y ch\u1ecdn \u0111\u1ec1u ho\u1ea1t \u0111\u1ed9ng tr\u00ean c\u00f9ng m\u1ed9t nguy\u00ean l\u00fd, v\u1eady n\u00ean t\u00f4i ch\u1ec9 tr\u00ecnh b\u00e0y c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t trong ba c\u00f4ng th\u1ee9c tr\u00ean. H\u00e3y l\u1ea5y h\u00e0m <strong>UPPER <\/strong>l\u00e0 m\u1ed9t v\u00ed d\u1ee5.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Nhap_cong_thuc_Excel\"><\/span>Nh\u1eadp c\u00f4ng th\u1ee9c Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ol style=\"text-align: justify\">\n<li>Ch\u00e8n m\u1ed9t c\u1ed9t ph\u1ee5 k\u1ebf b\u00ean c\u1ed9t ch\u1ee9a n\u1ed9i dung b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>. B\u01b0\u1edbc n\u00e0y c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n ho\u1eb7c kh\u00f4ng. N\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n kh\u00f4ng \u0111\u1ee7 l\u1edbn, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1ea5t k\u1ef3 c\u1ed9t tr\u1ed1ng li\u1ec1n k\u1ec1 n\u00e0o.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/helper-column.png\" alt=\"Insert a new column to enter formulas in the adjacent blank cells\" title=\"helper-column\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>G\u00f5 d\u1ea5u<strong> \u201c=\u201d<\/strong> v\u00e0 h\u00e0m <strong>UPPER <\/strong>trong \u00f4 k\u1ebf b\u00ean c\u1ee7a c\u1ed9t m\u1edbi (B3)<\/li>\n<li>G\u00f5 tham chi\u1ebfu \u00f4 ph\u00f9 h\u1ee3p v\u00e0o d\u1ea5u ngo\u1eb7c \u0111\u01a1n sau t\u00ean h\u00e0m, v\u00ed d\u1ee5 (C3)<\/li>\n<\/ol>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n s\u1ebd tr\u00f4ng nh\u01b0 sau <strong><em>=UPPER(C3)<\/em><\/strong>, C3 l\u00e0 \u00f4 \u1edf c\u1ed9t g\u1ed1c ch\u1ee9a n\u1ed9i dung c\u1ea7n chuy\u1ec3n \u0111\u1ed5i.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/changing-case-formula.png\" alt=\"Enter the equal sign, function name and cell reference to apply the formula to the adjacent cell\" title=\"changing-case-formula\"><\/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\/2024\/12\/vba101_92019-nho-94.gif\" title=\"vba101_92019-nho-94\"><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\/2024\/12\/ex101_92019-nho-224.gif\" title=\"ex101_92019-nho-224\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5n <strong>Enter.<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/converted-text.png\" alt=\"Click Enter to see the converted text value\" title=\"converted-text\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 trong h\u00ecnh, n\u1ed9i dung c\u1ee7a \u00f4 B3 \u0111\u00e3 \u0111\u01b0\u1ee3c in hoa.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sao_chep_cong_thuc_xuong_cac_o_khac_trong_cot\"><\/span>Sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n c\u1ea7n sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c \u00f4 kh\u00e1c trong c\u1ed9t ph\u1ee5.<\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Ch\u1ecdn \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c.<\/li>\n<li>Di chuy\u1ec3n con chu\u1ed9t \u0111\u1ebfn g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u1ebfn khi hi\u1ec3n th\u1ecb d\u1ea5u th\u1eadp m\u00e0u \u0111en.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-formula.png\" alt=\"Select the cell and drag the fill handle down to copy the formula\" title=\"copy-formula\"><\/p>\n<ol style=\"text-align: justify\" start=\"7\">\n<li>Nh\u1ea5n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o c\u00f4ng th\u1ee9c d\u1ecdc xu\u1ed1ng c\u00e1c \u00f4.<\/li>\n<li>Th\u1ea3 chu\u1ed9t.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-uppercase.png\" alt=\"Release the mouse button to fill the column with the text in uppercase\" title=\"excel-uppercase\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu b\u1ea1n c\u1ea7n \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u1ebfn cu\u1ed1i b\u1ea3ng, b\u1ea1n c\u00f3 th\u1ec3 b\u1ecf b\u01b0\u1edbc 5-7 v\u00e0 ch\u1ec9 c\u1ea7n nh\u1ea5n \u0111\u00fap chu\u1ed9t v\u00e0o <strong><em>fill handle\u00a0<\/em><\/strong><em>(fill handle l\u00e0 \u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi, b\u00ean ph\u1ea3i khi b\u1ea1n ch\u1ecdn m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u)<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xoa_cot_phu\"><\/span>X\u00f3a c\u1ed9t ph\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 c\u00f3 hai c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u gi\u1ed1ng nhau. Gi\u1ea3 s\u1eed r\u1eb1ng b\u1ea1n ch\u1ec9 mu\u1ed1n ch\u1eeba l\u1ea1i m\u1ed9t c\u1ed9t, h\u00e3y sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t ph\u1ee5 sau \u0111\u00f3 x\u00f3a n\u00f3.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn c\u00e1c \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n <strong><em>Ctrl + C <\/em><\/strong>\u0111\u1ec3 sao ch\u00e9p.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-text-values.png\" alt=\"Press Ctrl + C to copy the values from the selected cells\" title=\"copy-text-values\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Nh\u1ea5p ph\u1ea3i v\u00e0o \u00f4 t\u00ednh \u0111\u1ea7u ti\u00ean trong c\u1ed9t g\u1ed1c.<\/li>\n<li>Nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong><em>Values <\/em><\/strong>d\u01b0\u1edbi <strong><em>Paste Options <\/em><\/strong>trong danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/paste-values.png\" alt=\"Choose Values from the Paste Options in the context menu to insert the text without the formula\" title=\"paste-values\"><\/p>\n<p style=\"text-align: justify\">V\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, h\u00e3y ch\u1ecdn t\u00f9y ch\u1ecdn n\u00e0y \u0111\u1ec3 tr\u00e1nh l\u1ed7i c\u00f4ng th\u1ee9c.<\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5p ph\u1ea3i v\u00e0o c\u1ed9t ph\u1ee5 v\u00e0 ch\u1ecdn <strong><em>Delete..<\/em><\/strong>.<\/li>\n<li>Ch\u1ecdn <strong><em>Entire column<\/em><\/strong> trong h\u1ed9p tho\u1ea1i <strong><em>Delete<\/em><\/strong> v\u00e0 nh\u1ea5n OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5909\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-101.png\" width=\"600\" height=\"564\" title=\"excel-dialog-box-launcher-1-101\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/converted-text-case.png\" alt=\"Delete the helper column to get the table with the converted text case\" title=\"converted-text-case\"><\/p>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a hi\u1ec3u r\u00f5 c\u00e1c v\u00ed d\u1ee5 tr\u00ean th\u00ec t\u00f4i khuy\u00ean b\u1ea1n n\u00ean \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y tr\u01b0\u1edbc nh\u00e9: <strong>H\u01b0\u1edbng d\u1eabn <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-upper-trong-excel.html\">c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m UPPER<\/a> trong Excel. <\/strong>Sau khi \u0111\u00e3 hi\u1ec3u nguy\u00ean t\u1eafc ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m th\u00ec h\u00e3y quay l\u1ea1i b\u00e0i n\u00e0y nh\u00e9!<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_Microsoft_Word_de_thay_doi_viet_hoaviet_thuong_trong_Excel\"><\/span><strong>S\u1eed d\u1ee5ng Microsoft Word \u0111\u1ec3 thay \u0111\u1ed5i vi\u1ebft hoa\/vi\u1ebft th\u01b0\u1eddng trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u1ec7nh \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 thay \u0111\u1ed5i vi\u1ebft hoa\/vi\u1ebft th\u01b0\u1eddng trong Word.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i.<\/li>\n<li>Nh\u1ea5n <strong><em>Ctrl + C <\/em><\/strong>v\u00e0 nh\u1ea5p ph\u1ea3i v\u00e0o v\u00f9ng \u0111\u00e3 ch\u1ecdn, ch\u1ecdn t\u00f9y ch\u1ecdn <strong><em>Copy <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-excel-table.png\" alt=\"Click Copy or press Ctrl + C to copy the table from Excel to Word\" title=\"copy-excel-table\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>M\u1edf trang Word m\u1edbi.<\/li>\n<li>Nh\u1ea5n <strong><em>Ctrl + V<\/em><\/strong> ho\u1eb7c nh\u1ea5p ph\u1ea3i chu\u1ed9t v\u00e0o trang tr\u1ed1ng v\u00e0 ch\u1ecdn <strong><em>Paste<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/paste-table-word.png\" alt=\"Click Paste or press Ctrl + V to paste the table in Word\" title=\"paste-table-word\"><\/p>\n<p style=\"text-align: center\">B\u1ea3ng Excel b\u00e2y gi\u1edd hi\u1ec3n th\u1ecb trong b\u1ea3ng Word.<\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>B\u00f4i \u0111en n\u1ed9i dung b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i trong b\u1ea3ng.<\/li>\n<li>Di chuy\u1ec3n \u0111\u1ebfn nh\u00f3m <strong><em>Font <\/em><\/strong>\u1edf th\u1ebb <strong><em>HOME <\/em><\/strong>v\u00e0 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong><em>Change Case<\/em><\/strong>.<\/li>\n<li>Ch\u1ecdn m\u1ed9t trong 5 tr\u01b0\u1eddng h\u1ee3p sau t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/word-change-case-command.png\" alt=\"Click on the Change Case icon to pick the case you want\" title=\"word-change-case-command\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn ph\u1ea7n n\u1ed9i dung r\u1ed3i nh\u1ea5n <strong><em>Shift + F3 <\/em><\/strong>\u0111\u1ebfn khi n\u1ed9i dung hi\u1ec3n th\u1ecb theo \u0111\u00fang \u00fd b\u1ea1n. S\u1eed d\u1ee5ng ph\u00edm t\u1eaft ch\u1ec9 c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i th\u00e0nh in hoa, in th\u01b0\u1eddng ho\u1eb7c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean.<\/p>\n<p><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-chi-viet-hoa-chu-cai-dau-tien-trong-excel.html\">C\u00f4ng th\u1ee9c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong excel<\/a> c\u1ef1c d\u1ec5<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-text-case-word.png\" alt=\"Select the changed table or columns to copy back to Excel\" title=\"change-text-case-word\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n ch\u1ec9 c\u1ea7n sao ch\u00e9p b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 d\u00e1n n\u00f3 qua Excel.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/paste-table-excel.png\" alt=\"Click Paste or press Ctrl + V to paste the changed table back in Excel\" title=\"paste-table-excel\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuyen_doi_viet_hoaviet_thuong_bang_VBA_macro\"><\/span><strong>Chuy\u1ec3n \u0111\u1ed5i vi\u1ebft hoa\/vi\u1ebft th\u01b0\u1eddng b\u1eb1ng VBA macro<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong>Macro VBA<\/strong> \u0111\u1ec3 thay \u0111\u1ed5i trong Excel 2010\/2013. T\u00f4i s\u1ebd kh\u00f4ng h\u01b0\u1edbng d\u1eabn l\u1ea1i <a href=\"http:\/\/blog.ezworkapp.com\/cach-chen-va-chay-ma-vba-trong-excel-2010-2016-huong-dan-cho-nguoi-moi-bat-dau.html\" target=\"_blank\" rel=\"noopener noreferrer\">c\u00e1ch ch\u00e8n v\u00e0 ch\u1ea1y m\u00e3 <strong><em>VBA<\/em><\/strong> trong Excel<\/a> v\u00ec n\u00f3 \u0111\u00e3 \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 chi ti\u1ebft trong nh\u1eefng b\u00e0i vi\u1ebft tr\u01b0\u1edbc. T\u00f4i ch\u1ec9 tr\u00ecnh b\u00e0y <strong><em>Macro<\/em><\/strong> m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p v\u00e0 d\u00e1n v\u00e0o m\u00e3 <strong><em>Module<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i v\u0103n b\u1ea3n sang ch\u1eef hoa, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-excel-macros-va-lap-trinh-vba.html\"><em>VBA Macro<\/em><\/a> sau \u0111\u00e2y:<\/p>\n<div class=\"line number1 index0 alt2\" style=\"text-align: justify\"><code class=\"vb keyword\">Sub<\/code> <code class=\"vb plain\">Uppercase()<\/code><\/div>\n<div class=\"line number2 index1 alt1\" style=\"text-align: justify\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">For<\/code> <code class=\"vb keyword\">Each<\/code> <code class=\"vb plain\">Cell <\/code><code class=\"vb keyword\">In<\/code> <code class=\"vb plain\">Selection<\/code><\/div>\n<div class=\"line number3 index2 alt2\" style=\"text-align: justify\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">If<\/code> <code class=\"vb keyword\">Not<\/code> <code class=\"vb plain\">Cell.HasFormula <\/code><code class=\"vb keyword\">Then<\/code><\/div>\n<div class=\"line number4 index3 alt1\" style=\"text-align: justify\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Cell.Value = UCase(Cell.Value)<\/code><\/div>\n<div class=\"line number5 index4 alt2\" style=\"text-align: justify\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">If<\/code><\/div>\n<div class=\"line number6 index5 alt1\" style=\"text-align: justify\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Next<\/code> <code class=\"vb plain\">Cell<\/code><\/div>\n<div class=\"line number7 index6 alt2\" style=\"text-align: justify\"><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">Sub<\/code><\/div>\n<p style=\"text-align: justify\">\u0110\u1ec3 chuy\u1ec3n sang ch\u1eef th\u01b0\u1eddng, ch\u00e8n d\u00f2ng m\u00e3 sau:<\/p>\n<div style=\"text-align: justify\">\n<div id=\"highlighter_793399\" class=\"syntaxhighlighter nogutter vb\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"code\" style=\"width: 370px\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"vb keyword\">Sub<\/code> <code class=\"vb plain\">Lowercase()<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">For<\/code> <code class=\"vb keyword\">Each<\/code> <code class=\"vb plain\">Cell <\/code><code class=\"vb keyword\">In<\/code> <code class=\"vb plain\">Selection<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">If<\/code> <code class=\"vb keyword\">Not<\/code> <code class=\"vb plain\">Cell.HasFormula <\/code><code class=\"vb keyword\">Then<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Cell.Value = LCase(Cell.Value)<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">If<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Next<\/code> <code class=\"vb plain\">Cell<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">Sub<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">N\u1ebfu mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i gi\u00e1 tr\u1ecb n\u1ed9i dung \u0111\u01b0\u1ee3c vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean, ch\u00e8n d\u00f2ng m\u00e3 sau:<\/p>\n<div style=\"text-align: justify\">\n<div id=\"highlighter_161828\" class=\"syntaxhighlighter nogutter vb\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"vb keyword\">Sub<\/code> <code class=\"vb plain\">Propercase()<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">For<\/code> <code class=\"vb keyword\">Each<\/code> <code class=\"vb plain\">Cell <\/code><code class=\"vb keyword\">In<\/code> <code class=\"vb plain\">Selection<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">If<\/code> <code class=\"vb keyword\">Not<\/code> <code class=\"vb plain\">Cell.HasFormula <\/code><code class=\"vb keyword\">Then<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Cell.Value = _<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Application _<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">.WorksheetFunction _<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">.Proper(Cell.Value)<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">If<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Next<\/code> <code class=\"vb plain\">Cell<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">Sub<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><strong>T\u00e0i li\u1ec7u tham kh\u1ea3o th\u00eam:<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">C\u00e1ch h\u1ecdc excel 2010<\/a><\/li>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2013\">H\u1ecdc excel 2013<\/a><\/li>\n<li style=\"text-align: justify\">H\u01b0\u1edbng d\u1eabn h\u1ecdc excel 2020<\/li>\n<\/ul>\n<p>\u0110\u1ec3 n\u00e2ng cao ki\u1ebfn th\u1ee9c Excel, b\u1ea1n h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong>. Trong kh\u00f3a h\u1ecdc n\u00e0y b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5: conditional formatting, data validation, pivot table\u2026 \u0111\u1ec3 \u1ee9ng d\u1ee5ng v\u00e0o trong c\u00f4ng vi\u1ec7c. Ngo\u00e0i ra b\u1ea1n c\u00f2n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m trong excel, t\u1eeb c\u00e1c h\u00e0m c\u01a1 b\u1ea3n cho t\u1edbi c\u00e1c h\u00e0m n\u00e2ng cao, ph\u1ee9c t\u1ea1p. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia <strong><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-tu-co-ban-toi-nang-cao-danh-cho-dan-van-phong-2010-20132016\">kh\u00f3a h\u1ecdc Excel<\/a> <\/strong>c\u1ee7a ch\u00fang t\u00f4i.<\/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\/2024\/12\/vba101_92019-nho-94.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2939,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2938","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2938","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=2938"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2938\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2939"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}