{"id":9688,"date":"2025-01-02T12:49:34","date_gmt":"2025-01-02T12:49:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-thiet-lap-autocorrect-trong-excel\/"},"modified":"2025-01-02T12:49:34","modified_gmt":"2025-01-02T12:49:34","slug":"huong-dan-thiet-lap-autocorrect-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-thiet-lap-autocorrect-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp AutoCorrect trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>T\u00ednh n\u0103ng AutoCorrect c\u1ee7a Excel \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng ch\u1ec9nh s\u1eeda nh\u1eefng t\u1eeb sai. Trong th\u1ef1c t\u1ebf, n\u00f3 c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c nhi\u1ec1u h\u01a1n l\u00e0 ch\u1ec9 s\u1eeda l\u1ed7i. C\u1ee5 th\u1ec3, trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1c b\u1ea1n c\u00e1ch <strong>thi\u1ebft l\u1eadp AutoCorrect<\/strong> v\u00e0 s\u1eed d\u1ee5ng th\u1eadt hi\u1ec7u qu\u1ea3.<\/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-67768b5de3724\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-thiet-lap-autocorrect.html#Thiet_lap_AutoCorrect_trong_Excel\" title=\"Thi\u1ebft l\u1eadp AutoCorrect trong Excel\">Thi\u1ebft l\u1eadp AutoCorrect trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-thiet-lap-autocorrect.html#AutoCorrect\" title=\"AutoCorrect\">AutoCorrect<\/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-thiet-lap-autocorrect.html#AutoFormat_as_you_type\" title=\"AutoFormat as you type\">AutoFormat as you type<\/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-thiet-lap-autocorrect.html#AutoCorrect_actions\" title=\"AutoCorrect actions\">AutoCorrect actions<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-thiet-lap-autocorrect.html#Math_AutoCorrect\" title=\"Math AutoCorrect\">Math AutoCorrect<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 id=\"excel-autocorrect-options\"><span class=\"ez-toc-section\" id=\"Thiet_lap_AutoCorrect_trong_Excel\"><\/span>Thi\u1ebft l\u1eadp AutoCorrect trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 ti\u1ebfn h\u00e0nh thi\u1ebft l\u1eadp AutoCorrect, ta m\u1edf h\u1ed9p tho\u1ea1i AutoCorrect b\u1eb1ng c\u00e1ch:<\/p>\n<ol>\n<li>V\u00e0o\u00a0<strong>File<\/strong><\/li>\n<li>Ch\u1ecdn\u00a0<strong>Options<\/strong><\/li>\n<li>Ch\u1ecdn th\u1ebb\u00a0<strong>Proofing<\/strong><\/li>\n<li>Ch\u1ecdn\u00a0<strong>AutoCorrect Options.<\/strong><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23773\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/autocorrect-1.png\" width=\"835\" height=\"679\" title=\"autocorrect-1\"><\/p>\n<p>Sau khi ch\u1ecdn, h\u1ed9p tho\u1ea1i\u00a0<strong>AutoCorrect<\/strong> s\u1ebd hi\u1ec7n ra, g\u1ed3m c\u00f3 4 th\u1ebb:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23774\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/autocorrect-2.png\" width=\"413\" height=\"403\" title=\"autocorrect-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"AutoCorrect\"><\/span>AutoCorrect<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i th\u1ebb n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y danh s\u00e1ch c\u1ee7a nh\u1eefng k\u00ed t\u1ef1, bi\u1ec3u t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng m\u00e0 c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda, th\u00eam ho\u1eb7c x\u00f3a.<\/p>\n<p>Ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 thao t\u00e1c sau:<\/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-79.gif\" title=\"ex101_92019-nho-79\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li><em>Show AutoCorrect Options buttons<\/em>\u00a0\u2013 hi\u1ec7n ho\u1eb7c \u1ea9n logo AutoCorrect<\/li>\n<\/ul>\n<p>4 n\u00fat ti\u1ebfp theo s\u1ebd ki\u1ec3m so\u00e1t vi\u1ec7c t\u1ef1 \u0111\u1ed9ng s\u1eeda l\u1ed7i:<\/p>\n<ul>\n<li><em>Correct Two Initial Capitals<\/em>\u00a0\u2013 chuy\u1ec3n k\u00fd t\u1ef1 th\u1ee9 2 t\u1eeb vi\u1ebft hoa v\u1ec1 vi\u1ebft th\u01b0\u1eddng.<\/li>\n<li><em>Capitalize first letter of sentence<\/em>\u00a0\u2013 Vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00e2u.<\/li>\n<li><em>Capitalize names of days<\/em>\u00a0\u2013 Vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u ti\u00ean c\u1ee7a ng\u00e0y (Monday, Tuesday\u2026)<\/li>\n<li><em>Correct accidental use of cAPS LOCK key<\/em>\u00a0\u2013 S\u1eeda l\u1ed7i CAPSLOCK (ch\u1eef c\u00e1i \u0111\u1ea7u kh\u00f4ng vi\u1ebft hoa c\u00f2n l\u1ea1i th\u00ec c\u00f3. VD: nGUY\u1ec4N -&gt; Nguy\u1ec5n)<\/li>\n<\/ul>\n<p>L\u1ef1a ch\u1ecdn cu\u1ed1i c\u00f9ng s\u1ebd cho ph\u00e9p b\u1ea1n b\u1eadt ho\u1eb7c t\u1eaft ch\u1ee9c n\u0103ng t\u1ef1 s\u1eeda l\u1ed7i<\/p>\n<ul>\n<li><em>Replace text as you type<\/em>\u00a0\u2013\u00a0b\u1eadt\/t\u1eaft AutoCorrect<\/li>\n<\/ul>\n<p>T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam ho\u1eb7c x\u00f3a nh\u1eefng t\u1eeb theo \u00fd mu\u1ed1n. V\u00ed d\u1ee5:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23781\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/autocorrect-6.png\" width=\"415\" height=\"405\" title=\"autocorrect-6\"><\/p>\n<p>1 s\u1ed1 l\u01b0u \u00fd:<\/p>\n<ul>\n<li>K\u00ed t\u1ef1 bao g\u1ed3m c\u00f4ng th\u1ee9c ho\u1eb7c hyperlinks s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eeda.<\/li>\n<li>M\u1ecdi thay \u0111\u1ed5i s\u1ebd \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng v\u1edbi to\u00e0n b\u1ed9 s\u1ed5 t\u00ednh<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"AutoFormat_as_you_type\"><\/span>AutoFormat as you type<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1i th\u1ebb n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 b\u1eadt ho\u1eb7c t\u1eaft m\u1ed9t s\u1ed1 t\u00f9y ch\u1ecdn:<\/p>\n<ul>\n<li><em>Internet and network paths with hyperlinks<\/em>\u00a0\u2013 khi tr\u1ef1c ti\u1ebfp g\u00f5 \u0111\u1ecba ch\u1ec9 li\u00ean k\u1ebft (link) v\u00e0o, n\u1ebfu gi\u1eef nguy\u00ean li\u00ean k\u1ebft s\u1ebd \u0111\u1ed5i m\u00e0u v\u00e0 chuy\u1ec3n t\u1edbi khi b\u1ea5m v\u00e0o. \u0110\u1ec3 t\u1eaft ch\u1ee9c n\u0103ng n\u00e0y \u0111i ta b\u1ecf ch\u1ecdn.<\/li>\n<li>\n<p><figure id=\"attachment_23777\" aria-describedby=\"caption-attachment-23777\" style=\"width: 256px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-23777\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/autocorrect-3.png\" width=\"256\" height=\"105\" title=\"autocorrect-3\"><figcaption id=\"caption-attachment-23777\" class=\"wp-caption-text\">Tr\u01b0\u1edbc v\u00e0 sau khi t\u1eaft<\/figcaption><\/figure>\n<\/p>\n<\/li>\n<li><em>Include new row and columns in table\u00a0<\/em>\u2013 T\u1ef1 m\u1edf r\u1ed9ng b\u1ea3ng t\u00ednh. T\u1eaft ch\u1ee9c n\u0103ng n\u00e0y \u0111i v\u00e0 b\u1ea1n s\u1ebd kh\u00f4ng lo vi\u1ec7c b\u1ea3ng t\u00ednh (ch\u1ee9c n\u0103ng Table) t\u1ef1 m\u1edf r\u1ed9ng ra n\u1eefa.<\/li>\n<li><em>Fill formulas in tables to create calculated columns\u00a0<\/em>\u2013 \u0110\u1ed1i v\u1edbi b\u1ea3ng t\u00ednh, khi b\u1ea1n t\u1ea1o ra m\u1ed9t c\u1ed9t k\u1ebft qu\u1ea3 v\u00e0 \u1ea5n Enter, c\u00f4ng th\u1ee9c s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c \u0111i\u1ec1n xu\u1ed1ng. B\u1ecf ch\u1ecdn s\u1ebd ng\u0103n ng\u1eeba \u0111i\u1ec1u \u0111\u00f3.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"AutoCorrect_actions\"><\/span>AutoCorrect actions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1eb7c \u0111\u1ecbnh th\u00ec ch\u1ee9c n\u0103ng n\u00e0y s\u1ebd b\u1ecb t\u1eaft \u0111i. Khi b\u1eadt l\u1ea1i v\u00e0 click chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 b\u1ea5t k\u1ef3, m\u1ed9t l\u1ef1a ch\u1ecdn t\u01b0\u01a1ng \u1ee9ng v\u1edbi h\u00e0nh \u0111\u1ed9ng c\u00f3 s\u1eb5n trong danh s\u00e1ch s\u1ebd hi\u1ec7n ra cho b\u1ea1n l\u1ef1a ch\u1ecdn. V\u00ed d\u1ee5 nh\u01b0 \u1edf \u0111\u00e2y, Excel cung c\u1ea5p h\u00e0nh \u0111\u1ed9ng m\u1edf l\u1ecbch Outlook khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng n\u0103m v\u00e0o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23779\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/autocorrect-4.png\" width=\"410\" height=\"401\" title=\"autocorrect-4\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23780\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/autocorrect-5.png\" width=\"398\" height=\"458\" title=\"autocorrect-5\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Math_AutoCorrect\"><\/span>Math AutoCorrect<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Th\u1ebb n\u00e0y ki\u1ec3m so\u00e1t vi\u1ec7c t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t trong Excel (m\u1edf th\u1ebb\u00a0<strong>Insert,\u00a0<\/strong>nh\u00f3m\u00a0<strong>Symbols<\/strong>, ch\u1ecdn\u00a0<strong>Equation):<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23782\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/autocorrect-7.png\" width=\"411\" height=\"404\" title=\"autocorrect-7\"><\/p>\n<p>\u1ee8ng d\u1ee5ng th\u00e0nh th\u1ea1o ch\u1ee9c n\u0103ng n\u00e0y s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian khi x\u1eed l\u00fd d\u1eef li\u1ec7u v\u0103n b\u1ea3n, \u0111\u1ed3ng th\u1eddi t\u1ea1o ra m\u1ed9t t\u1eeb \u0111i\u1ec3n \u0111\u1ecbnh ngh\u0129a t\u1eeb v\u1eeba ng\u1eafn g\u1ecdn, v\u1eeba \u0111\u1ed9c \u0111\u00e1o c\u1ee7a ch\u00ednh b\u1ea1n.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t.<\/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-79.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9689,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9688","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\/9688","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=9688"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9688\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9689"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}