{"id":8204,"date":"2024-12-22T04:12:27","date_gmt":"2024-12-22T04:12:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-cach-sao-chep-cong-thuc-khong-mat-dinh-dang-trong-excel\/"},"modified":"2024-12-22T04:12:27","modified_gmt":"2024-12-22T04:12:27","slug":"huong-dan-cach-sao-chep-cong-thuc-khong-mat-dinh-dang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-cach-sao-chep-cong-thuc-khong-mat-dinh-dang-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c kh\u00f4ng m\u1ea5t \u0111\u1ecbnh d\u1ea1ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong\u00a0Excel ch\u00fang ta th\u01b0\u1eddng hay s\u1eed d\u1ee5ng thao t\u00e1c k\u00e9o \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c xu\u1ed1ng d\u01b0\u1edbi\u00a0\u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho nh\u1eefng\u00a0\u00f4 b\u00ean d\u01b0\u1edbi. Tuy nhi\u00ean trong m\u1ed9t s\u1ed1\u00a0tr\u01b0\u1eddng h\u1ee3p vi\u1ec7c n\u00e0y l\u1ea1i\u00a0x\u1ea3y ra nh\u1eefng k\u1ebft qu\u1ea3 kh\u00f4ng nh\u01b0\u00a0\u00fd. C\u1ee5 th\u1ec3 l\u00e0 c\u00f3 th\u1ec3 g\u00e2y m\u1ea5t\u00a0\u0111\u1ecbnh d\u1ea1ng cho nh\u1eefng\u00a0\u00f4 b\u00ean d\u01b0\u1edbi (v\u00ec thao t\u00e1c n\u00e0y s\u1ebd copy c\u1ea3\u00a0\u0111\u1ecbnh d\u1ea1ng xu\u1ed1ng\u00a0\u00f4 b\u00ean d\u01b0\u1edbi). Trong b\u00e0i vi\u1ebft n\u00e0y <a href=\"https:\/\/hocexcel.online\/\">H\u1ecdc\u00a0Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n\u00a0c\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c kh\u00f4ng m\u1ea5t \u0111\u1ecbnh d\u1ea1ng trong Excel.<\/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-676791aa58296\" 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\/cach-sao-chep-cong-thuc-khong-mat-dinh-dang-trong-excel.html#Loi_keo_cong_thuc_lam_thay_doi_dinh_dang\" title=\"L\u1ed7i k\u00e9o c\u00f4ng th\u1ee9c l\u00e0m thay\u00a0\u0111\u1ed5i\u00a0\u0111\u1ecbnh d\u1ea1ng\">L\u1ed7i k\u00e9o c\u00f4ng th\u1ee9c l\u00e0m thay\u00a0\u0111\u1ed5i\u00a0\u0111\u1ecbnh d\u1ea1ng<\/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\/cach-sao-chep-cong-thuc-khong-mat-dinh-dang-trong-excel.html#Cach_sao_chep_cong_thuc_khong_mat_dinh_dang_trong_Excel\" title=\"C\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c kh\u00f4ng m\u1ea5t \u0111\u1ecbnh d\u1ea1ng trong Excel\">C\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c kh\u00f4ng m\u1ea5t \u0111\u1ecbnh d\u1ea1ng trong 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\/cach-sao-chep-cong-thuc-khong-mat-dinh-dang-trong-excel.html#Tham_khao\" title=\"Tham kh\u1ea3o\">Tham kh\u1ea3o<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Loi_keo_cong_thuc_lam_thay_doi_dinh_dang\"><\/span>L\u1ed7i k\u00e9o c\u00f4ng th\u1ee9c l\u00e0m thay\u00a0\u0111\u1ed5i\u00a0\u0111\u1ecbnh d\u1ea1ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e3y xem v\u00ed d\u1ee5 sau\u00a0\u0111\u00e2y:<\/p>\n<p>Trong b\u1ea3ng d\u1eef li\u1ec7u ch\u00fang ta c\u00f3 c\u1ed9t Date ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng n\u0103m. T\u1ea1i c\u1ed9t Last Date ch\u00fang ta mu\u1ed1n t\u00ecm ng\u00e0y l\u1edbn nh\u1ea5t trong c\u1ed9t Date\u00a0\u0111\u1ec3 c\u00f3 th\u1ec3 so s\u00e1nh t\u1eebng ng\u00e0y v\u1edbi ng\u00e0y cu\u1ed1i c\u00f9ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28944\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fill-down-thong-thuong-trong-excel.png\" width=\"507\" height=\"269\" title=\"fill-down-thong-thuong-trong-excel\"><\/p>\n<p>C\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong\u00a0\u00f4 D2 l\u00e0:<\/p>\n<blockquote>\n<p>=MAX($C$2:$C$9)<\/p>\n<\/blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-max-so-sanh-hai-hoac-nhieu-gia-tri.html\">H\u00e0m MAX<\/a> gi\u00fap t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t. K\u1ebft qu\u1ea3 l\u00e0 ng\u00e0y 23\/12\/2019 l\u00e0 ng\u00e0y c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/p>\n<p>Khi k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb\u00a0\u00f4 D2 t\u1edbi\u00a0\u00f4 D9, ta th\u1ea5y:<\/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-742.gif\" title=\"ex101_92019-nho-742\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28945\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ket-qua-filldown-thong-thuong.png\" width=\"513\" height=\"265\" title=\"ket-qua-filldown-thong-thuong\"><\/p>\n<p>K\u1ebft qu\u1ea3 t\u1ea1i t\u1eebng d\u00f2ng l\u00e0 23\/12\/2019. K\u1ebft qu\u1ea3 n\u00e0y\u00a0\u0111\u00fang, tuy nhi\u00ean vi\u1ec7c\u00a0\u0111\u1ecbnh d\u1ea1ng trong v\u00f9ng D2:D9 l\u1ea1i thay\u00a0\u0111\u1ed5i so v\u1edbi ban\u00a0\u0111\u1ea7u.\u00a0\u0110\u00e2y l\u00e0\u00a0\u0111i\u1ec1u kh\u00f4ng mong mu\u1ed1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_sao_chep_cong_thuc_khong_mat_dinh_dang_trong_Excel\"><\/span>C\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c kh\u00f4ng m\u1ea5t \u0111\u1ecbnh d\u1ea1ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 kh\u1eafc ph\u1ee5c\u00a0l\u1ed7i tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Ch\u1ecdn v\u00f9ng D2:D9 tr\u01b0\u1edbc khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Nh\u1eadp tr\u00ean thanh c\u00f4ng th\u1ee9c l\u00e0 =MAX($C$2:$C$9)<\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>:\u00a0Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm <span style=\"color: #ff0000\"><strong>Ctrl + Enter<\/strong><\/span>\u00a0\u0111\u1ec3 k\u1ebft th\u00fac c\u00f4ng th\u1ee9c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-28946\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ctrl-enter-dien-cong-thuc-khong-mat-dinh-dang.gif\" width=\"659\" height=\"325\" title=\"ctrl-enter-dien-cong-thuc-khong-mat-dinh-dang\"><\/p>\n<p>C\u00f3 th\u1ec3 th\u1ea5y k\u1ebft qu\u1ea3 l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng trong c\u1ed9t Last Date\u00a0\u0111\u1ec1u ra k\u1ebft qu\u1ea3 m\u00e0 kh\u00f4ng b\u1ecb m\u1ea5t\u00a0\u0111\u1ecbnh d\u1ea1ng trong c\u00e1c\u00a0\u00f4. R\u1ea5t\u00a0\u0111\u01a1n\u00a0 gi\u1ea3n v\u00e0 hi\u1ec7u qu\u1ea3 ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tham_khao\"><\/span>Tham kh\u1ea3o<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft sau\u00a0\u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Enter trong\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/phan-biet-3-cach-de-ket-thuc-cong-thuc-trong-excel.html\">Ph\u00e2n bi\u1ec7t 3 c\u00e1ch \u0111\u1ec3 k\u1ebft th\u00fac c\u00f4ng th\u1ee9c trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-dien-cong-thuc-vao-nhieu-o-voi-mot-thao-tac-duy-nhat-ctrl-enter.html\">H\u01b0\u1edbng d\u1eabn \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o nhi\u1ec1u \u00f4 v\u1edbi m\u1ed9t thao t\u00e1c duy nh\u1ea5t (Ctrl + Enter)<\/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-742.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8205,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8204","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\/8204","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=8204"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8204\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8205"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}