{"id":7382,"date":"2021-08-09T19:19:49","date_gmt":"2021-08-09T12:19:49","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7382"},"modified":"2021-08-18T11:08:38","modified_gmt":"2021-08-18T04:08:38","slug":"nhom-phim-tat-dinh-dang-du-lieu-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/nhom-phim-tat-dinh-dang-du-lieu-excel\/","title":{"rendered":"Nh\u00f3m ph\u00edm t\u1eaft \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u Excel"},"content":{"rendered":"<p><strong>\u0110\u1ecbnh d\u1ea1ng \u00f4<\/strong><\/p>\n<ul>\n<li><strong>Ctrl + 1<\/strong>: Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Format.<\/li>\n<li><strong>Ctrl + B (<\/strong>ho\u1eb7c<strong>\u00a0Ctrl + 2)<\/strong>: \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng ch\u1eef \u0111\u1eadm.<\/li>\n<li><strong>Ctrl + I (<\/strong>ho\u1eb7c<strong>\u00a0Ctrl + 3)<\/strong>: \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng in nghi\u00eang.<\/li>\n<li><strong>Ctrl + U (<\/strong>ho\u1eb7c<strong>\u00a0Ctrl + 4<\/strong>): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf m\u1ed9t g\u1ea1ch d\u01b0\u1edbi.<\/li>\n<li><strong>Ctrl + 5<\/strong>: \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng g\u1ea1ch ngang.<\/li>\n<li><strong>Alt + &#8216;\u00a0<\/strong>(d\u1ea5u nh\u00e1y \u0111\u01a1n) : Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Style.<\/li>\n<\/ul>\n<p><strong>C\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/strong><\/p>\n<ul>\n<li><strong>Ctrl + Shift + $<\/strong>: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 v\u1edbi hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/li>\n<li><strong>Ctrl + Shift + ~<\/strong>: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ki\u1ec3u General.<\/li>\n<li><strong>Ctrl + Shift + #<\/strong>: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y theo ki\u1ec3u ng\u00e0y, th\u00e1ng v\u00e0 n\u0103m.<\/li>\n<li><strong>Ctrl + Shift + @<\/strong>: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian v\u1edbi gi\u1edd, ph\u00fat v\u00e0 ch\u1ec9 ra AM ho\u1eb7c PM.<\/li>\n<li><strong>Ctrl + Shift + ^<\/strong>: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 khoa h\u1ecdc v\u1edbi hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/li>\n<li><strong>F4<\/strong>: L\u1eb7p l\u1ea1i l\u1ef1a ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng cu\u1ed1i c\u00f9ng.<\/li>\n<\/ul>\n<p><strong>C\u0103n \u00f4<\/strong><\/p>\n<ul>\n<li><strong>Alt + H, A, R<\/strong>: C\u0103n \u00f4 sang ph\u1ea3i.<\/li>\n<li><strong>Alt + H, A, C<\/strong>: C\u0103n gi\u1eefa \u00f4.<\/li>\n<li><strong>Alt + H, A, I<\/strong>: C\u0103n \u00f4 sang tr\u00e1i.<\/li>\n<\/ul>\n<p><strong>Ph\u00edm t\u1eaft c\u00f4ng th\u1ee9c<\/strong><\/p>\n<ul>\n<li><strong>=<\/strong>: B\u1eaft \u0111\u1ea7u m\u1ed9t c\u00f4ng th\u1ee9c.<\/li>\n<li><strong>Shift + F3:<\/strong>\u00a0Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Insert Function.<\/li>\n<li><strong>Ctrl + A<\/strong>: Hi\u1ec3n th\u1ecb c\u00e1ch th\u1ee9c nh\u1eadp sau khi nh\u1eadp t\u00ean c\u1ee7a c\u00f4ng th\u1ee9c.<\/li>\n<li><strong>Ctrl + Shift + A<\/strong>: Ch\u00e8n c\u00e1c \u0111\u1ed1i s\u1ed1 trong c\u00f4ng th\u1ee9c sau khi nh\u1eadp t\u00ean c\u1ee7a c\u00f4ng th\u1ee9c.<\/li>\n<li><strong>Shift + F3<\/strong>: Ch\u00e8n m\u1ed9t h\u00e0m th\u00e0nh m\u1ed9t c\u00f4ng th\u1ee9c.<\/li>\n<li><strong>Ctrl + Shift + Enter<\/strong>: Nh\u1eadp c\u00f4ng th\u1ee9c l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng.<\/li>\n<li><strong>F9<\/strong>: T\u00ednh t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng trong t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh.<\/li>\n<li><strong>Shift + F9<\/strong>: T\u00ednh to\u00e1n b\u1ea3ng t\u00ednh ho\u1ea1t \u0111\u1ed9ng.<\/li>\n<li><strong>Ctrl + Shift + U<\/strong>: Chuy\u1ec3n ch\u1ebf \u0111\u1ed9 m\u1edf r\u1ed9ng ho\u1eb7c thu g\u1ecdn thanh c\u00f4ng th\u1ee9c.<\/li>\n<li><strong>Ctrl + &#8216;<\/strong>: Chuy\u1ec3n ch\u1ebf \u0111\u1ed9 Hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong \u00f4 thay v\u00ec gi\u00e1 tr\u1ecb.<\/li>\n<li><strong>Ctrl + Pg Dn (PageDown):\u00a0<\/strong>Ph\u00edm t\u1eaft chuy\u1ec3n Sheet sang sheet ngay b\u00ean ph\u1ea3i sheet \u0111ang m\u1edf<\/li>\n<li><strong>Ctrl + Pg Up (PageUp)<\/strong>: Chuy\u1ec3n sang sheet b\u00ean tr\u00e1i sheet \u0111ang m\u1edf.<\/li>\n<li><strong>Ctrl +\u00a0\u25b3\u25bd\u25c1\u25b7<\/strong>: Di chuy\u1ec3n t\u1edbi d\u00f2ng tr\u00ean c\u00f9ng, d\u01b0\u1edbi c\u00f9ng, c\u1ea1nh tr\u00e1i, c\u1ea1nh ph\u1ea3i c\u1ee7a b\u1ea3ng t\u00ednh.<\/li>\n<li><strong>Ctrl +\u00a0\u25b3\u25bd\u25c1\u25b7\u00a0+ Shift<\/strong>: khoanh ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u t\u1edbi cu\u1ed1i b\u1ea3ng thay v\u00ec ch\u1ec9 di chuy\u1ec3n \u00f4 ch\u1ecdn xu\u1ed1ng cu\u1ed1i b\u1ea3ng.<\/li>\n<li>\n<p class=\"_ilcss7_\"><strong>Ctrl + Shift + 1 (!)<\/strong>: \u0110\u1ecbnh d\u1ea1ng \u00f4 d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n v\u1edbi 2 s\u1ed1 sau d\u1ea5u ph\u1ea9y.<\/p>\n<\/li>\n<li><strong>Ctrl + Shift + 4 ($)<\/strong>: \u0110\u1ecbnh d\u1ea1ng \u00f4 ti\u1ec1n t\u1ec7 $.<\/li>\n<li><strong>Ctrl + Shift + 5 (%)<\/strong>: \u0110\u1ecbnh d\u1ea1ng \u00f4 l\u00e0 s\u1ed1 %.<\/li>\n<li><strong>Ctrl + Shift +; (d\u1ea5u ch\u1ea5m ph\u1ea9y)<\/strong>: \u0110i\u1ec1n nhanh th\u1eddi gian hi\u1ec7n t\u1ea1i v\u00e0o \u00f4 trong b\u1ea3ng t\u00ednh.<\/li>\n<li><strong>Ctrl + ; (d\u1ea5u ch\u1ea5m ph\u1ea9y)<\/strong>: \u0110i\u1ec1n ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0o \u00f4.<\/li>\n<li><strong>Ctrl + ~ (c\u1ea1nh s\u1ed1 1)<\/strong>: Xem to\u00e0n b\u1ed9 c\u00e1c \u00f4 \u1edf d\u1ea1ng c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<p>Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ecbnh d\u1ea1ng \u00f4 Ctrl + 1: Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Format. Ctrl + B (ho\u1eb7c\u00a0Ctrl + 2): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng ch\u1eef \u0111\u1eadm. Ctrl + I (ho\u1eb7c\u00a0Ctrl + 3): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng in nghi\u00eang. Ctrl + U (ho\u1eb7c\u00a0Ctrl + 4): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf m\u1ed9t g\u1ea1ch d\u01b0\u1edbi. [&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-7382","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\/7382","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=7382"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7382\/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=7382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}