{"id":5236,"date":"2024-12-10T05:30:06","date_gmt":"2024-12-10T05:30:06","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel\/"},"modified":"2024-12-10T05:30:06","modified_gmt":"2024-12-10T05:30:06","slug":"huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1c k\u1ef9 thu\u1eadt sao ch\u00e9p c\u00f4ng th\u1ee9c theo \u00fd mu\u1ed1n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, <a href=\"https:\/\/hocexcel.online\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t v\u00e0i c\u00e1ch kh\u00e1c nhau \u0111\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-sao-chep-cong-thuc-trong-excel-ma-khong-lam-thay-doi-du-lieu-tham-chieu.html\"><strong>sao ch\u00e9p c\u00f4ng th\u1ee9c trong excel<\/strong><\/a> \u2013 c\u00e1ch copy c\u00f4ng th\u1ee9c b\u1eb1ng vi\u1ec7c k\u00e9o c\u1ed9t d\u1ecdc, c\u00e1ch copy v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn, c\u00e1ch copy m\u1ed9t c\u00f4ng th\u1ee9c ch\u00ednh x\u00e1c m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i tham chi\u1ebfu \u00f4 hay format, v\u00e0 nhi\u1ec1u c\u00e1ch th\u1ee9c kh\u00e1c n\u1eefa.<\/em><\/p>\n<p style=\"text-align: justify\">Sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng vi\u1ec7c \u0111\u01a1n gi\u1ea3n nh\u1ea5t, th\u00f4ng th\u01b0\u1eddng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n ch\u1ec9 trong m\u1ed9t c\u00fa click chu\u1ed9t. N\u00f3i \u201cth\u00f4ng th\u01b0\u1eddng\u201d l\u00e0 v\u00ec c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p \u0111i\u1ec3n h\u00ecnh c\u1ea7n \u0111\u1ebfn nh\u1eefng m\u1eb9o \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 th\u1ef1c hi\u1ec7n, v\u00ed d\u1ee5 nh\u01b0 copy m\u1ed9t d\u00e3y c\u00e1c c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i tham chi\u1ebfu \u00f4, ho\u1eb7c c\u00f9ng nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o nh\u1eefng \u00f4 kh\u00f4ng li\u00ean k\u1ec1 trong excel.<\/p>\n<p style=\"text-align: justify\">May m\u1eafn thay, trong Microsoft Excel c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch \u0111\u1ec3 ta th\u1ef1c hi\u1ec7n m\u1ed9t c\u00f4ng vi\u1ec7c v\u00e0 cho ra m\u1ed9t k\u1ebft qu\u1ea3 duy nh\u1ea5t, \u0111i\u1ec1u n\u00e0y \u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 v\u1edbi vi\u1ec7c sao ch\u00e9p c\u00e1c c\u00f4ng th\u1ee9c. Trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, ta s\u1ebd b\u00e0n \u0111\u1ebfn nh\u1eefng c\u00e1ch th\u1ee9c kh\u00e1c nhau \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1ch th\u1ee9c n\u00e0o ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi nhu c\u1ea7u c\u1ee7a m\u00ecnh.<\/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-6757d1ddaccd4\" 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-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html#Sao_chep_cong_thuc_bang_cach_keo_cot_doc\" title=\"Sao ch\u00e9p c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch k\u00e9o c\u1ed9t d\u1ecdc:\">Sao ch\u00e9p c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch k\u00e9o c\u1ed9t d\u1ecdc:<\/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-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html#Cach_sao_chep_cong_thuc_bang_cach_keo_cot_doc_ma_khong_sao_chep_dinh_dang\" title=\"C\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch k\u00e9o c\u1ed9t d\u1ecdc m\u00e0 kh\u00f4ng sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng:\">C\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch k\u00e9o c\u1ed9t d\u1ecdc m\u00e0 kh\u00f4ng sao ch\u00e9p \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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html#Sao_chep_cong_thuc_cho_toan_bo_cot\" title=\"Sao ch\u00e9p c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u1ed9t:\">Sao ch\u00e9p c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u1ed9t:<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html#Click_chuot_doi_vao_dau_cong_de_copy_cho_toan_bo_cot\" title=\"Click chu\u1ed9t \u0111\u00f4i v\u00e0o d\u1ea5u c\u1ed9ng \u0111\u1ec3 copy cho to\u00e0n b\u1ed9 c\u1ed9t:\">Click chu\u1ed9t \u0111\u00f4i v\u00e0o d\u1ea5u c\u1ed9ng \u0111\u1ec3 copy cho to\u00e0n b\u1ed9 c\u1ed9t:<\/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-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html#Cach_sao_chep_mot_cong_thuc_Excel_nhung_khong_dinh_dang\" title=\"C\u00e1ch sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c Excel nh\u01b0ng kh\u00f4ng \u0111\u1ecbnh d\u1ea1ng:\">C\u00e1ch sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c Excel nh\u01b0ng kh\u00f4ng \u0111\u1ecbnh d\u1ea1ng:<\/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-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html#Nhung_cach_lam_tat_de_sao_chep_cong_thuc_Excel_den_cac_o_khac\" title=\"Nh\u1eefng c\u00e1ch l\u00e0m t\u1eaft \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c Excel \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c\">Nh\u1eefng c\u00e1ch l\u00e0m t\u1eaft \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c Excel \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html#1_Sao_chep_cong_thuc_den_o_ngay_duoi\" title=\"1. Sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn \u00f4 ngay d\u01b0\u1edbi\">1. Sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn \u00f4 ngay d\u01b0\u1edbi<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html#2_Sao_chep_cong_thuc_sang_ben_phai\" title=\"2. Sao ch\u00e9p c\u00f4ng th\u1ee9c sang b\u00ean ph\u1ea3i\">2. Sao ch\u00e9p c\u00f4ng th\u1ee9c sang b\u00ean ph\u1ea3i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html#3_Sao_chep_cong_thuc_vao_o_ngay_duoi_mot_cach_chinh_xac\" title=\"3. Sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o \u00f4 ngay d\u01b0\u1edbi m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c:\">3. Sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o \u00f4 ngay d\u01b0\u1edbi m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c:<\/a><\/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_cong_thuc_bang_cach_keo_cot_doc\"><\/span>Sao ch\u00e9p c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch k\u00e9o c\u1ed9t d\u1ecdc:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Microsoft Excel cung c\u1ea5p m\u1ed9t c\u00e1ch r\u1ea5t nhanh \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch k\u00e9o c\u1ed9t d\u1ecdc. B\u1ea1n ch\u1ec9 c\u1ea7n l\u00e0m nh\u01b0 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o \u00f4 tr\u00ean c\u00f9ng<\/li>\n<li>Ch\u1ecdn \u00f4 c\u00f3 c\u00f4ng th\u1ee9c, l\u00fac n\u00e0y \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd chuy\u1ec3n th\u00e0nh m\u00e0u \u0111en. K\u00e9o chu\u1ed9t \u0111\u1ebfn h\u00ecnh vu\u00f4ng nh\u1ecf n\u1eb1m \u1edf g\u00f3c b\u00ean ph\u1ea3i d\u01b0\u1edbi c\u00f9ng c\u1ee7a \u00f4 m\u00e0u \u0111en \u0111\u01b0\u1ee3c ch\u1ecdn (h\u00ecnh vu\u00f4ng nh\u1ecf n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 Fill handle). Fill handle s\u1ebd \u0111\u1ed5i th\u00e0nh m\u1ed9t d\u1ea5u c\u1ed9ng m\u00e0u \u0111en \u0111\u1eadm.<\/li>\n<li>Gi\u1eef v\u00e0 k\u00e9o fill handle xu\u1ed1ng c\u1ed9t d\u1ecdc \u0111\u1ebfn h\u1ebft \u00f4 b\u1ea1n mu\u1ed1n sao ch\u00e9p c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5426 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-copy-formula-1.png\" width=\"437\" height=\"218\" title=\"excel-copy-formula-1\"><\/p>\n<p style=\"text-align: justify\">V\u1edbi c\u00e1ch th\u1ee9c t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c v\u00e0o c\u00e1c \u00f4 li\u00ean k\u1ec1 \u1edf ph\u00eda b\u00ean ph\u1ea3i, b\u00ean tr\u00e1i hay l\u00ean tr\u00ean.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu c\u00f4ng th\u1ee9c c\u00f3 m\u1ed9t tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i (relative cell references \u2013 tham chi\u1ebfu kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u $), n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i d\u1ef1a tr\u00ean v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a h\u00e0ng v\u00e0 c\u1ed9t. V\u00ec v\u1eady, sau khi copy c\u00f4ng th\u1ee9c, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng tham chi\u1ebfu \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh h\u1ee3p l\u00fd v\u00e0 mang l\u1ea1i k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n c\u1ea7n. N\u1ebfu c\u1ea7n thi\u1ebft, h\u00e3y chuy\u1ec3n \u0111\u1ed5i gi\u1eefa tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i, tuy\u1ec7t \u0111\u1ed1i v\u00e0 h\u1ed7n h\u1ee3p b\u1eb1ng c\u00e1ch d\u00f9ng ph\u00edm F4.<\/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-177.gif\" title=\"vba101_92019-nho-177\"><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-447.gif\" title=\"ex101_92019-nho-447\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00eau tr\u00ean, \u0111\u1ec3 ch\u1eafc ch\u1eafn c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c sao ch\u00e9p m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c, \u00e3y ch\u1ecdn m\u1ed9t v\u00e0i \u00f4 \u1edf c\u1ed9t C, v\u00ed d\u1ee5 nh\u01b0 C4 v\u00e0 xem tham chi\u1ebfu \u00f4 tr\u00ean thanh c\u00f4ng th\u1ee9c. Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u00fang, h\u1ee3p l\u00fd v\u00e0 ch\u00ednh x\u00e1c v\u1edbi h\u00e0ng 4:<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5406 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-2-3.png\" width=\"286\" height=\"223\" title=\"2-2-3\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_sao_chep_cong_thuc_bang_cach_keo_cot_doc_ma_khong_sao_chep_dinh_dang\"><\/span>C\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch k\u00e9o c\u1ed9t d\u1ecdc m\u00e0 kh\u00f4ng sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Vi\u1ec7c k\u00e9o c\u1ed9t d\u1ecdc kh\u00f4ng ch\u1ec9 gi\u00fap sao ch\u00e9p c\u00f4ng th\u1ee9c m\u00e0 c\u00f2n sao ch\u00e9p lu\u00f4n \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 g\u1ed1c nh\u01b0 m\u00e0u n\u1ec1n, c\u00e1c k\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7, s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb,\u2026 Trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p, \u0111i\u1ec1u n\u00e0y kh\u00f4ng t\u1ea1o th\u00e0nh v\u1ea5n \u0111\u1ec1 g\u00ec, nh\u01b0ng \u0111\u00f4i khi n\u00f3 c\u00f3 th\u1ec3 l\u00e0m r\u1ed1i lo\u1ea1n \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 nh\u1eadn c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c sao ch\u00e9p sang. M\u1ed9t v\u00ed d\u1ee5 quen thu\u1ed9c l\u00e0 vi\u1ec7c to\u00e0n b\u1ed9 c\u1ed9t d\u1ecdc \u0111\u00e3 b\u1ecb \u0111\u1ed5 m\u00e0u nh\u01b0 trong \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5409 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-2-2.png\" width=\"426\" height=\"220\" title=\"5-2-2\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u00e1nh tr\u01b0\u1eddng h\u1ee3p n\u00e0y x\u1ea3y ra, b\u1ea1n h\u00e3y k\u00e9o fill handle nh\u01b0 h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean, sau \u0111\u00f3 th\u1ea3 ra, click v\u00e0o menu th\u1ea3 trong ph\u1ea7n <em>Auto Fill Option<\/em> v\u00e0 ch\u1ecdn <strong>Fill Without Formating<\/strong>.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5387 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-1-3.png\" width=\"479\" height=\"339\" title=\"4-1-3\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Sao_chep_cong_thuc_cho_toan_bo_cot\"><\/span>Sao ch\u00e9p c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u1ed9t:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, fill handle gi\u00fap cho vi\u1ec7c sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel th\u1ef1c s\u1ef1 \u0111\u01a1n gi\u1ea3n. Nh\u01b0ng n\u1ebfu b\u1ea1n c\u1ea7n sao ch\u00e9p c\u00f4ng th\u1ee9c cho m\u1ed9t trang t\u00ednh d\u00e0i 1000 d\u00f2ng th\u00ec sao, vi\u1ec7c k\u00e9o th\u1ea3 c\u00f4ng th\u1ee9c \u0111\u1ed1i v\u1edbi h\u00e0ng tr\u0103m c\u1ed9t d\u01b0\u1eddng nh\u01b0 kh\u00f4ng h\u1ee3p l\u00fd cho l\u1eafm. Excel v\u00ec v\u1eady s\u1ebd c\u00f3 m\u1ed9t v\u00e0i ph\u01b0\u01a1ng \u00e1n nhanh gi\u1ea3i quy\u1ebft tr\u01b0\u1eddng h\u1ee3p n\u00e0y.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Click_chuot_doi_vao_dau_cong_de_copy_cho_toan_bo_cot\"><\/span>Click chu\u1ed9t \u0111\u00f4i v\u00e0o d\u1ea5u c\u1ed9ng \u0111\u1ec3 copy cho to\u00e0n b\u1ed9 c\u1ed9t:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111i\u1ec1n c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u1ed9t, b\u1ea1n h\u00e3y click chu\u1ed9t \u0111\u00f4i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng thay v\u00ec k\u00e9o th\u1ea3. V\u1edbi nh\u1eefng ai \u0111\u00e3 b\u1ecf qua ph\u1ea7n \u0111\u1ea7u ti\u00ean c\u1ee7a b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, c\u00e1c b\u01b0\u1edbc chi ti\u1ebft s\u1ebd c\u00f3 \u1edf d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u1ed9t, b\u1ea1n h\u00e3y:<\/p>\n<ul>\n<li style=\"text-align: justify\">\u0110i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o c\u1ed9t \u0111\u1ea7u ti\u00ean<\/li>\n<li style=\"text-align: justify\">Di con tr\u1ecf chu\u1ed9t \u0111\u1ebfn g\u00f3c b\u00ean ph\u1ea3i d\u01b0\u1edbi c\u00f9ng c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd xu\u1ea5t hi\u1ec7n m\u1ed9t d\u1ea5u c\u1ed9ng, click chu\u1ed9t \u0111\u00f4i v\u00e0o d\u1ea5u c\u1ed9ng \u0111\u00f3.<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5409 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-2-2.png\" width=\"426\" height=\"220\" title=\"5-2-2\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> C\u00e1ch l\u00e0m n\u00e0y s\u1ebd sao ch\u00e9p c\u00f4ng th\u1ee9c cho t\u1edbi t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t c\u00f3 d\u1eef li\u1ec7u \u1edf b\u00ean tr\u00e1i. Ngh\u0129a l\u00e0, mi\u1ec5n l\u00e0 \u1edf c\u00e1c c\u1ed9t b\u00ean tr\u00e1i c\u00f3 d\u1eef li\u1ec7u, Excel s\u1ebd ti\u1ebfp t\u1ee5c copy c\u00f4ng th\u1ee9c. Khi n\u00e0o c\u00f3 m\u1ed9t h\u00e0ng tr\u00f4ng, vi\u1ec7c \u0111i\u1ec1n t\u1ef1 \u0111\u1ed9ng s\u1ebd d\u1eebng l\u1ea1i. V\u00ec v\u1eady, n\u1ebfu excel c\u1ee7a b\u1ea1n c\u00f3 b\u1ea5t c\u1ee9 m\u1ed9t h\u00e0ng tr\u1ed1ng n\u00e0o, b\u1ea1n s\u1ebd ph\u1ea3i l\u1eb7p l\u1ea1i quy tr\u00ecnh \u1edf tr\u00ean \u0111\u1ec3 ti\u1ebfp t\u1ee5c copy c\u00f4ng th\u1ee9c:<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5410 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-2-1.png\" width=\"506\" height=\"223\" title=\"6-2-1\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_sao_chep_mot_cong_thuc_Excel_nhung_khong_dinh_dang\"><\/span>C\u00e1ch sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c Excel nh\u01b0ng kh\u00f4ng \u0111\u1ecbnh d\u1ea1ng:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, khi sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1c k\u00e9o c\u1ed9t d\u1ecdc trong Excel, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00e1ch \u0111i\u1ec1n c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng \u0111\u1ecbnh d\u1ea1ng, gi\u00fap b\u1ea1n copy c\u00f4ng th\u1ee9c m\u00e0 v\u1eabn gi\u1eef \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4. C\u00f4ng c\u1ee5 copy \u2013 paste c\u1ee7a Excel c\u00f2n c\u00f3 c\u00e1ch th\u1ee9c linh ho\u1ea1t h\u01a1n \u0111\u1ec3 c\u00f3 th\u1ec3 paste \u0111\u01b0\u1ee3c c\u00f4ng th\u1ee9c nh\u01b0 b\u1ea1n mu\u1ed1n.<\/p>\n<ul>\n<li>Ch\u1ecdn \u00f4 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c<\/li>\n<li>Sao ch\u00e9p \u00f4 \u0111\u00f3 b\u1eb1ng vi\u1ec7c nh\u1ea5n ph\u00edm Ctrl + C. C\u00e1ch kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 click chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 v\u00e0 ch\u1ecdn copy, ho\u1eb7c click v\u00e0o \u00f4 Copy tr\u00ean thanh Home &gt; Clipboard.<\/li>\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n sao ch\u00e9p c\u00f4ng th\u1ee9c.<\/li>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0o c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 ch\u1ecdn Formulas \u1edf m\u1ee5c Paste Options.<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5393 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-3.png\" width=\"442\" height=\"192\" title=\"10-3\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd c\u00f3 nhi\u1ec1u l\u1ef1a ch\u1ecdn h\u01a1n b\u1eb1ng c\u00e1ch click v\u00e0o h\u00ecnh m\u0169i t\u00ean \u1edf \u00f4 Paste n\u1eb1m \u1edf g\u00f3c tr\u00e1i tr\u00ean c\u00f9ng c\u1ee7a b\u1ea3ng t\u00ednh. T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn Formulas &amp; Number Formatting \u0111\u1ec3 paste duy nh\u1ea5t c\u00f4ng th\u1ee9c v\u00e0 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 nh\u01b0 ph\u1ea7n tr\u0103m, k\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7 nh\u01b0 \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-5394\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-246x300-1.png\" width=\"246\" height=\"300\" title=\"11-246x300-1\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.<\/strong> N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc c\u00e1ch paste n\u00e0o l\u00e0 ph\u00f9 h\u1ee3p nh\u1ea5t, b\u1ea1n h\u00e3y di chu\u1ed9t \u0111\u1ebfn nh\u1eefng bi\u1ec3u t\u01b0\u1ee3ng kh\u00e1c nhau m\u00e0 kh\u00f4ng click v\u00e0o, Excel s\u1ebd hi\u1ec7n ph\u1ea7n xem th\u1eed \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nhung_cach_lam_tat_de_sao_chep_cong_thuc_Excel_den_cac_o_khac\"><\/span>Nh\u1eefng c\u00e1ch l\u00e0m t\u1eaft \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c Excel \u0111\u1ebfn c\u00e1c \u00f4 kh\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"1_Sao_chep_cong_thuc_den_o_ngay_duoi\"><\/span>1. Sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn \u00f4 ngay d\u01b0\u1edbi<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ctrl + D \u2013 Sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c t\u1eeb m\u1ed9t \u00f4 trong trang t\u00ednh \u0111\u1ebfn ngay \u00f4 d\u01b0\u1edbi li\u1ec1n k\u1ec1 n\u00f3 v\u00e0 \u0111i\u1ec1u ch\u1ec9nh tham chi\u1ebfu \u00f4.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 c\u00f4ng th\u1ee9c \u1edf \u00f4 A1 v\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o \u00f4 A2, ch\u1ecdn A2 v\u00e0 nh\u1ea5n Ctrl + D.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5423 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-1-1.png\" width=\"313\" height=\"62\" title=\"19-1-1\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"2_Sao_chep_cong_thuc_sang_ben_phai\"><\/span>2. Sao ch\u00e9p c\u00f4ng th\u1ee9c sang b\u00ean ph\u1ea3i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ctrl + R \u2013 Sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c sang \u00f4 b\u00ean ph\u1ea3i li\u1ec1n k\u1ec1 v\u00e0 \u0111i\u1ec1u ch\u1ec9nh tham chi\u1ebfu \u00f4.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n c\u00f3 c\u00f4ng th\u1ee9c \u1edf \u00f4 A2 v\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p \u0111\u1ebfn \u00f4 B2, ch\u1ecdn B2 v\u00e0 nh\u1ea5n Ctrl + R.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5424 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/20-1.png\" width=\"314\" height=\"62\" title=\"20-1\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.<\/strong> C\u1ea3 2 c\u00e1ch r\u00ean \u0111\u1ec1u c\u00f3 th\u1ec3 d\u00f9ng \u0111\u1ec3 copy c\u00f4ng th\u1ee9c v\u00e0o nhi\u1ec1u \u00f4 kh\u00e1c nhau, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn c\u1ea3 \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c v\u00e0 \u00f4 nh\u1eadn c\u00f4ng th\u1ee9c, sau \u0111\u00f3 nh\u1ea5n ph\u00edm t\u1eaft. V\u00ed d\u1ee5 nh\u01b0 b\u1ea1n mu\u1ed1n sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb A1 \u0111\u1ebfn 9 d\u00e3y sau \u0111\u00f3, ch\u1ecdn \u00f4 A1:A10 v\u00e0 nh\u1ea5n Ctrl + D.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"3_Sao_chep_cong_thuc_vao_o_ngay_duoi_mot_cach_chinh_xac\"><\/span><strong>3. Sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o \u00f4 ngay d\u01b0\u1edbi m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ctrl + \u2018 \u2013 Sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb \u00f4 b\u00ean tr\u00ean v\u00e0o c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn b\u00ean d\u01b0\u1edbi m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c v\u00e0 hi\u1ec3n th\u1ecb \u00f4 \u1edf ch\u1ebf \u0111\u1ed9 ch\u1ec9nh s\u1eeda.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 c\u00e1ch kh\u00e1 nhanh \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng thay \u0111\u1ed5i tham chi\u1ebfu \u00f4. V\u00ed d\u1ee5, \u0111\u1ec3 sao ch\u00e9p m\u1ed9t c\u00f4ng th\u1ee9c t\u1eeb \u00f4 A1 \u0111\u1ebfn A2 m\u00e0 kh\u00f4ng tham chi\u1ebfu n\u00e0o thay \u0111\u1ed5i, ch\u1ecdn A2 v\u00e0 nh\u1ea5n Ctrl + \u2018<\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd.<\/strong> \u0110\u1eebng nh\u1ea7m gi\u1eefa Ctrl + \u2018 (sao ch\u00e9p ch\u00ednh x\u00e1c m\u1ed9t c\u00f4ng th\u1ee9c) v\u1edbi Ctrl + ` (hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong Excel).<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5425 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/21-1.png\" width=\"310\" height=\"62\" title=\"21-1\"><\/p>\n<p style=\"text-align: justify\">B\u00e0i vi\u1ebft n\u00e0y \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n t\u1ea5t c\u1ea3 c\u00e1c c\u00e1ch th\u1ee9c \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c trong Excel. N\u1ebfu b\u1ea1n bi\u1ebft th\u00eam b\u1ea5t c\u1ee9 m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec3 c\u00f3 th\u1ec3 sao ch\u00e9p hay di chuy\u1ec3n c\u00f4ng th\u1ee9c nhanh trong Excel, h\u00e3y chia s\u1ebb nh\u00e9. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 d\u00e0nh th\u1eddi gian \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y v\u00e0 h\u1eb9n b\u1ea1n trong nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo.<\/p>\n<p style=\"text-align: justify\">Xem th\u00eam:<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-co-dinh-dong-va-cot-nang-cao-trong-excel-nhieu-cach-moi-hay-va-la.html\">H\u01b0\u1edbng d\u1eabn c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e2ng cao trong Excel, nhi\u1ec1u c\u00e1ch m\u1edbi hay v\u00e0 l\u1ea1<\/a><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/2-cach-de-loai-bo-dau-cach-khoan-trang-giua-cac-tu-cac-so-trong-o-tinh-excel.html\">2 c\u00e1ch \u0111\u1ec3 lo\u1ea1i b\u1ecf d\u1ea5u c\u00e1ch, kho\u1ea3ng tr\u1eafng gi\u1eefa c\u00e1c t\u1eeb, c\u00e1c s\u1ed1 trong \u00f4 t\u00ednh Excel<\/a><\/p>\n<p>\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\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. 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 kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/p>\n<p><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi <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>.<\/em><\/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-177.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5237,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5236","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\/5236","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=5236"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5236\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5237"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}