{"id":998,"date":"2024-12-02T03:53:05","date_gmt":"2024-12-02T03:53:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang\/"},"modified":"2024-12-02T03:53:05","modified_gmt":"2024-12-02T03:53:05","slug":"huong-dan-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Format Painter v\u00e0 c\u00e1c c\u00e1ch \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">l\u01a1\u0301p ho\u0323c Excel<\/a> Online\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng trong Excel d\u00f9ng <em>Format Painter<\/em>, <em>Fill Handle<\/em> v\u00e0 <em>Paste Special<\/em>. Nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng trong Excel 2016, 2013, 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n.<\/p>\n<p style=\"text-align: justify\">Sau khi b\u1ea1n \u0111\u00e3 n\u1ed7 l\u1ef1c t\u00ednh to\u00e1n s\u1ed1 li\u1ec7u trong b\u1ea3ng t\u00ednh, b\u1ea1n th\u01b0\u1eddng mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 b\u1ea3ng t\u00ednh tr\u00f4ng \u0111\u1eb9p h\u01a1n, ho\u00e0n thi\u1ec7n h\u01a1n. D\u00f9 b\u1ea1n \u0111ang l\u00e0m b\u00e1o c\u00e1o cho c\u00f4ng ty hay t\u1ea1o b\u1ea3ng t\u00ednh t\u1ed5ng h\u1ee3p n\u1ed9p l\u00ean ban gi\u00e1m \u0111\u1ed1c, \u0111\u1ecbnh d\u1ea1ng h\u1ee3p l\u00fd s\u1ebd l\u00e0m n\u1ed5i b\u1eadt nh\u1eefng s\u1ed1 li\u1ec7u quan tr\u1ecdng v\u00e0 khi\u1ebfn th\u00f4ng tin \u0111\u01b0\u1ee3c truy\u1ec1n t\u1ea3i d\u1ec5 d\u00e0ng, hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<p style=\"text-align: justify\">Microsoft Excel \u0111\u00e3 thi\u1ebft k\u1ebf ch\u1ee9c n\u0103ng tuy\u1ec7t v\u1eddi \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng, nh\u01b0ng ch\u1ee9c n\u0103ng n\u00e0y th\u01b0\u1eddng b\u1ecb b\u1ecf qua ho\u1eb7c xem th\u01b0\u1eddng. \u0110\u00f3 l\u00e0 <em>Format Painter<\/em>. <em>Format Painter<\/em> gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u1ee7a 1 \u00f4 v\u00e0 \u00e1p d\u1ee5ng cho \u00f4 kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n c\u0169ng s\u1ebd h\u1ecdc \u0111\u01b0\u1ee3c c\u00e1c c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u1ec3 d\u00f9ng <em>Format Painter<\/em> trong Excel v\u00e0 c\u00e1c k\u1ef9 thu\u1eadt sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng kh\u00e1c.<\/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-674d2f2075cc2\" 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-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang.html#Excel_Format_Painter\" title=\"Excel Format Painter:\">Excel Format Painter:<\/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-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang.html#Cach_dung_Format_Painter_trong_Excle\" title=\"Ca\u0301ch du\u0300ng Format Painter trong Excle:\">Ca\u0301ch du\u0300ng Format Painter trong Excle:<\/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-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang.html#Meo_dung_Excel_Format_Painter\" title=\"Me\u0323o du\u0300ng Excel Format Painter:\">Me\u0323o du\u0300ng Excel Format Painter:<\/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-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang.html#Sao_chep_dinh_dang_dung_Fill_Handle\" title=\"Sao che\u0301p \u0111i\u0323nh da\u0323ng du\u0300ng Fill Handle:\">Sao che\u0301p \u0111i\u0323nh da\u0323ng du\u0300ng Fill Handle:<\/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-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang.html#Phim_tat_sao_chep_dinh_dang\" title=\"Phi\u0301m t\u0103\u0301t sao che\u0301p \u0111i\u0323nh da\u0323ng:\">Phi\u0301m t\u0103\u0301t sao che\u0301p \u0111i\u0323nh da\u0323ng:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang.html#Phim_tat_Excel_Format_Painter\" title=\"Phi\u0301m t\u0103\u0301t Excel Format Painter:\">Phi\u0301m t\u0103\u0301t Excel Format Painter:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang.html#Phim_tat_Excel_Format_Special\" title=\"Phi\u0301m t\u0103\u0301t Excel Format Special\u00a0:\">Phi\u0301m t\u0103\u0301t Excel Format Special\u00a0:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Excel_Format_Painter\"><\/span>Excel Format Painter:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi c\u1ea7n ph\u1ea3i sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng, <em>Format Painter<\/em> l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 hi\u1ec7u qu\u1ea3 nh\u1ea5t. N\u00f3 s\u1ebd copy \u0111\u1ecbnh d\u1ea1ng c\u1ee7a 1 \u00f4 v\u00e0 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng cho \u00f4 kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">Ch\u1ec9 v\u1edbi v\u00e0i c\u00e1i nh\u1ea5p chu\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p h\u1ea7u h\u1ebft c\u00e1c \u0111\u1ecbnh d\u1ea1ng bao g\u1ed3m:<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 (General, Percentage, Currency)<\/li>\n<li>Font, c\u1ee1 v\u00e0 m\u00e0u ch\u1eef<\/li>\n<li>\u0110\u1eb7c \u0111i\u1ec3m font ch\u1eef nh\u01b0 \u0111\u1eadm, nghi\u00eang, g\u1ea1ch ch\u00e2n<\/li>\n<li>M\u00e0u n\u1ec1n<\/li>\n<li>C\u0103n ch\u1ec9nh ch\u1eef v\u00e0 h\u01b0\u1edbng ch\u1eef<\/li>\n<li>\u0110\u01b0\u1eddng vi\u1ec1n \u00f4<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel, <em>Format Painter<\/em> n\u1eb1m \u1edf tab <strong>Home<\/strong>, trong nh\u00f3m <strong>Clipboard<\/strong>, c\u1ea1nh n\u00fat <strong>Paste.<\/strong><\/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-67.gif\" title=\"ex101_92019-nho-67\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5019 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-format-painter.png\" width=\"158\" height=\"119\" title=\"excel-format-painter\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T\u00f4\u0309ng h\u01a1\u0323p ta\u0300i li\u00ea\u0323u h\u01b0\u01a1\u0301ng d\u00e2\u0303n ho\u0323c Excel c\u01a1 ba\u0309n<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_dung_Format_Painter_trong_Excle\"><\/span>Ca\u0301ch du\u0300ng Format Painter trong Excle:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng \u00f4 v\u1edbi <em>Format Painter<\/em>, b\u1ea1n l\u00e0m c\u00e1c b\u01b0\u1edbc:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p.<\/li>\n<li>Trong tab <strong>Home<\/strong>, nh\u00f3m <strong>Clipboard<\/strong>, nh\u1ea5n n\u00fat <strong>Format Painter<\/strong>. Chu\u1ed9t s\u1ebd chuy\u1ec3n th\u00e0nh c\u00e1i ch\u1ed5i qu\u00e9t s\u01a1n.<\/li>\n<li>Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn \u00f4 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng v\u00e0 nh\u1ea5n v\u00e0o \u00f4 \u0111\u00f3.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5020 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/use-format-painter.png\" width=\"432\" height=\"198\" title=\"use-format-painter\"><\/p>\n<h1 style=\"text-align: justify\"><\/h1>\n<h2><span class=\"ez-toc-section\" id=\"Meo_dung_Excel_Format_Painter\"><\/span>Me\u0323o du\u0300ng Excel Format Painter:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ecbnh d\u1ea1ng c\u1ee7a nhi\u1ec1u \u00f4, nh\u1ea5n chu\u1ed9t v\u00e0o t\u1eebng \u00f4 s\u1ebd t\u1ed1n nhi\u1ec1u th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c. Nh\u1eefng m\u1eb9o nh\u1ecf d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian.<\/p>\n<ol style=\"text-align: justify\">\n<li><strong>Sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng cho 1 d\u00e3y \u00f4<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c \u00f4 li\u1ec1n k\u1ec1 nhau, ch\u1ecdn \u00f4 v\u1edbi \u0111\u1ecbnh d\u1ea1ng m\u1eabu, nh\u1ea5n n\u00fat <strong>Format Painter<\/strong>, v\u00e0 k\u00e9o ch\u1ed5i qua c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5021 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-format-range.png\" width=\"316\" height=\"161\" title=\"copy-format-range\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li><strong>Sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c \u00f4 kh\u00f4ng li\u1ec1n k\u1ec1 nhau<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 kh\u00f4ng k\u1ec1 nhau, nh\u1ea5n \u0111\u00fap chu\u1ed9t v\u00e0o <strong>Format Painter<\/strong> thay v\u00ec nh\u1ea5n 1 l\u1ea7n, nh\u01b0 v\u1eady s\u1ebd gi\u1eef ch\u1ee9c n\u0103ng <em>Format Painter<\/em>. Sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c \u00f4 m\u00e0 b\u1ea1n c\u1ea7n, \u0111\u1ec3 k\u1ebft th\u00fac, nh\u1ea5n ph\u00edm <strong>Esc<\/strong> ho\u1eb7c <strong>Format Painter<\/strong> l\u1ea7n cu\u1ed1i.<\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li><strong>Sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u1ed9t <\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u1ee7a c\u1ea3 c\u1ed9t, b\u1ea1n ch\u1ecdn ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t m\u1eabu, nh\u1ea5n <strong>Format Painter<\/strong>, r\u1ed3i ch\u1ecdn ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 h\u00ecnh d\u01b0\u1edbi, \u0111\u1ecbnh d\u1ea1ng m\u1edbi \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho c\u1ea3 c\u1ed9t, trong \u0111\u00f3 c\u00f3 \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5022 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-column-formatting.png\" width=\"463\" height=\"182\" title=\"copy-column-formatting\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n l\u00e0m t\u01b0\u01a1ng t\u1ef1 khi mu\u1ed1n sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng cho h\u00e0ng.<\/p>\n<p style=\"text-align: justify\"><em>Format Painter<\/em> gi\u00fap sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng tr\u1edf n\u00ean v\u00f4 c\u00f9ng d\u1ec5 d\u00e0ng. Nh\u01b0ng trong Excel, th\u00f4ng th\u01b0\u1eddng c\u00f3 nhi\u1ec1u h\u01a1n 1 c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n 1 nhi\u1ec7m v\u1ee5. Sau \u0111\u00e2y, b\u1ea1n s\u1ebd bi\u1ebft th\u00eam 2 c\u00e1ch n\u1eefa \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng trong Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Sao_chep_dinh_dang_dung_Fill_Handle\"><\/span>Sao che\u0301p \u0111i\u0323nh da\u0323ng du\u0300ng Fill Handle:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <em>Fill Handle<\/em> \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c ho\u1eb7c t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n d\u1eef li\u1ec7u cho c\u00e1c \u00f4. Nh\u01b0ng b\u1ea1n c\u00f3 bi\u1ebft <em>Fill Handle<\/em> c\u0169ng d\u00f9ng \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng?<\/p>\n<ol style=\"text-align: justify\">\n<li>\u0110\u1ecbnh d\u1ea1ng \u00f4 \u0111\u1ea7u ti\u00ean theo c\u00e1ch b\u1ea1n mu\u1ed1n<\/li>\n<li>Ch\u1ecdn \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng c\u1ea9n th\u1eadn v\u00e0 di chuy\u1ec3n chu\u1ed9t t\u1edbi v\u00f9ng <em>Fill Handle<\/em> (\u00f4 vu\u00f4ng nh\u1ecf \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4). Khi \u0111\u00f3, con tr\u1ecf s\u1ebd chuy\u1ec3n th\u00e0nh h\u00ecnh ch\u1eef th\u1eadp m\u00e0u \u0111en.<\/li>\n<li>Gi\u1eef v\u00e0 k\u00e9o chu\u1ed9t qua \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng m\u1edbi.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5023 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-formatting-fill-handle.png\" width=\"196\" height=\"141\" title=\"copy-formatting-fill-handle\"><\/li>\n<li>Th\u1ea3 <em>Fill Handle<\/em>, ch\u1ecdn danh s\u00e1ch <strong>Auto Fill Options &gt; Fill Formatting Only.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5024 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fill-formatting-only.png\" width=\"272\" height=\"282\" title=\"fill-formatting-only\"><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb ban \u0111\u1ea7u, ch\u1ec9 \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5025 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fill-formatting-only-result.png\" width=\"84\" height=\"140\" title=\"fill-formatting-only-result\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o nh\u1ecf:<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng cho c\u1ea3 c\u1ed9t t\u1eeb \u00f4 \u0111\u1ea7u, k\u00edch \u0111\u00fap chu\u1ed9t v\u00e0o ph\u1ea7n <strong>Fill Handle<\/strong> thay v\u00ec k\u00e9o, ch\u1ecdn <strong>AutoFill Options &gt; Fill Formatting Only<\/strong>.<\/p>\n<p style=\"text-align: justify\">Sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb \u00f4 cho c\u1ea3 c\u1ed9t ho\u1eb7c d\u00f2ng<\/p>\n<p style=\"text-align: justify\">Tuy <em>Excel Format Painter<\/em> v\u00e0 <em>Fill Handle<\/em> r\u1ea5t hi\u1ec7u qu\u1ea3, nh\u01b0ng l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u1ea1n sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u1ee7a 1 \u00f4 c\u1ee5 th\u1ec3 v\u00e0 \u00e1p d\u1ee5ng l\u00ean c\u1ea3 c\u1ed9t ho\u1eb7c d\u00f2ng? Gi\u1ea3i ph\u00e1p l\u00e0 d\u00f9ng <em>Formats Option<\/em> trong Excel Paste Special.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng m\u1eabu v\u00e0 nh\u1ea5n <strong>Ctrl + C<\/strong> \u0111\u1ec3 sao ch\u00e9p n\u1ed9i dung v\u00e0 \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<li>Ch\u1ecdn c\u1ed9t ho\u1eb7c d\u00f2ng b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o ti\u00eau \u0111\u1ec1 h\u00e0ng\/c\u1ed9t.<\/li>\n<li>Nh\u1ea5n chu\u1ed9t ph\u1ea3i, k\u00edch <strong>Paste Special<\/strong>.<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <strong>Paste Special &gt; Formats &gt; OK<\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5026 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-formatting-paste-special.png\" width=\"412\" height=\"336\" title=\"copy-formatting-paste-special\"><\/p>\n<p style=\"text-align: justify\">Khi nh\u1ea5n v\u00e0o c\u00e1c tu\u1ef3 ch\u1ecdn <em>Formatting<\/em>, Excel s\u1ebd cho b\u1ea1n xem tr\u01b0\u1edbc \u0111\u1ecbnh d\u1ea1ng m\u1edbi, nh\u01b0 \u1edf h\u00ecnh d\u01b0\u1edbi.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5027 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/copy-formatting-paste-special2.png\" width=\"354\" height=\"248\" title=\"copy-formatting-paste-special2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Phim_tat_sao_chep_dinh_dang\"><\/span>Phi\u0301m t\u0103\u0301t sao che\u0301p \u0111i\u0323nh da\u0323ng:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e1ng ti\u1ebfc, Excel kh\u00f4ng cung c\u1ea5p cho b\u1ea1n 1 t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c, b\u1ea1n c\u1ea7n d\u00f9ng chu\u1ed7i ph\u00edm t\u1eaft, n\u00ean n\u1ebfu b\u1ea1n hay d\u00f9ng b\u00e0n ph\u00edm h\u01a1n chu\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng nh\u1eefng c\u00e1ch n\u00e0y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Phim_tat_Excel_Format_Painter\"><\/span>Phi\u0301m t\u0103\u0301t Excel Format Painter:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Thay v\u00ec nh\u1ea5n n\u00fat <em>Format Painter<\/em>, b\u1ea1n l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 c\u00f3 \u0111\u1ecbnh d\u1ea1ng m\u1eabu<\/li>\n<li>Nh\u1ea5n <strong>Alt &gt; H &gt; F &gt; P<\/strong><\/li>\n<li>Ch\u1ecdn \u00f4 m\u00e0 mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng<\/li>\n<\/ol>\n<p style=\"text-align: justify\">C\u00e1c ph\u00edm t\u1eaft \u0111\u01b0\u1ee3c nh\u1ea5n l\u1ea7n l\u01b0\u1ee3t, kh\u00f4ng ph\u1ea3i c\u00f9ng m\u1ed9t l\u00fac. Trong \u0111\u00f3:<\/p>\n<p style=\"text-align: justify\"><strong>Alt<\/strong>: \u00a0k\u00edch ho\u1ea1t ph\u00edm t\u1eaft \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c l\u1ec7nh tr\u00ean <em>Ribbon<\/em>.<\/p>\n<p style=\"text-align: justify\"><strong>H<\/strong>: ch\u1ecdn tab <strong>Home<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>F, P<\/strong>: ch\u1ecdn <strong>Format Painter<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Phim_tat_Excel_Format_Special\"><\/span>Phi\u0301m t\u0103\u0301t Excel Format <strong>Special\u00a0<\/strong>:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 nhanh ch\u00f3ng sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng trong Excel l\u00e0 d\u00f9ng b\u00e0n ph\u00edm thay cho <strong>Paste Special &gt; Formats<\/strong>:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng<\/li>\n<li>Nh\u1ea5n <strong>Ctrl + C<\/strong> \u0111\u1ec3 sao ch\u00e9p \u00f4 \u0111\u00e3 ch\u1ecdn.<\/li>\n<li>Ch\u1ecdn \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng m\u1edbi.<\/li>\n<li>Trong Excel 2010 \u2013 2016, nh\u1ea5n <strong>Shift + F10, S, R<\/strong> r\u1ed3i nh\u1ea5n <strong>Enter<\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u1edbi Excel 2007, nh\u1ea5n <strong>Shift + F10, S, T<\/strong> r\u1ed3i <strong>Enter<\/strong>.<\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Shift + F10<\/strong>: hi\u1ec3n th\u1ecb menu l\u1ef1a ch\u1ecdn<\/li>\n<li><strong>Shift + S<\/strong>: ch\u1ecdn l\u1ec7nh Paste Special<\/li>\n<li><strong>Shift + R<\/strong>: ch\u1ecdn l\u1ec7nh ch\u1ec9 ch\u00e9p \u0111\u1ecbnh d\u1ea1ng<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Mong r\u0103\u0300ng, v\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y se\u0303 giu\u0301p ca\u0301c ba\u0323n co\u0301 th\u00ea\u0309\u00a0\u00a0s\u1eed d\u1ee5ng Format Painter v\u00e0 c\u00e1c c\u00e1ch \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng trong Excel m\u00f4\u0323t ca\u0301ch d\u00ea\u0303 da\u0300ng nh\u00e2\u0301t. Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel:<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT \u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? 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=\"http:\/\/bit.ly\/2wbt4vr\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. 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\" target=\"_blank\" rel=\"noopener\">HocExcel.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-67.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":999,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-998","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\/998","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=998"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/998\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/999"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}