{"id":3813,"date":"2024-12-03T04:16:56","date_gmt":"2024-12-03T04:16:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu\/"},"modified":"2024-12-03T04:16:56","modified_gmt":"2024-12-03T04:16:56","slug":"huong-dan-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i d\u1eef li\u1ec7u tham chi\u1ebfu"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n Excel sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel kh\u00e1c m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u1ee9ng th\u00ec ph\u1ea3i l\u00e0m sao? <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd \u0111\u01b0a ra m\u1ed9t s\u1ed1 gi\u1ea3i ph\u00e1p tr\u00ean t\u01b0ng tr\u01b0\u1eddng h\u1ee3p. T\u00f9y thu\u1ed9c v\u00e0o y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n, h\u00e3y ch\u1ecdn m\u1ed9t trong nh\u1eefng c\u00e1ch copy d\u1eef li\u1ec7u trong excel d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/em><\/p>\n<p style=\"text-align: justify\">H\u1ea7u h\u1ebft trong c\u00e1c tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o m\u1ed9t \u00f4 v\u00e0 sao ch\u00e9p n\u00f3 v\u00e0o c\u00e1c \u00f4 kh\u00e1c trong c\u00f9ng c\u1ed9t ho\u1eb7c h\u00e0ng \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n t\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi m\u1ed9t nh\u00f3m d\u1eef li\u1ec7u. N\u1ebfu c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n c\u00f3 ch\u1ee9a \u00f4 tham chi\u1ebfu\u00a0t\u01b0\u01a1ng \u0111\u1ed1i (kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u $), Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ec3 m\u1ed7i c\u00f4ng th\u1ee9c ch\u1ec9 x\u1eed l\u00fd d\u1eef li\u1ec7u trong c\u00f9ng \u00f4 v\u00e0 c\u00f9ng c\u1ed9t. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 c\u00f4ng th\u1ee9c =A1*2 \u1edf \u00f4 B1, v\u00e0 b\u1ea1n copy c\u00f4ng th\u1ee9c t\u1edbi \u00f4 B3, c\u00f4ng th\u1ee9c s\u1ebd \u0111\u1ed5i th\u00e0nh =A3*2.<\/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-674e863747449\" 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-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu.html#Sao_chep_hoac_di_chuyen_mot_cong_thuc_don_le_ma_khong_lam_thay_doi_tham_chieu_o\" title=\"Sao ch\u00e9p ho\u1eb7c di chuy\u1ec3n m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n l\u1ebb m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i tham chi\u1ebfu \u00f4\">Sao ch\u00e9p ho\u1eb7c di chuy\u1ec3n m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n l\u1ebb m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i tham chi\u1ebfu \u00f4<\/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\/huong-dan-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu.html#Sao_chep_mot_vung_du_lieu_cong_thuc_ma_khong_thay_doi_tham_chieu_o\" title=\"Sao ch\u00e9p m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu \u00f4\">Sao ch\u00e9p m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu \u00f4<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu.html#Cach_1_Su_dung_tham_chieu_tuyet_doi_hay_tham_chieu_hon_hop\" title=\"C\u00e1ch 1. S\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i hay tham chi\u1ebfu h\u1ed7n h\u1ee3p\">C\u00e1ch 1. S\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i hay tham chi\u1ebfu h\u1ed7n h\u1ee3p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu.html#Cach_2_Sao_chep_cong_thuc_trong_Excel_ma_khong_thay_doi_tham_chieu_bang_Notepad\" title=\"C\u00e1ch 2. Sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu b\u1eb1ng Notepad\">C\u00e1ch 2. Sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu b\u1eb1ng Notepad<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu.html#Cach_3_Sao_chep_cong_thuc_chinh_xac_bang_cach_dung_Find_and_Replace_cua_Excel\" title=\"C\u00e1ch 3. Sao ch\u00e9p c\u00f4ng th\u1ee9c ch\u00ednh x\u00e1c b\u1eb1ng c\u00e1ch d\u00f9ng Find and Replace c\u1ee7a Excel\">C\u00e1ch 3. Sao ch\u00e9p c\u00f4ng th\u1ee9c ch\u00ednh x\u00e1c b\u1eb1ng c\u00e1ch d\u00f9ng Find and Replace c\u1ee7a Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Sao_chep_hoac_di_chuyen_mot_cong_thuc_don_le_ma_khong_lam_thay_doi_tham_chieu_o\"><\/span>Sao ch\u00e9p ho\u1eb7c di chuy\u1ec3n m\u1ed9t c\u00f4ng th\u1ee9c \u0111\u01a1n l\u1ebb m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i tham chi\u1ebfu \u00f4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel ho\u1eb7c di chuy\u1ec3n ch\u1ec9 m\u1ed9t c\u00f4ng th\u1ee9c, vi\u1ec7c sao ch\u00e9p y h\u1ec7t r\u1ea5t \u0111\u01a1n gi\u1ea3n.<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 v\u1edbi c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p<\/li>\n<li>Ch\u1ecdn c\u00f4ng th\u1ee9c trong thanh c\u00f4ng th\u1ee9c b\u1eb1ng chu\u1ed9t, nh\u1ea5n Ctrl + C \u0111\u1ec3 sao ch\u00e9p. N\u1ebfu b\u1ea1n mu\u1ed1n di chuy\u1ec3n c\u00f4ng th\u1ee9c, nh\u1ea5n Ctrl + X.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5416 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-1-2.png\" width=\"368\" height=\"201\" title=\"12-1-2\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5n ph\u00edm Esc \u0111\u1ec3 tho\u00e1t kh\u1ecfi thanh c\u00f4ng th\u1ee9c.<\/li>\n<li>Ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n d\u00e1n c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Ctrl + V.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch 2:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 c\u00f3 c\u00f4ng th\u1ee9c b\u1ea1n mu\u1ed1n sao ch\u00e9p<\/li>\n<li>Nh\u1ea5n F2 ho\u1eb7c click chu\u1ed9t \u0111\u00f4i \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eeda \u0111\u1ed5i \u00f4 \u0111\u00f3<\/li>\n<li>Ch\u1ecdn c\u00f4ng th\u1ee9c trong \u00f4 b\u1eb1ng c\u00e1ch d\u00f9ng chu\u1ed9t v\u00e0 Ctrl + C \u0111\u1ec3 sao ch\u00e9p.<\/li>\n<li>Ch\u1ecdn \u00f4 \u0111\u1ec3 d\u00e1n c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Ctrl + V. B\u1ea1n s\u1ebd c\u00f3 th\u1ec3 d\u00e1n c\u00f4ng th\u1ee9c ch\u00ednh x\u00e1c m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu c\u1ee7a \u00f4 v\u00ec c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c copy d\u01b0\u1edbi d\u1ea1ng ch\u1eef.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5417 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/13-1-2.png\" width=\"339\" height=\"205\" title=\"13-1-2\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.<\/strong> \u0110\u1ec3 nhanh ch\u00f3ng copy c\u00f4ng th\u1ee9c t\u1eeb nh\u1eefng \u00f4 ph\u00eda tr\u00ean m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu, ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n d\u00e1n c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Ctrl + \u2018<\/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-299.gif\" title=\"ex101_92019-nho-299\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Sao_chep_mot_vung_du_lieu_cong_thuc_ma_khong_thay_doi_tham_chieu_o\"><\/span>Sao ch\u00e9p m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu \u00f4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 di chuy\u1ec3n hay sao ch\u00e9p v\u00f9ng d\u1eef li\u1ec7u c\u00f4ng th\u1ee9c \u0111\u1ec3 m\u00e0 kh\u00f4ng c\u00f3 tham chi\u1ebfu \u00f4 n\u00e0o b\u1ecb thay \u0111\u1ed5i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch th\u1ee9c sau.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_1_Su_dung_tham_chieu_tuyet_doi_hay_tham_chieu_hon_hop\"><\/span>C\u00e1ch 1. S\u1eed d\u1ee5ng tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i hay tham chi\u1ebfu h\u1ed7n h\u1ee3p<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u1ea7n ph\u1ea3i sao ch\u00e9p ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c v\u1edbi tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i (nh\u01b0 A1), c\u00e1ch t\u1ed1t nh\u1ea5t l\u00e0 \u0111\u1ed5i n\u00f3 th\u00e0nh tham chi\u1ebfu tuy\u1ec7t \u0111\u1ed1i ($A$1) \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu n\u00e0y \u0111\u1ed1i v\u1edbi \u00f4, nh\u01b0 v\u1eady n\u00f3 s\u1ebd gi\u1eef nguy\u00ean d\u00f9 b\u1ea1n c\u00f3 di chuy\u1ec3n c\u00f4ng th\u1ee9c \u0111i \u0111\u00e2u \u0111i ch\u0103ng n\u1eefa. B\u00ean cnahj d\u00f3, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p ($A1 ho\u1eb7c A$1) \u0111\u1ec3 kh\u00f3a c\u1ed9t ho\u1eb7c h\u00e0ng. B\u1ea1n ngh\u0129 r\u1eb1ng c\u00e1ch n\u00e0y kh\u00f4ng h\u1ee3p l\u00fd ch\u00fat n\u00e0o? V\u1eady h\u00e3y c\u00f9ng xem x\u00e9t v\u00ed d\u1ee5 sau nh\u00e9.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh to\u00e1n gi\u00e1 hoa qu\u1ea3 \u1edf theo \u0111\u1ed3ng Euro d\u1ef1a tr\u00ean gi\u00e1 USD \u1edf c\u1ed9t B v\u00e0 t\u1ec9 gi\u00e1 \u1edf \u00f4 C2:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5418 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/14-1-1.png\" width=\"276\" height=\"265\" title=\"14-1-1\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u1edf \u1ea3nh tr\u00ean, c\u00f4ng th\u1ee9c bao g\u1ed3m m\u1ed9t tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i ($C$2) nh\u1eb1m c\u1ed1 \u0111\u1ecbnh t\u1ef7 gi\u00e1 \u1edf \u00f4 C2, v\u00e0 m\u1ed9t tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i \u1edf \u00f4 B5 v\u00ec b\u1ea1n mu\u1ed1n tham chi\u1ebfu n\u00e0y \u0111i\u1ec1u ch\u1ec9nh \u1edf m\u1ed7i h\u00e0ng. C\u00e1ch ti\u1ebfp c\u1eadn n\u00e0y s\u1ebd hi\u1ec7u qu\u1ea3 mi\u1ec5n l\u00e0 khi n\u00e0o c\u00f4ng th\u1ee9c v\u1eabn \u1edf c\u1ed9t C.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng h\u00e3y xem th\u1eed \u0111i\u1ec1u g\u00ec x\u1ea3y ra n\u1ebfu b\u1ea1n c\u1ea7n chuy\u1ec3n gi\u00e1 theo Euro t\u1eeb c\u1ed9t C sang c\u1ed9t F. N\u1ebfu b\u1ea1n copy c\u00f4ng th\u1ee9c theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng b\u1eb1ng c\u00f4ng c\u1ee5 copy\/paste, c\u00f4ng th\u1ee9c \u1edf \u00f4 C5 (=B5*$C$2) s\u1ebd \u0111\u1ed5i th\u00e0nh =D5*$C$2 khi d\u00e1n v\u00e0o \u00f4 F5, khi\u1ebfn vi\u1ec7c t\u00ednh to\u00e1n b\u1ecb sai.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u00e1nh t\u00ecnh tr\u1ea1ng n\u00e0y, h\u00e3y chuy\u1ec3n tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i (B5) th\u00e0nh tham chi\u1ebfu h\u1ed7n h\u1ee3p $B5 (c\u1ed9t tuy\u1ec7t \u0111\u1ed1i v\u00e0 d\u00f2ng t\u01b0\u01a1ng \u0111\u1ed1i). B\u1eb1ng vi\u1ec7c th\u00eam k\u00fd hi\u1ec7u $ tr\u01b0\u1edbc m\u1ed7i k\u00fd t\u1ef1 c\u1ee7a c\u1ed9t, b\u1ea1n \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh tham chi\u1ebfu \u1edf c\u1ed9t B d\u00f9 cho c\u00f4ng th\u1ee9c di chuy\u1ec3n nh\u01b0 th\u1ebf n\u00e0o.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n sao ch\u00e9p hay di chuy\u1ec3n c\u00f4ng th\u1ee9c t\u1eeb c\u1ed9t D sang c\u1ed9t F, hay b\u1ea5t c\u1ee9 c\u1ed9t n\u00e0o, tham chi\u1ebfu c\u1ed9t s\u1ebd kh\u00f4ng thay \u0111\u1ed5i v\u00ec b\u1ea1n \u0111\u00e3 \u2018kh\u00f3a\u2019 tham chi\u1ebfu b\u1eb1ng k\u00fd hi\u1ec7u $ ($B5).<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5419 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/15-1-1.png\" width=\"498\" height=\"261\" title=\"15-1-1\"><\/p>\n<p style=\"text-align: justify\">Tham chi\u1ebfu \u00f4 trong Excel c\u00f3 th\u1ec3 kh\u00f3 \u0111\u1ec3 h\u00ecnh dung khi m\u1edbi b\u1eaft \u0111\u1ea7u, nh\u01b0ng n\u00f3 s\u1ebd x\u1ee9ng \u0111\u00e1ng th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c c\u1ee7a b\u1ea1n v\u00ec ch\u00fang ti\u1ebft ki\u1ec7m nhi\u1ec1u th\u1eddi gian cho b\u1ea1n m\u1ed9t c\u00e1ch l\u00e2u d\u00e0i. V\u00ed d\u1ee5, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u00ednh to\u00e1n to\u00e0n b\u1ed9 b\u1ea3ng ch\u1ec9 v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 h\u1ed7n h\u1ee3p.<\/p>\n<p style=\"text-align: justify\">Tuy nhi\u00ean, n\u1ebfu b\u1ea1n c\u00f3 r\u1ea5t nhi\u1ec1u c\u00f4ng th\u1ee9c v\u1edbi tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i trong trang t\u00ednh v\u00e0 b\u1ea1n c\u1ea7n sao ch\u00e9p ch\u00ednh x\u00e1c nh\u1eefng c\u00f4ng th\u1ee9c \u0111\u00f3 nh\u01b0ng b\u1ea1n kh\u00f4ng ch\u1eafc b\u1ea1n c\u00f3 th\u1ec3 tham chi\u1ebfu \u0111\u00fang, m\u1ed9t trong v\u00e0i c\u00e1ch sau c\u00f3 th\u1ec3 l\u00e0 gi\u1ea3i ph\u00e1p cho b\u1ea1n.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_2_Sao_chep_cong_thuc_trong_Excel_ma_khong_thay_doi_tham_chieu_bang_Notepad\"><\/span>C\u00e1ch 2. Sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu b\u1eb1ng Notepad<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">1. \u0110i\u1ec1n c\u00f4ng th\u1ee9c \u1edf ch\u1ebf \u0111\u1ed9 hi\u1ec3n th\u1ecb b\u1eb1ng c\u00e1ch nh\u1ea5n Ctrl + `, ho\u1eb7c b\u1eb1ng b\u1ea5t c\u1ee9 ph\u01b0\u01a1ng th\u1ee9c n\u00e0o trong b\u00e0i vi\u1ebft C\u00e1ch hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong Excel.<br \/>\n2. Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 v\u1edbi c\u00f4ng th\u1ee9c b\u1ea1n mu\u1ed1n sao ch\u00e9p hay di chuy\u1ec3n<br \/>\n3. Nh\u1ea5n Ctrl + C \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c, ho\u1eb7c Ctrl + X \u0111\u1ec3 di chuy\u1ec3n c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5420 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/16-1-1.png\" width=\"582\" height=\"225\" title=\"16-1-1\"><br \/>\n4. M\u1edf Notepad hay b\u1ea5t c\u1ee9 c\u00f4ng c\u1ee5 ch\u1ec9nh s\u1eeda v\u0103n b\u1ea3n n\u00e0o v\u00e0 nh\u1ea5n Ctrl + C \u0111\u1ec3 d\u00e1n c\u00f4ng th\u1ee9c v\u00e0o c\u00f4ng c\u1ee5 \u0111\u00f3, sau \u0111\u00f3 ch\u1ecdn Ctrl + A \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Ctrl + C \u0111\u1ec3 sao ch\u00e9p ch\u00fang.<br \/>\n5. Trong Excel, b\u1ea1n ch\u1ecdn \u00f4 mu\u1ed1n d\u00e1n c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n Ctrl + V.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd: <\/strong><br \/>\n1. B\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 d\u00e1n c\u00f4ng th\u1ee9c t\u1ea1i c\u00f9ng 1 trang t\u00ednh n\u01a1i ch\u1ee9a c\u00f4ng th\u1ee9c g\u1ed1c, tr\u1eeb khi tham chi\u1ebfu c\u00f3 bao g\u1ed3m t\u00ean c\u1ee7a trang t\u00ednh, n\u1ebfu kh\u00f4ng c\u00f4ng th\u1ee9c s\u1ebd b\u1ecb h\u1ecfng.<br \/>\n2. Trang chi\u1ebfu n\u00ean \u1edf trong ch\u1ebf \u0111\u1ed9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c. \u0110\u1ec3 ki\u1ec3m tra, h\u00e3y v\u00e0o Formulas &gt; Formula Auditing v\u00e0 ki\u1ec3m tra ph\u1ea7n Show Formulas c\u00f3 \u0111\u01b0\u1ee3c ch\u1ecdn hay kh\u00f4ng. Sau khi \u0111i d\u00e1n c\u00f4ng th\u1ee9c, nh\u1ea5n Ctrl + ` \u0111\u1ec3 \u0111\u00f3ng ch\u1ebf \u0111\u1ed9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_3_Sao_chep_cong_thuc_chinh_xac_bang_cach_dung_Find_and_Replace_cua_Excel\"><\/span>C\u00e1ch 3. Sao ch\u00e9p c\u00f4ng th\u1ee9c ch\u00ednh x\u00e1c b\u1eb1ng c\u00e1ch d\u00f9ng Find and Replace c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">\u0110\u1ec3 sao ch\u00e9p m\u1ed9t d\u00e3y c\u00e1c c\u00f4ng th\u1ee9c c\u1ee7a Excel m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i tham chi\u1ebfu \u00f4, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng c\u1ee5 Find and Replace c\u1ee7a Excel.<\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn \u00f4 c\u00f3 c\u00f4ng th\u1ee9c b\u1ea1n mu\u1ed1n sao ch\u00e9p.<br \/>\n2. \u1ede thanh Home, b\u1ea1n v\u00e0o Editing, ch\u1ecdn Find &amp; Select &gt; Replace\u2026 Ho\u1eb7c \u0111\u01a1n gi\u1ea3n h\u01a1n, nh\u1ea5n ph\u00edm Ctrl + H l\u00e0 \u0111\u01b0\u1eddng t\u1eaft \u0111\u1ec3 m\u1edfi h\u1ed9p tho\u1ea1i Find &amp; Replace tr\u00ean Excel.<br \/>\n3. Trong c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i Find &amp; Replace, \u0111\u00e1nh d\u1ea5u = v\u00e0o \u00f4 Find what. Trong \u00f4 Replace with, \u0111i\u1ec1n m\u1ed9t v\u00e0o k\u00fd hi\u1ec7u hay d\u00e3y k\u00fd hi\u1ec7u kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong b\u1ea5t c\u1ee9 c\u00f4ng th\u1ee9c n\u00e0o nh\u01b0 ~, # hay .<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5400 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/17.png\" width=\"457\" height=\"200\" title=\"17\"><\/p>\n<p style=\"text-align: justify\">M\u1ee5c \u0111\u00edch c\u1ee7a b\u01b0\u1edbc n\u00e0y l\u00e0 bi\u1ebfn c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n th\u00e0nh d\u00e3y v\u0103n b\u1ea3n, ng\u0103n kh\u00f4ng cho Excel thay \u0111\u1ed5i tham chi\u1ebfu \u00f4 trong su\u1ed1t qu\u00e1 tr\u00ecnh sao ch\u00e9p.<\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> Kh\u00f4ng s\u1eed d\u1ee5ng d\u1ea5u hoa th\u1ecb (*) hay d\u1ea5u h\u1ecfi (?) \u0111\u1ec3 thay th\u1ebf v\u00ec ch\u00fang s\u1ebd khi\u1ebfn nh\u1eefng b\u01b0\u1edbc sau tr\u1edf n\u00ean kh\u00f3 kh\u0103n h\u01a1n.<\/p>\n<p style=\"text-align: justify\">4. Click v\u00e0o \u00f4 Replace All trong h\u1ed9i tho\u1ea1i v\u00e0 \u0111\u00f3ng c\u1eeda s\u1ed5 Find and Replace. T\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c trong v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd bi\u1ebfn th\u00e0nh d\u00e3y v\u0103n b\u1ea3n:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5422 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/18-1-1.png\" width=\"579\" height=\"160\" title=\"18-1-1\"><\/p>\n<p style=\"text-align: justify\">5. B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn b\u1ea5t c\u1ee9 \u00f4 n\u00e0o, ch\u1ecdn Ctrl + C \u0111\u1ec3 copy, ch\u1ecdn \u00f4 tr\u00ean c\u00f9ng trong trang t\u00ednh m\u00e0 b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c n\u01a1i b\u1ea1n mu\u1ed1n d\u00e1n c\u00f4ng th\u1ee9c, v\u00e0 nh\u1ea5n Ctrl + V. V\u00ec Excel kh\u00f4ng thay \u0111\u1ed5i c\u00f4ng th\u1ee9c kh\u00f4ng c\u00f3 d\u1ea5u = ph\u00eda tr\u01b0\u1edbc, ch\u00fang s\u1ebd \u0111\u01b0\u1ee3c sao ch\u00e9p y h\u1ec7t m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu.<\/p>\n<p style=\"text-align: justify\">6. D\u00f9ng Find &amp; Replace \u0111\u1ec3 \u0111\u1ea3o ng\u01b0\u1ee3c s\u1ef1 thay \u0111\u1ed5i n\u00e0y. Ch\u1ecdn c\u1ea3 v\u00f9ng d\u1eef li\u1ec7u copy v\u00e0 v\u00f9ng d\u1eef li\u1ec7u d\u00e1n c\u00f4ng th\u1ee9c. Nh\u1ea5n Ctrl + H \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Find &amp; Replace. \u1ede \u00f4 Find what, h\u00e3y \u0111i\u1ec1n  ho\u1eb7c b\u1ea5t c\u1ee9 k\u00fd hi\u1ec7u n\u00e0o m\u00e0 b\u1ea1n \u0111\u00e3 d\u00f9ng \u1edf b\u01b0\u1edbc 3. \u1ede \u00f4 Replace with, \u0111i\u1ec1n v\u00e0o \u0111\u00f3 d\u1ea5u = v\u00e0 click n\u00fat Replace All \u0111\u1ec3 ho\u00e0n th\u00e0nh.<\/p>\n<p>\u2013 \u2013 \u2013 \u2013 \u2013 \u2013<\/p>\n<p>\u0110\u00f3 l\u00e0 m\u1ed9t v\u00e0i c\u00e1ch \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i d\u1eef li\u1ec7u tham chi\u1ebfu hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 c\u00e1ch copy d\u1eef li\u1ec7u trong excel. \u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc <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 \u0111\u1ebfn chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/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-299.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3814,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3813","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\/3813","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=3813"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3813\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3814"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}