{"id":1975,"date":"2024-12-02T06:39:59","date_gmt":"2024-12-02T06:39:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/4-cach-danh-so-thu-tu-trong-excel-2007-2010-2013-2016\/"},"modified":"2024-12-02T06:39:59","modified_gmt":"2024-12-02T06:39:59","slug":"4-cach-danh-so-thu-tu-trong-excel-2007-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/4-cach-danh-so-thu-tu-trong-excel-2007-2010-2013-2016\/","title":{"rendered":"4 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel 2007, 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>C\u00f4ng vi\u1ec7c th\u1ed1ng k\u00ea b\u1eb1ng excel s\u1ebd \u0111\u01a1n gi\u1ea3n ph\u1ea7n n\u00e0o khi b\u1ea1n thu\u1ea7n th\u1ee5c 4 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel n\u00e0y, gi\u1ea3i quy\u1ebft nhanh g\u1ecdn \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 \u00edt ho\u1eb7c nhi\u1ec1u hay c\u1ef1c nhi\u1ec1u. V\u1edbi b\u00e0i vi\u1ebft n\u00e0y,\u00a0\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Blog H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn cho c\u00e1c b\u1ea1n\u00a04 c\u00e1ch<strong> \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel 2007, 2010, 2013, 2016 c\u1ef1c k\u1ef3 hi\u1ec7u qu\u1ea3.<\/strong><\/p>\n<p>\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel g\u1ed3m hai d\u1ea1ng: li\u00ean t\u1ee5c (\u0111\u1ec1u \u0111\u1eb7n t\u1eeb 1,2,3,\u2026) ho\u1eb7c kh\u00f4ng li\u00ean t\u1ee5c (2,4,6,8,\u2026) d\u00f9 \u1edf d\u1ea1ng n\u00e0o \u0111\u1ec1u c\u00f3 ph\u01b0\u01a1ng \u00e1n h\u1ee3p l\u00fd \u1edf ngay trong 4 c\u00e1ch sau.<\/p>\n<p><strong>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel th\u1ee9 1:<\/strong><\/p>\n<p>\u0110\u00e1nh s\u1ed1 tr\u1ef1c ti\u1ebfp v\u00e0o t\u1eebng \u00f4 trong excel, \u0111\u00e2y l\u00e0 c\u00e1ch th\u1ee7 c\u00f4ng nh\u1ea5t d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng khi l\u01b0\u1ee3ng s\u1ed1 th\u1ee9 t\u1ef1 kh\u00f4ng qu\u00e1 nhi\u1ec1u. V\u1edbi l\u01b0\u1ee3ng s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb 30 tr\u1edf l\u00ean ch\u1eafc ch\u1eafn s\u1ebd th\u00e0nh tr\u1edf ng\u1ea1i l\u1edbn cho c\u00f4ng vi\u1ec7c th\u1ed1ng k\u00ea.<\/p>\n<figure id=\"attachment_3899\" aria-describedby=\"caption-attachment-3899\" style=\"width: 265px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3899\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1.gif\" width=\"265\" height=\"202\" title=\"1\"><figcaption id=\"caption-attachment-3899\" class=\"wp-caption-text\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel th\u1ee7 c\u00f4ng<\/figcaption><\/figure>\n<blockquote>\n<p>T\u00e0i li\u1ec7u tham kh\u1ea3o:\u00a0c\u00e1ch h\u1ecdc Excel 2010,\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2013\">t\u1ef1 h\u1ecdc excel 2013<\/a>,\u00a0h\u1ecdc Excel 2016, h\u1ecdc Excel 2020<\/p>\n<\/blockquote>\n<p><strong>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel th\u1ee9 2: <\/strong><\/p>\n<p>\u0110\u00e1nh s\u1ed1 b\u1eb1ng k\u00e9o chu\u1ed9t. Ch\u1ec9 v\u1edbi hai b\u01b0\u1edbc:<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 cho 2 \u00f4\u00a0\u0111\u1ea7u ti\u00ean<\/li>\n<li>B\u01b0\u1edbc 2: b\u00f4i \u0111en 2 \u00f4 v\u1eeba \u0111i\u1ec1n s\u1ed1, sau \u0111\u00f3 \u0111\u1eb7t chu\u1ed9t \u1edf g\u00f3c \u00f4 cho \u0111\u1ebfn khi chu\u1ed9t hi\u1ec7n th\u00e0nh d\u1ea5u c\u1ed9ng, b\u1eaft \u0111\u1ea7u k\u00e9o xu\u1ed1ng m\u1ee9c th\u1ee9 t\u1ef1 ta mu\u1ed1n.<\/li>\n<\/ul>\n<p>Quan s\u00e1t h\u00ecnh \u1ea3nh th\u1ef1c h\u00e0nh:<\/p>\n<figure id=\"attachment_3900\" aria-describedby=\"caption-attachment-3900\" style=\"width: 265px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3900 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2.gif\" width=\"265\" height=\"202\" title=\"2\"><figcaption id=\"caption-attachment-3900\" class=\"wp-caption-text\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel b\u1eb1ng chu\u1ed9t<\/figcaption><\/figure>\n<p>\u1ede c\u00e1ch th\u1ee9 2 n\u00e0y, vi\u1ec7c \u0111i\u1ec1n s\u1ed1 cho 2 \u00f4 \u0111\u1ea7u ti\u00ean nh\u1eb1m n\u00eau quy lu\u1eadt th\u1ee9 t\u1ef1 b\u1ea1n mong mu\u1ed1n, khi k\u00e9o th\u1ea3 l\u00e0 b\u1ea1n \u0111ang nh\u00e2n r\u1ed9ng quy lu\u1eadt \u0111\u00f3 sang c\u00e1c \u00f4 ti\u1ebfp theo. V\u00ed d\u1ee5 nh\u01b0 b\u1ea1n mu\u1ed1n quy lu\u1eadt ch\u1ec9 s\u1ed1 l\u1ebb, b\u1ea1n \u0111i\u1ec1n hai \u00f4 \u0111\u1ea7u l\u00e0 1 v\u00e0 3, sau \u0111\u00f3 k\u00e9o th\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 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\/2024\/12\/ex101_92019-nho-146.gif\" title=\"ex101_92019-nho-146\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_3901\" aria-describedby=\"caption-attachment-3901\" style=\"width: 270px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3901\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3.gif\" width=\"270\" height=\"263\" title=\"3\"><figcaption id=\"caption-attachment-3901\" class=\"wp-caption-text\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel b\u1eb1ng chu\u1ed9t (v\u00ed d\u1ee5 2)<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p><strong>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel th\u1ee9 3:<\/strong> \u0111\u00e1nh s\u1ed1 b\u1eb1ng c\u00f4ng th\u1ee9c. Ch\u1ec9 v\u1edbi hai b\u01b0\u1edbc:<\/p>\n<ul>\n<li>B\u01b0\u1edbc 1: \u0111i\u1ec1n s\u00f4 th\u1ee9 t\u1ef1 cho \u00f4 \u0111\u1ea7u ti\u00ean<\/li>\n<li>B\u01b0\u1edbc 2: nh\u1eadp c\u00f4ng th\u1ee9c =v\u1ecb tr\u00ed \u00f4 v\u1eeba \u0111i\u1ec1n+n (t\u00f9y \u00fd b\u1ea1n mu\u1ed1n quy lu\u1eadt s\u1ed1 th\u1ee9 t\u1ef1 nh\u01b0 th\u1ebf n\u00e0o, li\u00ean t\u1ee5c th\u00ec n=1, l\u1ebb s\u1ed1 n=2,\u2026)<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 th\u1ef1c h\u00e0nh nh\u01b0 sau:<\/p>\n<figure id=\"attachment_3902\" aria-describedby=\"caption-attachment-3902\" style=\"width: 270px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3902\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4.gif\" width=\"270\" height=\"263\" title=\"4\"><figcaption id=\"caption-attachment-3902\" class=\"wp-caption-text\">C\u00e1ch th\u1ee9 3\u00a0b\u1eb1ng c\u00f4ng th\u1ee9c<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p><strong>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong excel th\u1ee9 4<\/strong><em><strong>:<\/strong><\/em> \u0111\u00e1nh s\u1ed1 b\u1eb1ng thanh c\u00f4ng c\u1ee5 Fill. H\u01b0\u1edbng d\u1eabn c\u1ef1c \u0111\u1ea7y \u0111\u1ee7 t\u1ea1i \u0111\u00e2y, b\u1ea1n theo d\u00f5i nh\u00e9.<\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/danh-thu-tu-tu-dong-trong-excel-voi-ham-subtotal.html\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng trong Excel v\u1edbi h\u00e0m SUBTOTAL<\/a><\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng: v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y. H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u1ecdc Excel Online<\/a><\/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\/2024\/12\/ex101_92019-nho-146.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1976,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1975","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\/1975","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=1975"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1975\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1976"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}