{"id":7380,"date":"2021-08-09T19:16:05","date_gmt":"2021-08-09T12:16:05","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7380"},"modified":"2021-08-18T11:08:38","modified_gmt":"2021-08-18T04:08:38","slug":"nhom-phim-tat-lam-viec-voi-du-lieu-duoc-chon","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/nhom-phim-tat-lam-viec-voi-du-lieu-duoc-chon\/","title":{"rendered":"Nh\u00f3m ph\u00edm t\u1eaft l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn Excel"},"content":{"rendered":"<p><strong>Ch\u1ecdn c\u00e1c \u00f4<\/strong><\/p>\n<ul>\n<li><strong>Shift + Space (Ph\u00edm c\u00e1ch)<\/strong>: Ch\u1ecdn to\u00e0n b\u1ed9 h\u00e0ng.<\/li>\n<li><strong>Ctrl + Space (Ph\u00edm c\u00e1ch)<\/strong>: Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t.<\/li>\n<li><strong>Ctrl + Shift + * (d\u1ea5u sao)<\/strong>: Ch\u1ecdn to\u00e0n b\u1ed9 khu v\u1ef1c xung quanh c\u00e1c \u00f4 \u0111ang ho\u1ea1t \u0111\u1ed9ng.<\/li>\n<li><strong>Ctrl + A (ho\u1eb7c Ctrl + Shift + ph\u00edm c\u00e1ch)<\/strong>: Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh (ho\u1eb7c c\u00e1c khu v\u1ef1c ch\u1ee9a d\u1eef li\u1ec7u).<\/li>\n<li><strong>Ctrl + Shift + Pg Up<\/strong>: Ch\u1ecdn sheet hi\u1ec7n t\u1ea1i v\u00e0 tr\u01b0\u1edbc \u0111\u00f3 trong c\u00f9ng file Excel.<\/li>\n<li><strong>Shift + \u25bd\u25c1\u25b7\u25b3<\/strong>: M\u1edf r\u1ed9ng v\u00f9ng l\u1ef1a ch\u1ecdn t\u1eeb m\u1ed9t \u00f4 \u0111ang ch\u1ecdn.<\/li>\n<li><strong>Ctrl + Shift + \u25bd\/\u25b3<\/strong>: Ch\u1ecdn\/b\u1ecf ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 k\u1ec3 t\u1eeb \u00f4 \u0111ang ch\u1ecdn \u0111\u1ebfn cu\u1ed1i c\u1ed9t<\/li>\n<li><strong>Shift + Pg Dn\/Shift + Pg Up<\/strong>: M\u1edf r\u1ed9ng v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn xu\u1ed1ng cu\u1ed1i trang m\u00e0n h\u00ecnh \/ l\u00ean \u0111\u1ea7u trang m\u00e0n h\u00ecnh.<\/li>\n<li><strong>Shift + Home<\/strong>: M\u1edf r\u1ed9ng v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn v\u1ec1 \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a h\u00e0ng.<\/li>\n<li><strong>Ctrl + Shift + Home<\/strong>: M\u1edf r\u1ed9ng v\u00f9ng ch\u1ecdn v\u1ec1 \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng t\u00ednh.<\/li>\n<li><strong>Ctrl + Shift + End<\/strong>: M\u1edf r\u1ed9ng v\u00f9ng ch\u1ecdn \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng tr\u00ean b\u1ea3ng t\u00ednh (g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i).<\/li>\n<\/ul>\n<p><strong>Qu\u1ea3n l\u00fd trong c\u00e1c v\u00f9ng l\u1ef1a ch\u1ecdn<\/strong><\/p>\n<ul>\n<li><strong>F8<\/strong>: B\u1eadt t\u00ednh n\u0103ng m\u1edf r\u1ed9ng v\u00f9ng l\u1ef1a ch\u1ecdn (b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng th\u00eam c\u00e1c ph\u00edm m\u0169i t\u00ean) m\u00e0 kh\u00f4ng c\u1ea7n nh\u1ea5n gi\u1eef ph\u00edm Shift.<\/li>\n<li><strong>Shift + F8<\/strong>: Th\u00eam m\u1ed9t (li\u1ec1n k\u1ec1 ho\u1eb7c kh\u00f4ng li\u1ec1n k\u1ec1) d\u00e3y c\u00e1c \u00f4 \u0111\u1ec3 l\u1ef1a ch\u1ecdn. S\u1eed d\u1ee5ng c\u00e1c ph\u00edm m\u0169i t\u00ean v\u00e0 Shift + ph\u00edm m\u0169i t\u00ean \u0111\u1ec3 th\u00eam v\u00e0o l\u1ef1a ch\u1ecdn.<\/li>\n<li><strong>Enter\/Shift + Enter<\/strong>: Di chuy\u1ec3n l\u1ef1a ch\u1ecdn \u00f4 hi\u1ec7n t\u1ea1i xu\u1ed1ng\/l\u00ean trong v\u00f9ng \u0111ang \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<li><strong>Tab\/Shift + Tab<\/strong>: Di chuy\u1ec3n l\u1ef1a ch\u1ecdn \u00f4 hi\u1ec7n t\u1ea1i sang ph\u1ea3i\/tr\u00e1i trong v\u00f9ng \u0111ang \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<li><strong>Esc<\/strong>: H\u1ee7y b\u1ecf v\u00f9ng \u0111ang ch\u1ecdn.<\/li>\n<\/ul>\n<p>Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ch\u1ecdn c\u00e1c \u00f4 Shift + Space (Ph\u00edm c\u00e1ch): Ch\u1ecdn to\u00e0n b\u1ed9 h\u00e0ng. Ctrl + Space (Ph\u00edm c\u00e1ch): Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t. Ctrl + Shift + * (d\u1ea5u sao): Ch\u1ecdn to\u00e0n b\u1ed9 khu v\u1ef1c xung quanh c\u00e1c \u00f4 \u0111ang ho\u1ea1t \u0111\u1ed9ng. Ctrl + A (ho\u1eb7c Ctrl + Shift + ph\u00edm c\u00e1ch): Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh [&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-7380","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\/7380","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=7380"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7380\/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=7380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}