{"id":35887,"date":"2022-08-03T22:38:39","date_gmt":"2022-08-03T15:38:39","guid":{"rendered":"https:\/\/jobsgo.vn\/blog\/?p=35887"},"modified":"2022-08-04T08:28:21","modified_gmt":"2022-08-04T01:28:21","slug":"cac-phim-tat-trong-excel","status":"publish","type":"post","link":"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/","title":{"rendered":"50+ Ph\u00edm t\u1eaft trong Excel \u0111\u1eaft gi\u00e1 nh\u1ea5t m\u00e0 b\u1ea1n n\u00ean bi\u1ebft"},"content":{"rendered":"\n<div class=\"kk-star-ratings\n     kksr-valign-top     kksr-align-left    \"\n    data-payload=\"{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;35887&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;count&quot;:&quot;0&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.5&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;\\u0110\\u00e1nh gi\\u00e1 post&quot;,&quot;legend&quot;:&quot;4.5\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;22&quot;,&quot;width&quot;:&quot;119&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;}\">\n    \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 119px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 22px; height: 22px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n    \n<div class=\"kksr-legend\">\n            <span class=\"kksr-muted\">\u0110\u00e1nh gi\u00e1 post<\/span>\n    <\/div>\n<\/div>\n<p><i>B\u1ea1n c\u00f3 bi\u1ebft ph\u1ea7n m\u1ec1m Excel c\u00f3 nh\u1eefng ph\u00edm t\u1eaft gi\u00fap vi\u1ec7c l\u01b0u tr\u1eef th\u00f4ng tin c\u1ee7a tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n v\u00e0 thu\u1eadn ti\u1ec7n h\u01a1n bao gi\u1edd h\u1ebft. H\u00e3y c\u00f9ng JobsGO \u0111i\u1ec3m qua <a href=\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#phim_tat_trong_Excel\" target=\"_blank\" rel=\"noopener\"><strong>c\u00e1c ph\u00edm t\u1eaft trong Excel<\/strong><\/a><\/i><i> nh\u00e9.<\/i><\/p>\n<p>Microsoft Excel l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m \u0111\u1ec3 l\u01b0u tr\u1eef v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i tr\u00ean to\u00e0n c\u1ea7u. M\u1eb7c d\u00f9 c\u00f3 nhi\u1ec1u ph\u1ea7n m\u1ec1m kh\u00e1c tr\u00ean th\u1ecb tr\u01b0\u1eddng c\u00f3 c\u00f9ng ch\u1ee9c n\u0103ng, nh\u01b0ng Excel v\u1eabn l\u00e0 s\u1ef1 l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi tin d\u00f9ng nh\u1ea5t.<\/p>\n<blockquote id=\"ph\u00edm_t\u1eaft_trong_excel\" cite=\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#keyboard_shortcuts_in_excel\"><p>Excel c\u00f3 r\u1ea5t nhi\u1ec1u ph\u00edm t\u1eaft gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u00e0 \u0111\u1ea3m b\u1ea3o n\u0103ng su\u1ea5t. Thay v\u00ec ph\u1ea3i d\u00f9ng chu\u1ed9t t\u00ecm ki\u1ebfm tr\u00ean thanh c\u00f4ng c\u1ee5, ch\u1ec9 v\u1edbi m\u1ed9t v\u00e0i t\u1ed5 h\u1ee3p ph\u00edm \u0111\u01a1n gi\u1ea3n, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c c\u00e1c ch\u1ee9c n\u0103ng quan tr\u1ecdng. H\u00e3y c\u00f9ng \u0111i\u1ec3m qua <strong>c\u00e1c ph\u00edm t\u1eaft trong Excel<\/strong> nh\u00e9.<\/p><\/blockquote>\n<div id=\"toc_container\" class=\"toc_light_blue no_bullets\"><p class=\"toc_title\">M\u1ee5c l\u1ee5c<\/p><ul class=\"toc_list\"><li><a href=\"#1_Cac_phim_tat_thuong_su_dung\">1. C\u00e1c ph\u00edm t\u1eaft th\u01b0\u1eddng s\u1eed d\u1ee5ng<\/a><\/li><li><a href=\"#2_Cac_phim_tat_dinh_dang_so\">2. C\u00e1c ph\u00edm t\u1eaft \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/a><\/li><li><a href=\"#3_Cac_phim_tat_chen_va_chinh_sua_du_lieu_trong_Excel\">3. C\u00e1c ph\u00edm t\u1eaft ch\u00e8n v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u trong Excel<\/a><\/li><li><a href=\"#4_Cac_phim_tat_di_chuyen_trong_Excel\">4. C\u00e1c ph\u00edm t\u1eaft di chuy\u1ec3n trong Excel<\/a><\/li><li><a href=\"#5_Cac_phim_tat_thao_tac_voi_o_hang_cot_trong_Excel\">5. C\u00e1c ph\u00edm t\u1eaft thao t\u00e1c v\u1edbi \u00f4, h\u00e0ng, c\u1ed9t trong Excel<\/a><\/li><li><a href=\"#6_Cac_phim_tat_voi_Sheet_trong_Excel\">6. C\u00e1c ph\u00edm t\u1eaft v\u1edbi Sheet trong Excel<\/a><\/li><\/ul><\/div>\n<h2><span id=\"1_Cac_phim_tat_thuong_su_dung\"><strong>1. C\u00e1c ph\u00edm t\u1eaft th\u01b0\u1eddng s\u1eed d\u1ee5ng<\/strong><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><strong>STT<\/strong><\/td>\n<td><strong> M\u00f4 t\u1ea3<\/strong><\/td>\n<td><strong>Ph\u00edm t\u1eaft<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>T\u1ea1o m\u1ed9t file m\u1edbi trong Excel<\/td>\n<td>Ctrl + N<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>M\u1edf m\u1ed9t file c\u00f3 s\u1eb5n trong Excel<\/td>\n<td>Ctrl + O<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>L\u01b0u file\/trang t\u00ednh<\/td>\n<td>Ctrl + S<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>\u0110\u00f3ng file \u0111ang ch\u1ec9nh s\u1eeda<\/td>\n<td>Ctrl + W<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>\u0110\u00f3ng Excel<\/td>\n<td>Ctrl + F4<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Chuy\u1ec3n \u0111\u1ebfn sheet ti\u1ebfp theo<\/td>\n<td>Ctrl + Page Down<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>Chuy\u1ec3n \u0111\u1ebfn sheet tr\u01b0\u1edbc \u0111\u00f3<\/td>\n<td>Ctrl + Page Up<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>M\u1edf tab Data tr\u00ean thanh c\u00f4ng c\u1ee5<\/td>\n<td>Alt + A<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>M\u1edf tab View tr\u00ean thanh c\u00f4ng c\u1ee5<\/td>\n<td>Alt + W<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>M\u1edf tab Formulas tr\u00ean thanh c\u00f4ng c\u1ee5<\/td>\n<td>Alt + M<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span id=\"2_Cac_phim_tat_dinh_dang_so\"><strong>2. C\u00e1c ph\u00edm t\u1eaft \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/strong><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><strong>STT<\/strong><\/td>\n<td><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<td><strong>Ph\u00edm t\u1eaft<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>D\u00f9ng \u0111\u1ecbnh d\u1ea1ng chung<\/td>\n<td>Ctrl + Shift + ~<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>D\u00f9ng \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7<\/td>\n<td>Ctrl + Shift + $<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>D\u00f9ng \u0111\u1ecbnh d\u1ea1ng ph\u1ea7n tr\u0103m<\/td>\n<td>Ctrl + Shift + %<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>D\u00f9ng \u0111\u1ecbnh d\u1ea1ng khoa h\u1ecdc<\/td>\n<td>Ctrl + Shift + ^<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>D\u00f9ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y<\/td>\n<td>Ctrl + Shift + #<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>D\u00f9ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian<\/td>\n<td>Ctrl + Shift + @<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>D\u00f9ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/td>\n<td>Ctrl + Shift + !<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span id=\"3_Cac_phim_tat_chen_va_chinh_sua_du_lieu_trong_Excel\"><strong>3. C\u00e1c ph\u00edm t\u1eaft ch\u00e8n v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u trong Excel<\/strong><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><strong>STT<\/strong><\/td>\n<td><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<td><strong>Ph\u00edm t\u1eaft<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Ho\u00e0n t\u00e1c thao t\u00e1c tr\u01b0\u1edbc \u0111\u00f3<\/td>\n<td>Ctrl + Z<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>\u0110i t\u1edbi thao t\u00e1c sau \u0111\u00f3<\/td>\n<td>Ctrl + Y<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Sao ch\u00e9p n\u1ed9i dung \u00f4 v\u1eeba ch\u1ecdn<\/td>\n<td>Ctrl + C<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>C\u1eaft n\u1ed9i dung \u00f4 v\u1eeba ch\u1ecdn<\/td>\n<td>Ctrl + X<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>D\u00e1n n\u1ed9i dung v\u00e0o \u00f4 v\u1eeba ch\u1ecdn<\/td>\n<td>Ctrl + V<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Xu\u1ed1ng d\u00f2ng trong m\u1ed9t \u00f4<\/td>\n<td>Alt + Enter<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>Sao ch\u00e9p n\u1ed9i dung trong \u00f4 b\u00ean tr\u00ean<\/td>\n<td>Ctrl + D<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>Sao ch\u00e9p \u00f4 b\u00ean tr\u00e1i.<\/td>\n<td>Ctrl + R<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>Sao ch\u00e9p n\u1ed9i dung trong \u00f4 b\u00ean tr\u00ean \u1edf tr\u1ea1ng th\u00e1i ch\u1ec9nh s\u1eeda.<\/td>\n<td>Ctrl + \u201c<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>Sao ch\u00e9p c\u00f4ng th\u1ee9c \u00f4 b\u00ean tr\u00ean \u1edf tr\u1ea1ng th\u00e1i ch\u1ec9nh s\u1eeda.<\/td>\n<td>Ctrl + \u2018<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>T\u1ea1o v\u00e0 ch\u00e8n bi\u1ec3u \u0111\u1ed3 cho v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn.<\/td>\n<td>Alt + F1<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>Ch\u00e8n hyperlink<\/td>\n<td>Ctrl + K<\/td>\n<\/tr>\n<tr>\n<td>13<\/td>\n<td>T\u1ea1o v\u00e0 ch\u00e8n bi\u1ec3u \u0111\u1ed3 cho v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 ch\u1ecdn trong sheet bi\u1ec3u \u0111\u1ed3 ri\u00eang bi\u1ec7t.<\/td>\n<td>F11<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span id=\"4_Cac_phim_tat_di_chuyen_trong_Excel\"><strong>4. C\u00e1c ph\u00edm t\u1eaft di chuy\u1ec3n trong Excel<\/strong><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><strong>STT<\/strong><\/td>\n<td><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<td><strong>Ph\u00edm t\u1eaft<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Di chuy\u1ec3n trong m\u1ed9t trang t\u00ednh<\/td>\n<td>C\u00e1c ph\u00edm m\u0169i t\u00ean \u2191 \u2192 \u2190 \u2193<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Di chuy\u1ec3n l\u00ean \u0111\u1ea7u\/xu\u1ed1ng cu\u1ed1i trang t\u00ednh<\/td>\n<td>Page Up\/Page Down<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Di chuy\u1ec3n \u0111\u1ebfn \u00f4 \u0111\u1ea7u c\u1ee7a trang t\u00ednh<\/td>\n<td>Alt + Home<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Di chuy\u1ec3n \u0111\u1ebfn \u00f4 cu\u1ed1i c\u1ee7a trang t\u00ednh<\/td>\n<td>Alt + End<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Di chuy\u1ec3n \u0111\u1ebfn \u00f4 \u0111\u1ea7u trong h\u00e0ng<\/td>\n<td>Home<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span id=\"5_Cac_phim_tat_thao_tac_voi_o_hang_cot_trong_Excel\"><strong>5. C\u00e1c ph\u00edm t\u1eaft thao t\u00e1c v\u1edbi \u00f4, h\u00e0ng, c\u1ed9t trong Excel<\/strong><\/span><\/h2>\n<ul>\n<li><strong>C\u00e1c ph\u00edm t\u1eaft trong Excel<\/strong> thao t\u00e1c v\u1edbi \u00f4<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><strong>STT<\/strong><\/td>\n<td><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<td><strong>Ph\u00edm t\u1eaft<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>S\u1eeda \u00f4<\/td>\n<td>F2<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>T\u00f4 m\u00e0u cho \u00f4<\/td>\n<td>Alt + H + H<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>T\u1ea1o vi\u1ec1n cho \u00f4<\/td>\n<td>Alt + H + B<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>B\u1ecf vi\u1ec1n cho \u00f4<\/td>\n<td>Ctrl + Shift + _<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Chuy\u1ec3n \u0111\u1ebfn \u00f4 b\u00ean tr\u00e1i<\/td>\n<td>Shift + Tab<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Chuy\u1ec3n \u0111\u1ebfn \u00f4 b\u00ean ph\u1ea3i<\/td>\n<td>Tab<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u1edf b\u00ean tr\u00e1i \u00f4 \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Ctrl + Shift + \u2190<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u1edf b\u00ean ph\u1ea3i \u00f4 \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Ctrl + Shift + \u2192<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u1edf b\u00ean d\u01b0\u1edbi \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Ctrl + Shift + \u2193<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u1edf b\u00ean tr\u00ean \u00f4 \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Ctrl + Shift + \u2191<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li><strong>C\u00e1c ph\u00edm t\u1eaft trong <a rel=\"nofollow\" href=\"https:\/\/en.wikipedia.org\/wiki\/Microsoft_Excel\">Excel<\/a><\/strong> thao t\u00e1c v\u1edbi h\u00e0ng\/c\u1ed9t<\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td>STT<\/td>\n<td>M\u00f4 t\u1ea3<\/td>\n<td>Ph\u00edm t\u1eaft<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Ch\u1ecdn to\u00e0n b\u1ed9 m\u1ed9t h\u00e0ng<\/td>\n<td>Shift + Ph\u00edm c\u00e1ch<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Ch\u1ecdn to\u00e0n b\u1ed9 m\u1ed9t c\u1ed9t<\/td>\n<td>Ctrl + Ph\u00edm c\u00e1ch<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>X\u00f3a c\u1ed9t<\/td>\n<td>Alt + H + D + C<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>X\u00f3a h\u00e0ng<\/td>\n<td>Shift + Ph\u00edm c\u00e1ch,<\/p>\n<p>Ctrl + &#8211;<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>\u1ea8n h\u00e0ng \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Ctrl + 9<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>B\u1ecf \u1ea9n h\u00e0ng \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Ctrl + Shift + 9<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>\u1ea8n c\u1ed9t \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Ctrl + 0<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>B\u1ecf \u1ea9n c\u1ed9t \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Ctrl + Shift + 0<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>Nh\u00f3m c\u00e1c h\u00e0ng\/c\u1ed9t \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Alt + Shift + \u2192<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>B\u1ecf nh\u00f3m c\u00e1c h\u00e0ng\/c\u1ed9t \u0111\u00e3 ch\u1ecdn<\/td>\n<td>Alt + Shift + \u2190<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span id=\"6_Cac_phim_tat_voi_Sheet_trong_Excel\"><strong>6. C\u00e1c ph\u00edm t\u1eaft v\u1edbi Sheet trong Excel<\/strong><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><strong>STT<\/strong><\/td>\n<td><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<td><strong>Ph\u00edm t\u1eaft<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Chuy\u1ec3n sang sheet b\u00ean tr\u00e1i<\/td>\n<td>Ctrl + Page Up<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Chuy\u1ec3n sang sheet b\u00ean ph\u1ea3i<\/td>\n<td>Ctrl + Page Down<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>C\u00e1c ph\u00edm t\u1eaft trong Excel<\/strong> s\u1ebd gi\u00fap b\u1ea1n x\u00e2y d\u1ef1ng b\u00e1o c\u00e1o v\u00e0 ph\u00e2n t\u00edch c\u1ee7a m\u00ecnh nhanh h\u01a1n, thu\u1eadn ti\u1ec7n h\u01a1n. JobsGO hy v\u1ecdng b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u00e0nh th\u1ea1o c\u00e1c ph\u00edm t\u1eaft n\u00e0y b\u1eb1ng c\u00e1ch th\u1ef1c h\u00e0ng ch\u00fang tr\u00ean Excel th\u01b0\u1eddng xuy\u00ean.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u00e1nh gi\u00e1 post B\u1ea1n c\u00f3 bi\u1ebft ph\u1ea7n m\u1ec1m Excel c\u00f3 nh\u1eefng ph\u00edm t\u1eaft gi\u00fap vi\u1ec7c l\u01b0u tr\u1eef th\u00f4ng tin c\u1ee7a tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n v\u00e0 thu\u1eadn ti\u1ec7n h\u01a1n bao gi\u1edd h\u1ebft. H\u00e3y c\u00f9ng JobsGO \u0111i\u1ec3m qua c\u00e1c ph\u00edm t\u1eaft trong&#8230;<\/p>\n","protected":false},"author":13356,"featured_media":35910,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"C\u00e1c ph\u00edm t\u1eaft trong Excel","_yoast_wpseo_title":"C\u00e1c ph\u00edm t\u1eaft trong Excel h\u1eefu \u00edch nh\u1ea5t m\u00e0 b\u1ea1n n\u00ean bi\u1ebft - JobsGO Blog","_yoast_wpseo_metadesc":"C\u00e1c ph\u00edm t\u1eaft trong Excel gi\u00fap b\u1ea1n l\u1ef1a ch\u1ecdn v\u00e0 th\u1ef1c hi\u1ec7n nhanh c\u00e1c ho\u1ea1t \u0111\u1ed9ng nh\u01b0 t\u1eaft ph\u00edm t\u1eaft v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u Ctrl + D ...","_yoast_wpseo_focus_keyphrase":"","faq":"","nganh_nghe_chuc_vu_lien_quan":["Nh\u00e2n Vi\u00ean K\u1ebf To\u00e1n"]},"categories":[1032],"tags":[],"yoast_head":"\n<title>C\u00e1c ph\u00edm t\u1eaft trong Excel h\u1eefu \u00edch nh\u1ea5t m\u00e0 b\u1ea1n n\u00ean bi\u1ebft - JobsGO Blog<\/title>\n<meta name=\"description\" content=\"C\u00e1c ph\u00edm t\u1eaft trong Excel gi\u00fap b\u1ea1n l\u1ef1a ch\u1ecdn v\u00e0 th\u1ef1c hi\u1ec7n nhanh c\u00e1c ho\u1ea1t \u0111\u1ed9ng nh\u01b0 t\u1eaft ph\u00edm t\u1eaft v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u Ctrl + D ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c ph\u00edm t\u1eaft trong Excel h\u1eefu \u00edch nh\u1ea5t m\u00e0 b\u1ea1n n\u00ean bi\u1ebft - JobsGO Blog\" \/>\n<meta property=\"og:description\" content=\"C\u00e1c ph\u00edm t\u1eaft trong Excel gi\u00fap b\u1ea1n l\u1ef1a ch\u1ecdn v\u00e0 th\u1ef1c hi\u1ec7n nhanh c\u00e1c ho\u1ea1t \u0111\u1ed9ng nh\u01b0 t\u1eaft ph\u00edm t\u1eaft v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u Ctrl + D ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"JobsGO Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/JobsGOVN\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-03T15:38:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-04T01:28:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jobsgo.vn\/blog\/wp-content\/uploads\/2022\/08\/phim-tat-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1724\" \/>\n\t<meta property=\"og:image:height\" content=\"1316\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#organization\",\"name\":\"JobsGO\",\"url\":\"https:\/\/jobsgo.vn\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/JobsGOVN\/\",\"http:\/\/instagram.com\/jobsgo_vn\",\"https:\/\/www.linkedin.com\/company\/josbgo.vn\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/jobsgo.vn\/blog\/wp-content\/uploads\/2018\/01\/jobsgo-logo.png\",\"contentUrl\":\"https:\/\/jobsgo.vn\/blog\/wp-content\/uploads\/2018\/01\/jobsgo-logo.png\",\"width\":149,\"height\":161,\"caption\":\"JobsGO\"},\"image\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#website\",\"url\":\"https:\/\/jobsgo.vn\/blog\/\",\"name\":\"JobsGO Blog\",\"description\":\"T\\u1ed5ng h\\u1ee3p c\\u00e1c b\\u00ed quy\\u1ebft t\\u00ecm vi\\u1ec7c v\\u00e0 ph\\u00e1t tri\\u1ec3n s\\u1ef1 nghi\\u1ec7p v\\u1edbi JobsGO\",\"publisher\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/jobsgo.vn\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2022\/08\/phim-tat-excel.png\",\"contentUrl\":\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2022\/08\/phim-tat-excel.png\",\"width\":1724,\"height\":1316,\"caption\":\"ph\\u00edm t\\u1eaft excel\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#webpage\",\"url\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/\",\"name\":\"C\\u00e1c ph\\u00edm t\\u1eaft trong Excel h\\u1eefu \\u00edch nh\\u1ea5t m\\u00e0 b\\u1ea1n n\\u00ean bi\\u1ebft - JobsGO Blog\",\"isPartOf\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#primaryimage\"},\"datePublished\":\"2022-08-03T15:38:39+00:00\",\"dateModified\":\"2022-08-04T01:28:21+00:00\",\"description\":\"C\\u00e1c ph\\u00edm t\\u1eaft trong Excel gi\\u00fap b\\u1ea1n l\\u1ef1a ch\\u1ecdn v\\u00e0 th\\u1ef1c hi\\u1ec7n nhanh c\\u00e1c ho\\u1ea1t \\u0111\\u1ed9ng nh\\u01b0 t\\u1eaft ph\\u00edm t\\u1eaft v\\u00e0 ch\\u1ec9nh s\\u1eeda d\\u1eef li\\u1ec7u Ctrl + D ...\",\"breadcrumb\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/\",\"url\":\"https:\/\/jobsgo.vn\/blog\/\",\"name\":\"Trang ch\\u1ee7\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#webpage\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#webpage\"},\"author\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#\/schema\/person\/4da5b3ab5b23034fca998bb68f1760cf\"},\"headline\":\"50+ Ph\\u00edm t\\u1eaft trong Excel \\u0111\\u1eaft gi\\u00e1 nh\\u1ea5t m\\u00e0 b\\u1ea1n n\\u00ean bi\\u1ebft\",\"datePublished\":\"2022-08-03T15:38:39+00:00\",\"dateModified\":\"2022-08-04T01:28:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#webpage\"},\"wordCount\":1116,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2022\/08\/phim-tat-excel.png\",\"articleSection\":[\"K\\u1ef9 n\\u0103ng c\\u00f4ng s\\u1edf\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/jobsgo.vn\/blog\/cac-phim-tat-trong-excel\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#\/schema\/person\/4da5b3ab5b23034fca998bb68f1760cf\",\"name\":\"B\\u1ea3o Danh\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/jobsgo.vn\/blog\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e6a9c2b21ba6d61f9669594dc2f2085e?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e6a9c2b21ba6d61f9669594dc2f2085e?s=96&r=g\",\"caption\":\"B\\u1ea3o Danh\"},\"sameAs\":[\"admin\"],\"url\":\"https:\/\/jobsgo.vn\/blog\/author\/baodanhvt1998\/\"}]}<\/script>\n","featured_image_url":"https:\/\/media-blog.jobsgo.vn\/blog\/wp-content\/uploads\/2022\/08\/phim-tat-excel-600x400.png","_links":{"self":[{"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/posts\/35887"}],"collection":[{"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/users\/13356"}],"replies":[{"embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/comments?post=35887"}],"version-history":[{"count":2,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/posts\/35887\/revisions"}],"predecessor-version":[{"id":35909,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/posts\/35887\/revisions\/35909"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/media\/35910"}],"wp:attachment":[{"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/media?parent=35887"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/categories?post=35887"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jobsgo.vn\/blog\/wp-json\/wp\/v2\/tags?post=35887"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}