{"id":7377,"date":"2021-08-09T19:15:04","date_gmt":"2021-08-09T12:15:04","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7377"},"modified":"2021-08-18T11:08:38","modified_gmt":"2021-08-18T04:08:38","slug":"nhom-phim-tat-chen-va-chinh-sua-du-lieu","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/nhom-phim-tat-chen-va-chinh-sua-du-lieu\/","title":{"rendered":"Nh\u00f3m ph\u00edm t\u1eaft ch\u00e8n v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u Excel"},"content":{"rendered":"<p><strong>Ph\u00edm t\u1eaft Undo\/Redo<\/strong><\/p>\n<ul>\n<li><strong>Ctrl + Z<\/strong>: Ho\u00e0n t\u00e1c h\u00e0nh \u0111\u1ed9ng tr\u01b0\u1edbc \u0111\u00f3 (nhi\u1ec1u c\u1ea5p) &#8211; Undo.<\/li>\n<li><strong>Ctrl +<\/strong>\u00a0<strong>Y<\/strong>: \u0110i t\u1edbi h\u00e0nh \u0111\u1ed9ng ti\u1ebfp \u0111\u00f3 (nhi\u1ec1u c\u1ea5p) &#8211; Redo.<\/li>\n<\/ul>\n<p><strong>L\u00e0m vi\u1ec7c v\u1edbi Clipboard<\/strong><\/p>\n<ul>\n<li><strong>Ctrl + C<\/strong>: Sao ch\u00e9p n\u1ed9i dung c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<li><strong>Ctrl + X<\/strong>: C\u1eaft n\u1ed9i dung c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<li><strong>Ctrl + V<\/strong>: D\u00e1n n\u1ed9i dung t\u1eeb clipboard v\u00e0o \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<li><strong>Ctrl + Alt+ V<\/strong>: N\u1ebfu d\u1eef li\u1ec7u t\u1ed3n t\u1ea1i trong clipboard: Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Paste Special.<\/li>\n<\/ul>\n<p><strong>C\u00e1c ph\u00edm t\u1eaft ch\u1ec9nh s\u1eeda b\u00ean trong \u00f4 Excel<\/strong><\/p>\n<ul>\n<li><strong>F2<\/strong>: Ch\u1ec9nh s\u1eeda \u00f4 \u0111ang ch\u1ecdn v\u1edbi con tr\u1ecf chu\u1ed9t \u0111\u1eb7t \u1edf cu\u1ed1i d\u00f2ng.<\/li>\n<li><strong>Alt + Enter<\/strong>:\u00a0Xu\u1ed1ng d\u00f2ng trong c\u00f9ng m\u1ed9t \u00f4 Excel.<\/li>\n<li><strong>Enter<\/strong>: Ho\u00e0n th\u00e0nh nh\u1eadp 1 \u00f4 v\u00e0 di chuy\u1ec3n xu\u1ed1ng \u00f4 ph\u00eda d\u01b0\u1edbi.<\/li>\n<li><strong>Shift + Enter<\/strong>: Ho\u00e0n th\u00e0nh nh\u1eadp 1 \u00f4 v\u00e0 di chuy\u1ec3n l\u00ean \u00f4 ph\u00eda tr\u00ean.<\/li>\n<li><strong>Tab\/Shift + Tab<\/strong>: Ho\u00e0n th\u00e0nh nh\u1eadp 1 \u00f4 v\u00e0 di chuy\u1ec3n \u0111\u1ebfn \u00f4 b\u00ean ph\u1ea3i\/ho\u1eb7c b\u00ean tr\u00e1i.<\/li>\n<li><strong>Esc<\/strong>: H\u1ee7y b\u1ecf vi\u1ec7c s\u1eeda trong m\u1ed9t \u00f4.<\/li>\n<li><strong>Backspace<\/strong>: X\u00f3a k\u00fd t\u1ef1 b\u00ean tr\u00e1i c\u1ee7a con tr\u1ecf v\u0103n b\u1ea3n, ho\u1eb7c x\u00f3a c\u00e1c l\u1ef1a ch\u1ecdn.<\/li>\n<li><strong>Delete<\/strong>: X\u00f3a k\u00fd t\u1ef1 b\u00ean ph\u1ea3i c\u1ee7a con tr\u1ecf v\u0103n b\u1ea3n, ho\u1eb7c x\u00f3a c\u00e1c l\u1ef1a ch\u1ecdn.<\/li>\n<li><strong>Ctrl + Delete<\/strong>: X\u00f3a v\u0103n b\u1ea3n \u0111\u1ebfn cu\u1ed1i d\u00f2ng.<\/li>\n<li><strong>Ctrl + Shift + : (d\u1ea5u hai ch\u1ea5m)<\/strong>: Ch\u00e8n th\u1eddi gian hi\u1ec7n t\u1ea1i.<\/li>\n<li><strong>Alt + H + F + C:<\/strong>\u00a0Ph\u00edm t\u1eaft t\u00f4 m\u00e0u trong Excel, b\u1ea1n ch\u1ecdn \u00f4 c\u00f3 d\u1eef li\u1ec7u mu\u1ed1n \u0111\u1ed5i m\u00e0u, nh\u1ea5n ph\u00edm Alt r\u1ed3i nh\u1ea5n H, v\u1eabn gi\u1eef Alt nh\u1ea5n ti\u1ebfp F, ti\u1ebfp t\u1ee5c gi\u1eef Alt v\u00e0 nh\u1ea5n C r\u1ed3i ch\u1ecdn m\u00e0u c\u1ea7n \u0111\u1ed5i.<\/li>\n<\/ul>\n<p><strong>Ch\u1ec9nh s\u1eeda c\u00e1c \u00f4 ho\u1ea1t \u0111\u1ed9ng ho\u1eb7c l\u1ef1a ch\u1ecdn<\/strong><\/p>\n<ul>\n<li><strong>Ctrl + D<\/strong>: Copy n\u1ed9i dung \u1edf \u00f4 b\u00ean tr\u00ean.<\/li>\n<li><strong>Ctrl + R<\/strong>: Copy \u00f4 b\u00ean tr\u00e1i.<\/li>\n<li><strong>Ctrl + &#8220;<\/strong>: Copy n\u1ed9i dung \u00f4 b\u00ean tr\u00ean v\u00e0 \u1edf tr\u1ea1ng th\u00e1i ch\u1ec9nh s\u1eeda.<\/li>\n<li><strong>Ctrl + &#8216;<\/strong>: Copy c\u00f4ng th\u1ee9c c\u1ee7a \u00f4 b\u00ean tr\u00ean v\u00e0 \u1edf tr\u1ea1ng th\u00e1i ch\u1ec9nh s\u1eeda.<\/li>\n<li><strong>Ctrl + \u2013<\/strong>: Hi\u1ec3n th\u1ecb menu x\u00f3a \u00f4\/h\u00e0ng\/c\u1ed9t.<\/li>\n<li><strong>Ctrl + Shift + +<\/strong>: Hi\u1ec3n th\u1ecb menu ch\u00e8n \u00f4\/h\u00e0ng\/c\u1ed9t.<\/li>\n<li><strong>Shift + F2<\/strong>: Ch\u00e8n\/Ch\u1ec9nh s\u1eeda m\u1ed9t \u00f4 comment.<\/li>\n<li><strong>Shift + F10, sau \u0111\u00f3 M<\/strong>: X\u00f3a comment.<\/li>\n<li><strong>Alt + F1<\/strong>: T\u1ea1o v\u00e0 ch\u00e8n bi\u1ec3u \u0111\u1ed3 v\u1edbi d\u1eef li\u1ec7u trong ph\u1ea1m vi hi\u1ec7n t\u1ea1i.<\/li>\n<li><strong>F11<\/strong>: T\u1ea1o v\u00e0 ch\u00e8n bi\u1ec3u \u0111\u1ed3 v\u1edbi d\u1eef li\u1ec7u trong ph\u1ea1m vi hi\u1ec7n t\u1ea1i trong m\u1ed9t sheet bi\u1ec3u \u0111\u1ed3 ri\u00eang bi\u1ec7t.<\/li>\n<li><strong>Ctrl + K<\/strong>: Ch\u00e8n m\u1ed9t li\u00ean k\u1ebft.<\/li>\n<li><strong>Enter\u00a0<\/strong>(trong m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a li\u00ean k\u1ebft): K\u00edch ho\u1ea1t li\u00ean k\u1ebft.<\/li>\n<\/ul>\n<p><strong>\u1ea8n v\u00e0 hi\u1ec7n c\u00e1c ph\u1ea7n t\u1eed<\/strong><\/p>\n<ul>\n<li><strong>Ctrl + 9<\/strong>: \u1ea8n h\u00e0ng \u0111\u00e3 ch\u1ecdn.<\/li>\n<li><strong>Ctrl + Shift + 9<\/strong>: B\u1ecf \u1ea9n h\u00e0ng \u0111ang \u1ea9n trong v\u00f9ng l\u1ef1a ch\u1ecdn ch\u1ee9a h\u00e0ng \u0111\u00f3.<\/li>\n<li><strong>Ctrl + 0 (s\u1ed1 0)<\/strong>: \u1ea8n c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<li><strong>Ctrl + Shift + 0 (s\u1ed1 0)<\/strong>: B\u1ecf \u1ea9n c\u1ed9t \u0111ang \u1ea9n trong v\u00f9ng l\u1ef1a ch\u1ecdn.<\/li>\n<li><strong>L\u01b0u \u00fd<\/strong>: Trong Excel 2010 kh\u00f4ng c\u00f3 t\u00e1c d\u1ee5ng, \u0111\u1ec3 hi\u1ec7n c\u1ed9t v\u1eeba b\u1ecb \u1ea9n, nh\u1ea5n: Ctrl + Z.<\/li>\n<li><strong>Alt + Shift + \u25b7<\/strong>: Nh\u00f3m h\u00e0ng ho\u1eb7c c\u1ed9t.<\/li>\n<li><strong>Alt + Shift + \u25c1<\/strong>: B\u1ecf nh\u00f3m c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t.<\/li>\n<\/ul>\n<p><strong>Ch\u1ec9nh s\u1eeda b\u00ean trong \u00f4<\/strong><\/p>\n<ul>\n<li><strong>Shift + \u25c1\/Shift + \u25b7<\/strong>: Ch\u1ecdn ho\u1eb7c b\u1ecf ch\u1ecdn m\u1ed9t k\u00fd t\u1ef1 b\u00ean tr\u00e1i \/ b\u00ean ph\u1ea3i.<\/li>\n<li><strong>Ctrl + Shift + \u25c1\/Ctrl + Shift + \u25b7<\/strong>: Ch\u1ecdn ho\u1eb7c b\u1ecf ch\u1ecdn m\u1ed9t t\u1eeb b\u00ean tr\u00e1i \/ b\u00ean ph\u1ea3i.<\/li>\n<li><strong>Shift + Home\/Shift + End<\/strong>: Ch\u1ecdn t\u1eeb con tr\u1ecf v\u0103n b\u1ea3n \u0111\u1ebfn \u0111\u1ea7u \/ \u0111\u1ebfn cu\u1ed1i c\u1ee7a \u00f4.<\/li>\n<\/ul>\n<p>Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ph\u00edm t\u1eaft Undo\/Redo Ctrl + Z: Ho\u00e0n t\u00e1c h\u00e0nh \u0111\u1ed9ng tr\u01b0\u1edbc \u0111\u00f3 (nhi\u1ec1u c\u1ea5p) &#8211; Undo. Ctrl +\u00a0Y: \u0110i t\u1edbi h\u00e0nh \u0111\u1ed9ng ti\u1ebfp \u0111\u00f3 (nhi\u1ec1u c\u1ea5p) &#8211; Redo. L\u00e0m vi\u1ec7c v\u1edbi Clipboard Ctrl + C: Sao ch\u00e9p n\u1ed9i dung c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn. Ctrl + X: C\u1eaft n\u1ed9i dung c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn. Ctrl + [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":7374,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,508],"tags":[],"class_list":["post-7377","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tin-tuc","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=7377"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7377\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/7374"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=7377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}