{"id":5729,"date":"2024-12-20T17:06:30","date_gmt":"2024-12-20T17:06:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-toan-tap-ve-cach-keo-cong-thuc-trong-excel\/"},"modified":"2024-12-20T17:06:30","modified_gmt":"2024-12-20T17:06:30","slug":"huong-dan-toan-tap-ve-cach-keo-cong-thuc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/20\/huong-dan-toan-tap-ve-cach-keo-cong-thuc-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn to\u00e0n t\u1eadp v\u1ec1 c\u00e1ch k\u00e9o c\u00f4ng th\u1ee9c trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>K\u00e9o c\u00f4ng th\u1ee9c l\u00e0 k\u1ef9 thu\u1eadt m\u00e0 ai c\u0169ng g\u1eb7p ph\u1ea3i trong\u00a0Excel.\u00a0\u0110\u1ec3 l\u00e0m\u00a0\u0111i\u1ec1u n\u00e0y v\u1eeba nhanh v\u1eeba\u00a0\u0111\u00fang l\u1ea1i kh\u00f4ng d\u1ec5 ch\u00fat n\u00e0o. H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u nh\u1eefng\u00a0\u0111i\u1ec1u th\u00fa v\u1ecb v\u1ec1 c\u00e1ch k\u00e9o c\u00f4ng th\u1ee9c trong\u00a0Excel nh\u00e9.<\/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-6765a41584e40\" 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-toan-tap-ve-cach-keo-cong-thuc-trong-excel.html#Keo_cong_thuc_xuong_duoi\" title=\"K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng d\u01b0\u1edbi\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng d\u01b0\u1edbi<\/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-toan-tap-ve-cach-keo-cong-thuc-trong-excel.html#Tai_sao_lai_khong_the_keo_cong_thuc_xuong_duoc\" title=\"T\u1ea1i sao l\u1ea1i kh\u00f4ng th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u01b0\u1ee3c?\">T\u1ea1i sao l\u1ea1i kh\u00f4ng th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u01b0\u1ee3c?<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\">\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\">\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-toan-tap-ve-cach-keo-cong-thuc-trong-excel.html#Sua_loi_keo_cong_thuc_trong_Excel_tren_may_chay_Windows\" title=\"S\u1eeda l\u1ed7i k\u00e9o c\u00f4ng th\u1ee9c trong Excel tr\u00ean m\u00e1y ch\u1ea1y Windows:\">S\u1eeda l\u1ed7i k\u00e9o c\u00f4ng th\u1ee9c trong Excel tr\u00ean m\u00e1y ch\u1ea1y Windows:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-toan-tap-ve-cach-keo-cong-thuc-trong-excel.html#Sua_loi_keo_cong_thuc_trong_Excel_tren_may_MacOS\" title=\"S\u1eeda l\u1ed7i k\u00e9o c\u00f4ng th\u1ee9c trong Excel\u00a0tr\u00ean m\u00e1y MacOS:\">S\u1eeda l\u1ed7i k\u00e9o c\u00f4ng th\u1ee9c trong Excel\u00a0tr\u00ean m\u00e1y MacOS:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-toan-tap-ve-cach-keo-cong-thuc-trong-excel.html#Nhung_chieu_keo_cong_thuc_con_lai\" title=\"Nh\u1eefng chi\u1ec1u k\u00e9o c\u00f4ng th\u1ee9c c\u00f2n l\u1ea1i\">Nh\u1eefng chi\u1ec1u k\u00e9o c\u00f4ng th\u1ee9c c\u00f2n l\u1ea1i<\/a><\/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-toan-tap-ve-cach-keo-cong-thuc-trong-excel.html#Phim_tat_cho_thao_tac_Fill_trong_Excel\" title=\"Ph\u00edm t\u1eaft cho thao t\u00e1c Fill trong\u00a0Excel\">Ph\u00edm t\u1eaft cho thao t\u00e1c Fill trong\u00a0Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Keo_cong_thuc_xuong_duoi\"><\/span>K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng d\u01b0\u1edbi<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o 1\u00a0\u00f4, sau\u00a0\u0111\u00f3 k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb\u00a0\u00f4\u00a0\u0111\u00f3 <strong>xu\u1ed1ng c\u00e1c\u00a0\u00f4 b\u00ean d\u01b0\u1edbi<\/strong> <strong>trong c\u00f9ng 1 h\u00e0ng<\/strong>. V\u1ecb tr\u00ed k\u00e9o c\u00f4ng th\u1ee9c l\u00e0 d\u1ea5u ch\u1ea5m\u00a0\u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i trong\u00a0\u00f4<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23681\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-tri-o-keo-cong-thuc-trong-excel.png\" width=\"210\" height=\"86\" title=\"vi-tri-o-keo-cong-thuc-trong-excel\"><\/p>\n<p>Thu\u1eadt ng\u1eef c\u1ee7a Excel\u00a0g\u1ecdi thao t\u00e1c n\u00e0y l\u00e0 <strong>FillDown<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23682\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/keo-cong-thuc-bang-chuot.png\" width=\"523\" height=\"240\" title=\"keo-cong-thuc-bang-chuot\"><\/p>\n<p style=\"text-align: center\"><em>C\u00e1ch k\u00e9o c\u00f4ng th\u1ee9c filldown b\u1eb1ng chu\u1ed9t<\/em><\/p>\n<p>N\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng chu\u1ed9t m\u00e0 v\u1eabn mu\u1ed1n th\u1ef1c hi\u1ec7n FillDown, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p\u00a0ph\u00edm t\u1eaft l\u00e0 <strong>Ctrl + D<\/strong>. C\u00e1ch l\u00e0m 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-502.gif\" title=\"ex101_92019-nho-502\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>Ch\u1ecdn\u00a0\u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c\u00a0\u0111\u1ec3 b\u1eaft\u00a0\u0111\u1ea7u filldown<\/li>\n<li>Gi\u1eef ph\u00edm Shift v\u00e0 ch\u1ecdn t\u1edbi v\u1ecb tr\u00ed\u00a0\u00f4 cu\u1ed1i c\u00f9ng trong\u00a0v\u00f9ng ch\u1ee9a c\u00f4ng th\u1ee9c c\u1ea7n k\u00e9o xu\u1ed1ng<\/li>\n<li>B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + D<\/li>\n<\/ul>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23683\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/keo-cong-thuc-bang-phim-tat.png\" width=\"306\" height=\"197\" title=\"keo-cong-thuc-bang-phim-tat\"><\/p>\n<p style=\"text-align: left\">Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m\u00a0\u0111i\u1ec1u n\u00e0y m\u1ed9t c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng trong VBA v\u1edbi c\u00e2u l\u1ec7nh: Range(\u2026.).Filldown<\/p>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23684\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/filldown-vba.png\" width=\"752\" height=\"247\" title=\"filldown-vba\"><\/p>\n<p style=\"text-align: left\">V\u00f9ng Range ph\u1ea3i b\u1eaft bu\u1ed9c c\u00f3\u00a0\u00f4\u00a0\u0111\u1ea7u ti\u00ean ch\u1ee9a c\u00f4ng th\u1ee9c c\u1ea7n k\u00e9o.<\/p>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Tai_sao_lai_khong_the_keo_cong_thuc_xuong_duoc\"><\/span>T\u1ea1i sao l\u1ea1i kh\u00f4ng th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u01b0\u1ee3c?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea5t th\u00ecnh l\u00ecnh m\u1ed9t ng\u00e0y b\u1ea1n kh\u00f4ng th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c, \u0111\u01b0a chu\u1ed9t g\u00f3c ph\u1ea3i kh\u00f4ng c\u00f3 d\u1ea5u c\u1ed9ng \u0111\u1ec3 k\u00e9o. V\u1eady ph\u1ea3i s\u1eeda l\u00e0m sao? R\u1ea5t \u0111\u01a1n gi\u1ea3n, b\u1ea1n v\u00e0o File &gt; Options. Ch\u1ecdn Advanced, v\u00e0 ch\u1ecdn ti\u1ebfp [x] Enable fill handle and cell drag-and-drop, v\u00e0 c\u0169ng n\u00ean ch\u1ecdn lu\u00f4n [x]\u00a0Alert before overwriting cells (c\u1ea3nh b\u00e1o khi ghi \u0111\u00e8 l\u00ean \u00f4 c\u00f3 s\u1eb5n).<\/p>\n<h5><span class=\"ez-toc-section\" id=\"Sua_loi_keo_cong_thuc_trong_Excel_tren_may_chay_Windows\"><\/span><em><strong>S\u1eeda l\u1ed7i k\u00e9o c\u00f4ng th\u1ee9c trong Excel tr\u00ean m\u00e1y ch\u1ea1y Windows:<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/excel-options-enable-fill-handle-and-cell-drag-and-drop.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23755\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-options-enable-fill-handle-and-cell-drag-and-drop.jpg\" width=\"836\" height=\"688\" title=\"excel-options-enable-fill-handle-and-cell-drag-and-drop\"><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"Sua_loi_keo_cong_thuc_trong_Excel_tren_may_MacOS\"><\/span><strong><em>S\u1eeda l\u1ed7i k\u00e9o c\u00f4ng th\u1ee9c trong Excel\u00a0tr\u00ean m\u00e1y MacOS:<\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>B\u1ea1n v\u00e0o Excel =&gt; Preferences\u2026 (ph\u00edm t\u1eaft: \u2318 + , [d\u1ea5u ph\u1ea9y]) =&gt; Ch\u1ecdn ti\u1ebfp <strong>Edit <\/strong>=&gt; Sau \u0111\u00f3 ch\u1ecdn\u00a0[x] <strong>Enable fill handle and cell drag-and-drop<\/strong>, v\u00e0 c\u0169ng n\u00ean ch\u1ecdn lu\u00f4n [x]\u00a0<strong>Alert before overwriting cells<\/strong>.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/11\/sua-loi-keo-cong-thuc-tren-may-mac-excel-preference-fill-drag.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-25367\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sua-loi-keo-cong-thuc-tren-may-mac-excel-preference-fill-drag.jpg\" width=\"644\" height=\"438\" title=\"sua-loi-keo-cong-thuc-tren-may-mac-excel-preference-fill-drag\"><\/a><\/p>\n<h2 style=\"text-align: left\"><span class=\"ez-toc-section\" id=\"Nhung_chieu_keo_cong_thuc_con_lai\"><\/span>Nh\u1eefng chi\u1ec1u k\u00e9o c\u00f4ng th\u1ee9c c\u00f2n l\u1ea1i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left\">Ch\u1eafc h\u1eb3n b\u1ea1n th\u1eafc m\u1eafc: Kh\u00f4ng ch\u1ec9 k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi, m\u00e0 c\u00f2n nhi\u1ec1u chi\u1ec1u n\u1eefa, nh\u01b0 l\u00e0 T\u1eeb tr\u00e1i qua ph\u1ea3i, t\u1eeb d\u01b0\u1edbi l\u00ean tr\u00ean, t\u1eeb ph\u1ea3i sang tr\u00e1i. V\u1eady th\u00ec v\u1edbi nh\u1eefng chi\u1ec1u c\u00f2n l\u1ea1i th\u00ec sao?<\/p>\n<p style=\"text-align: left\">C\u00e2u tr\u1ea3 l\u1eddi l\u00e0\u00a0Excel c\u00f3\u00a0\u0111\u1ee7 c\u00e1c chi\u1ec1u n\u00e0y:<\/p>\n<ul>\n<li style=\"text-align: left\">FillDown: t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi<\/li>\n<li style=\"text-align: left\">FillUp: t\u1eeb d\u01b0\u1edbi l\u00ean tr\u00ean<\/li>\n<li style=\"text-align: left\">FillRight: t\u1eeb tr\u00e1i qua ph\u1ea3i<\/li>\n<li style=\"text-align: left\">FillLeft: t\u1eeb ph\u1ea3i qua tr\u00e1i<\/li>\n<\/ul>\n<p>V\u00e0 c\u1ea3 4 chi\u1ec1u n\u00e0y\u00a0\u0111\u1ec1u c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c thu\u1ed9c t\u00ednh\u00a0 Fill trong VBA:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23685\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cac-chieu-fill-cua-excel.png\" width=\"434\" height=\"183\" title=\"cac-chieu-fill-cua-excel\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Phim_tat_cho_thao_tac_Fill_trong_Excel\"><\/span>Ph\u00edm t\u1eaft cho thao t\u00e1c Fill trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0ng ch\u1ec9 c\u00f3 2 chi\u1ec1u l\u00e0 hay s\u1eed d\u1ee5ng,\u00a0\u0111\u00f3 l\u00e0 FillDown v\u00e0 FillRight, do\u00a0\u0111\u00f3\u00a0Excel h\u1ed7 tr\u1ee3 ph\u00edm t\u1eaft ri\u00eang cho 2 chi\u1ec1u fill n\u00e0y l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23686\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cac-chieu-fill-cua-excel-hotkey.png\" width=\"350\" height=\"278\" title=\"cac-chieu-fill-cua-excel-hotkey\"><\/p>\n<p>Nh\u01b0ng ch\u1eb3ng nh\u1ebd fillLeft v\u00e0 FillUp kh\u00f4ng c\u00f3 c\u00e1ch n\u00e0o kh\u00e1c ngo\u00e0i d\u00f9ng chu\u1ed9t k\u00e9o? C\u00f3 m\u1ed9t gi\u1ea3i ph\u00e1p cho b\u1ea1n\u00a0\u0111\u00e2y,\u00a0\u0111\u00f3 l\u00e0 tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a\u00a0Excel cung c\u1ea5p cho ch\u00fang ta nh\u00f3m c\u00f4ng c\u1ee5 Fill.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23687\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fill-tren-thanh-cong-cu.png\" width=\"268\" height=\"305\" title=\"fill-tren-thanh-cong-cu\"><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft v\u1edbi c\u00e1c c\u00f4ng c\u1ee5 n\u00e0y, ch\u00fang ta b\u1ea5m ph\u00edm Alt, sau\u00a0\u0111\u00f3 b\u1ea5m ti\u1ebfp c\u00e1c ph\u00edm\u00a0\u0111\u1ea1i di\u1ec7n cho v\u1ecb tr\u00ed c\u00f4ng c\u1ee5\u00a0\u0111\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23688\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/phim-tat-fill-cong-thuc.png\" width=\"1665\" height=\"357\" title=\"phim-tat-fill-cong-thuc\"><\/p>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m ph\u00edm ALT<\/li>\n<li>B\u1ea5m ti\u1ebfp ph\u00edm H\u00a0\u0111\u1ec3 g\u1ecdi th\u1ebb HOME<\/li>\n<li>B\u1ea5m ti\u1ebfp ph\u00edm F v\u00e0 ph\u00edm I\u00a0\u0111\u1ec3 g\u1ecdi ch\u1ee9c n\u0103ng Fill<\/li>\n<li>B\u1ea5m ti\u1ebfp c\u00e1c ph\u00edm D \/ R \/ U \/ L\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c h\u01b0\u1edbng fill theo\u00a0\u00fd mu\u1ed1n.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 b\u1ea1n mu\u1ed1n FillLeft, c\u00f3 th\u1ec3 b\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm sau: ALT + H + F + I + L<\/p>\n<p>Mu\u1ed1n FillRight, b\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m Ctrl + R ho\u1eb7c t\u1ed5 h\u1ee3p ph\u00edm\u00a0ALT + H + F + I + R<\/p>\n<p style=\"text-align: left\">Vi\u1ec7c fill c\u00f4ng th\u1ee9c s\u1ebd\u00a0\u1ea3nh h\u01b0\u1edfng th\u1ebf n\u00e0o t\u1edbi c\u00f4ng th\u1ee9c? Nh\u1eefng ch\u00fa\u00a0\u00fd g\u00ec tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n k\u00e9o c\u00f4ng th\u1ee9c? H\u00e3y\u00a0\u0111\u1ecdc ti\u1ebfp\u00a0\u1edf b\u00e0i vi\u1ebft sau nh\u00e9:<\/p>\n<p style=\"text-align: left;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-keo-cong-thuc-trong-cac-o-co-su-dung-chuc-nang-tron-o-merge-cells.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch k\u00e9o c\u00f4ng th\u1ee9c trong c\u00e1c \u00f4 c\u00f3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n \u00f4 merge cells<\/a><\/p>\n<p style=\"text-align: left;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cac-ky-thuat-sao-chep-cong-thuc-theo-y-muon-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1c k\u1ef9 thu\u1eadt sao ch\u00e9p c\u00f4ng th\u1ee9c theo \u00fd mu\u1ed1n trong Excel<\/a><\/p>\n<p style=\"text-align: left;padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tai-sao-phai-su-dung-ky-hieu-dollar-trong-cong-thuc-excel-cac-tham-chieu-o-tuyet-doi-va-tuong-doi.html\">T\u1ea1i sao ph\u1ea3i s\u1eed d\u1ee5ng k\u00fd hi\u1ec7u dollar ($) trong c\u00f4ng th\u1ee9c Excel \u2013 c\u00e1c tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i<\/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-502.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5729","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\/5729","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=5729"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5729\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5730"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}