{"id":268183,"date":"2023-10-10T20:05:05","date_gmt":"2023-10-10T13:05:05","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=268183"},"modified":"2023-10-10T20:05:05","modified_gmt":"2023-10-10T13:05:05","slug":"thu-thuat-excel-2","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel-2\/","title":{"rendered":"10 th\u1ee7 thu\u1eadt Excel c\u1ef1c k\u1ef3 h\u1eefu \u00edch, b\u1eaft bu\u1ed9c ph\u1ea3i nh\u1edb"},"content":{"rendered":"

K\u1ef9 n\u0103ng s\u1eed d\u1ee5ng Excel m\u1ed9t c\u00e1ch th\u00e0nh th\u1ea1o mang l\u1ea1i r\u1ea5t nhi\u1ec1u l\u1ee3i \u00edch cho b\u1ea1n, \u0111\u1eb7c bi\u1ec7t l\u00e0 nh\u1eefng <\/span>th\u1ee7 thu\u1eadt Excel<\/b> s\u1ebd l\u00e0 ch\u00eca kh\u00f3a th\u1eddi gian gi\u00fap b\u1ea1n n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c b\u1ea5t k\u1ec3 b\u1ea1n l\u00e0m vi\u1ec7c trong l\u0129nh v\u1ef1c n\u00e0o t\u1eeb kinh doanh, t\u00e0i ch\u00ednh, cho \u0111\u1ebfn qu\u1ea3n l\u00fd d\u1ef1 \u00e1n,… Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd v\u00e0 linh ho\u1ea1t, gi\u00fap b\u1ea1n t\u1ed5 ch\u1ee9c v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, t\u1eeb \u0111\u00f3 gi\u00fap b\u1ea1n \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh th\u00f4ng minh v\u00e0 nhanh ch\u00f3ng. H\u00f4m nay Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n 10 th\u1ee7 thu\u1eadt Excel c\u1ef1c k\u1ef3 h\u1eefu \u00edch, l\u1eddi khuy\u00ean r\u1eb1ng h\u00e3y n\u00ean ghi nh\u1edb \u0111\u1ec3 c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean tr\u00f4i ch\u1ea3y h\u01a1n.<\/span><\/p>\n

Ch\u1ecdn t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u<\/h2>\n

Thay v\u00ec s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl + A \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u c\u00f3 trong b\u1ea3ng t\u00ednh th\u00ec qua n\u1ed9i dung n\u00e0y b\u1ea1n s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c th\u00eam m\u1ed9t th\u1ee7 thu\u1eadt Excel ch\u1ecdn t\u1ea5t c\u1ea3 b\u1eb1ng c\u00e1ch b\u1ea5m n\u00fat tam gi\u00e1c “Select all” \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i b\u1ea3ng t\u00ednh, \u0111\u00e2y l\u00e0 m\u1ed9t c\u00e1ch kh\u00e1 nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong m\u1ed9t b\u1ea3ng t\u00ednh.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-1\"<\/picture><\/p>\n

Khi b\u1ea1n nh\u1ea5n v\u00e0o tam gi\u00e1c \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i nh\u01b0 h\u00ecnh minh h\u1ecda d\u01b0\u1edbi \u0111\u00e2y, \u00f4 n\u1eb1m t\u1ea1i g\u00f3c n\u00e0y s\u1ebd tr\u1edf th\u00e0nh m\u1ed9t n\u00fat g\u1ecdi l\u00e0 “Select All” (Ch\u1ecdn t\u1ea5t c\u1ea3). B\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o n\u00fat n\u00e0y, to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh s\u1ebd \u0111\u01b0\u1ee3c ch\u1ecdn bao g\u1ed3m c\u1ea3 c\u00e1c \u00f4 tr\u1ed1ng v\u00e0 \u00f4 c\u00f3 d\u1eef li\u1ec7u. M\u1ed9t l\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y l\u00e0 n\u00f3 kh\u00f4ng y\u00eau c\u1ea7u b\u1ea1n ph\u1ea3i di chuy\u1ec3n chu\u1ed9t ho\u1eb7c s\u1eed d\u1ee5ng b\u00e0n ph\u00edm nhi\u1ec1u. \u0110i\u1ec1u n\u00e0y gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng hi\u1ec7u su\u1ea5t trong vi\u1ec7c l\u00e0m vi\u1ec7c v\u1edbi Excel.<\/span><\/p>\n

Chuy\u1ec3n qua c\u00e1c b\u1ea3ng t\u00ednh Excel kh\u00e1c nhau nhanh h\u01a1n<\/h2>\n

Th\u1ee7 thu\u1eadt Excel s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl + Tab<\/strong> l\u00e0 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh kh\u00e1c nhau. Khi b\u1ea1n nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm n\u00e0y, Excel s\u1ebd chuy\u1ec3n \u0111\u1ed5i ngay l\u1eadp t\u1ee9c \u0111\u1ebfn b\u1ea3ng t\u00ednh ti\u1ebfp theo trong danh s\u00e1ch c\u00e1c b\u1ea3ng t\u00ednh \u0111ang m\u1edf. C\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng ph\u00edm t\u1eaft n\u00e0y r\u1ea5t \u0111\u01a1n gi\u1ea3n, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n v\u00e0 gi\u1eef ph\u00edm Ctrl, sau \u0111\u00f3 nh\u1ea5n li\u00ean t\u1ee5c ph\u00edm Tab \u0111\u1ec3 di chuy\u1ec3n qua c\u00e1c b\u1ea3ng t\u00ednh. Khi b\u1ea1n \u0111\u1ebfn b\u1ea3ng t\u00ednh mong mu\u1ed1n, h\u00e3y th\u1ea3 c\u1ea3 hai ph\u00edm \u0111\u1ec3 ch\u1ecdn n\u00f3.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-2\"<\/picture><\/p>\n

Th\u1ee7 thu\u1eadt Excel t\u1ef1 \u0111\u1ed9ng nh\u1eadp d\u1eef li\u1ec7u<\/h2>\n

M\u1ed9t th\u1ee7 thu\u1eadt Excel b\u1ea1n n\u00ean n\u1eb1m l\u00f2ng ch\u00ednh l\u00e0 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng k\u00e9o v\u00e0 sao ch\u00e9p (Fill Handle), m\u1ed9t c\u00e1ch ti\u1ec7n l\u1ee3i \u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u \u0111\u1ed3ng nh\u1ea5t v\u00e0o c\u00e1c \u00f4 li\u00ean ti\u1ebfp. Vi\u1ec7c b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 c\u1eadp nh\u1eadt d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean trong lo\u1ea1t d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p. Sau \u0111\u00f3, di chu\u1ed9t v\u00e0o g\u00f3c nh\u1ecf b\u00ean ph\u1ea3i c\u1ee7a \u00f4 vu\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u, khi \u0111\u00f3 con tr\u1ecf chu\u1ed9t s\u1ebd thay \u0111\u1ed5i th\u00e0nh bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u “+” ho\u1eb7c bi\u1ec3u t\u01b0\u1ee3ng Fill Handle. Nh\u1ea5n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o xu\u1ed1ng ho\u1eb7c k\u00e9o qua c\u00e1c \u00f4 ti\u1ebfp theo m\u00e0 b\u1ea1n mu\u1ed1n \u0111i\u1ec1n d\u1eef li\u1ec7u. Khi b\u1ea1n k\u00e9o, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c gi\u00e1 tr\u1ecb li\u00ean ti\u1ebfp d\u1ef1a tr\u00ean m\u1eabu d\u1eef li\u1ec7u ban \u0111\u1ea7u.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-3\"<\/picture><\/p>\n

N\u1ebfu c\u00f3 c\u00e1c m\u1eabu ho\u1eb7c quy t\u1eafc trong d\u1eef li\u1ec7u ban \u0111\u1ea7u, Excel s\u1ebd \u00e1p d\u1ee5ng ch\u00fang cho c\u00e1c \u00f4 m\u1edbi. Khi b\u1ea1n \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng c\u1ee7a lo\u1ea1t d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111i\u1ec1n, h\u00e3y nh\u1ea3 chu\u1ed9t \u0111\u1ec3 ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh sao ch\u00e9p. T\u00ednh n\u0103ng k\u00e9o v\u00e0 sao ch\u00e9p c\u0169ng h\u1ed7 tr\u1ee3 cho c\u00e1c lo\u1ea1i d\u1eef li\u1ec7u kh\u00e1c nhau nh\u01b0 ng\u00e0y th\u00e1ng, s\u1ed1, v\u0103n b\u1ea3n v\u00e0 c\u00e1c chu\u1ed7i k\u00fd t\u1ef1. Vi\u1ec7c s\u1eed d\u1ee5ng t\u00ednh n\u0103ng k\u00e9o v\u00e0 sao ch\u00e9p gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 gi\u1ea3m c\u00f4ng s\u1ee9c khi ph\u1ea3i nh\u1eadp d\u1eef li\u1ec7u gi\u1ed1ng nhau v\u00e0o nhi\u1ec1u \u00f4 trong Excel.<\/span><\/p>\n

Nh\u1eadp ng\u00e0y th\u00e1ng c\u1ef1c nhanh b\u1eb1ng th\u1ee7 thu\u1eadt Excel<\/h2>\n

\u0110\u1ec3 nh\u1eadp ng\u00e0y th\u00e1ng nhanh ch\u00f3ng v\u00e0o c\u00e1c \u00f4 trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl + ; (Ctrl + d\u1ea5u ch\u1ea5m ph\u1ea9y). \u0110\u00e2y l\u00e0 m\u1ed9t th\u1ee7 thu\u1eadt Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 r\u1ed9ng r\u00e3i, c\u1ee5 th\u1ec3 b\u1ea1n c\u1ea7n \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean trong c\u1ed9t ng\u00e0y th\u00e1ng m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadp sau \u0111\u00f3 nh\u1ea5n v\u00e0 gi\u1eef ph\u00edm Ctrl tr\u00ean b\u00e0n ph\u00edm. Trong khi gi\u1eef ph\u00edm Ctrl, nh\u1ea5n d\u1ea5u ch\u1ea5m ph\u1ea9y (;) tr\u00ean b\u00e0n ph\u00edm, ngay l\u1eadp t\u1ee9c ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng nh\u1eadp v\u00e0o \u00f4 \u0111\u00f3. Sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u1ea1i c\u00e1ch “T\u1ef1 \u0111\u1ed9ng nh\u1eadp d\u1eef li\u1ec7u” nh\u01b0 ch\u00fang t\u00f4i \u0111\u00e3 n\u00eau trong n\u1ed9i dung tr\u01b0\u1edbc \u0111\u1ec3 \u0111i\u1ec1n ng\u00e0y th\u00e1ng cho c\u00e1c \u00f4 c\u00f2n l\u1ea1i.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-4\"<\/picture><\/p>\n

Ph\u00edm t\u1eaft Ctrl + ; ch\u1ec9 nh\u1eadp ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i v\u00e0 kh\u00f4ng thay \u0111\u1ed5i khi b\u1ea1n m\u1edf l\u1ea1i file Excel sau m\u1ed9t th\u1eddi gian. N\u1ebfu b\u1ea1n mu\u1ed1n nh\u1eadp c\u00e1c ng\u00e0y th\u00e1ng kh\u00e1c nhau, b\u1ea1n c\u1ea7n thay \u0111\u1ed5i th\u1ee7 c\u00f4ng ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c nh\u01b0 c\u00f4ng th\u1ee9c DATE trong Excel.<\/span><\/p>\n

Th\u1ee7 thu\u1eadt Excel t\u1ef1 \u0111\u1ed9ng t\u00ednh t\u1ed5ng<\/h2>\n

Trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Alt + = (Alt + d\u1ea5u b\u1eb1ng) \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh t\u1ef1 \u0111\u1ed9ng t\u00ednh t\u1ed5ng c\u1ee7a m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u. \u0110\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 tr\u1ed1ng d\u01b0\u1edbi c\u00f9ng c\u1ee7a c\u1ed9t d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng sau \u0111\u00f3 nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Alt + =<\/strong> tr\u00ean b\u00e0n ph\u00edm sau \u0111\u00f3 Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u1ecdn d\u1ea3i d\u1eef li\u1ec7u t\u1eeb \u00f4 tr\u00ean c\u00f9ng c\u1ee7a c\u1ed9t \u0111\u1ebfn \u00f4 hi\u1ec7n t\u1ea1i v\u00e0 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 t\u1ed5ng \u1edf \u00f4 \u0111\u00f3. B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n Enter \u0111\u1ec3 x\u00e1c nh\u1eadn k\u1ebft qu\u1ea3 t\u1ed5ng ho\u1eb7c di chuy\u1ec3n \u0111\u1ebfn \u00f4 kh\u00e1c \u0111\u1ec3 t\u00ednh t\u1ed5ng cho m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u kh\u00e1c.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-5\"<\/picture><\/p>\n

Ph\u00edm t\u1eaft Alt + = gi\u00fap t\u00ednh t\u1ed5ng nhanh ch\u00f3ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian so v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m SUM truy\u1ec1n th\u1ed1ng. Tuy nhi\u00ean, l\u01b0u \u00fd r\u1eb1ng ph\u00edm t\u1eaft n\u00e0y ch\u1ec9 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb n\u1eb1m trong c\u00f9ng m\u1ed9t c\u1ed9t v\u00e0 kh\u00f4ng x\u1eed l\u00fd c\u00e1c tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t nh\u01b0 \u00f4 tr\u1ed1ng ho\u1eb7c d\u1eef li\u1ec7u kh\u00f4ng h\u1ee3p l\u1ec7.<\/span><\/p>\n

\u0110\u1ed5i c\u1ed9t th\u00e0nh d\u00f2ng v\u00e0 ng\u01b0\u1ee3c l\u1ea1i<\/h2>\n

\u0110\u1ec3 \u0111\u1ed5i c\u1ed9t th\u00e0nh d\u00f2ng v\u00e0 \u0111\u1ed5i d\u00f2ng th\u00e0nh c\u1ed9t trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Transpose. Th\u1ee7 thu\u1eadt Excel Transpose \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch \u0111\u1ea7u ti\u00ean b\u1ea1n qu\u00e9t ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i bao g\u1ed3m c\u1ea3 ti\u00eau \u0111\u1ec1 v\u00e0 d\u1eef li\u1ec7u sau \u0111\u00f3 nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn “Copy” (Ho\u1eb7c s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl + C) \u0111\u1ec3 sao ch\u00e9p b\u1ea3ng d\u1eef li\u1ec7u. <\/span><\/p>\n

Ti\u1ebfp theo b\u1ea1n ch\u1ecdn m\u1ed9t \u00f4 n\u01a1i b\u1ea1n mu\u1ed1n d\u00e1n b\u1ea3ng d\u1eef li\u1ec7u m\u1edbi v\u00e0 nh\u1ea5n chu\u1ed9t ph\u1ea3i sau \u0111\u00f3 ch\u1ecdn “Paste Special” (Ho\u1eb7c s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl + Alt + V). Trong h\u1ed9p tho\u1ea1i “Paste Special”, \u0111\u00e1nh d\u1ea5u v\u00e0o \u00f4 “Transpose” (ho\u1eb7c “Chuy\u1ec3n v\u1ecb” trong phi\u00ean b\u1ea3n ti\u1ebfng Vi\u1ec7t). Nh\u1ea5n “OK” \u0111\u1ec3 ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh chuy\u1ec3n \u0111\u1ed5i.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-6\"<\/picture><\/p>\n

Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc tr\u00ean, c\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh d\u00f2ng v\u00e0 d\u00f2ng s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh c\u1ed9t. \u0110\u1ed3ng th\u1eddi, ti\u00eau \u0111\u1ec1 c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c x\u1eed l\u00fd theo c\u00e1ch t\u01b0\u01a1ng \u1ee9ng. Tuy nhi\u00ean t\u00ednh n\u0103ng Transpose ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng khi k\u00edch th\u01b0\u1edbc v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng d\u1eef li\u1ec7u m\u1edbi ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u ban \u0111\u1ea7u. H\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng \u00f4 \u0111\u00edch c\u00f3 \u0111\u1ee7 kh\u00f4ng gian \u0111\u1ec3 ch\u1ee9a d\u1eef li\u1ec7u sau khi chuy\u1ec3n \u0111\u1ed5i.<\/span><\/p>\n

C\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t ti\u00eau \u0111\u1ec1<\/h2>\n

\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng ti\u00eau \u0111\u1ec1 ho\u1eb7c c\u1ed9t ti\u00eau \u0111\u1ec1 trong b\u1ea3ng t\u00ednh Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Freeze Panes. Trong \u0111\u00f3:<\/span><\/p>\n

\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng ti\u00eau \u0111\u1ec1, b\u1ea1n ph\u1ea3i \u0111\u1ea3m b\u1ea3o r\u1eb1ng d\u00f2ng ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea1n n\u1eb1m \u1edf h\u00e0ng \u0111\u1ea7u ti\u00ean trong b\u1ea3ng t\u00ednh. B\u1ea1n ch\u1ecdn th\u1ebb “View” tr\u00ean thanh menu, trong \u0111\u00f3 trong nh\u00f3m “Window”, b\u1ea1n s\u1ebd th\u1ea5y n\u00fat “Freeze Panes”. Nh\u1ea5n v\u00e0o m\u0169i t\u00ean b\u00ean c\u1ea1nh n\u00fat \u0111\u00f3, trong danh s\u00e1ch c\u00e1c t\u00f9y ch\u1ecdn, ch\u1ecdn “Freeze Top Row” (C\u1ed1 \u0111\u1ecbnh d\u00f2ng tr\u00ean c\u00f9ng). Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc n\u00e0y, d\u00f2ng ti\u00eau \u0111\u1ec1 s\u1ebd \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh v\u00e0 lu\u00f4n hi\u1ec3n th\u1ecb khi b\u1ea1n cu\u1ed9n xu\u1ed1ng d\u01b0\u1edbi.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-7\"<\/picture><\/p>\n

\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t ti\u00eau \u0111\u1ec1 b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u1ed9t ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea1n n\u1eb1m \u1edf c\u1ed9t \u0111\u1ea7u ti\u00ean trong b\u1ea3ng t\u00ednh. Ch\u1ecdn th\u1ebb “View” tr\u00ean thanh menu, t\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean b\u1ea1n nh\u1ea5n ch\u1ecdn m\u0169i t\u00ean b\u00ean c\u1ea1nh n\u00fat “Freeze Panes” v\u00e0 ch\u1ecdn “Freeze First Column” (C\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean) trong danh s\u00e1ch t\u00f9y ch\u1ecdn. Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc n\u00e0y, c\u1ed9t ti\u00eau \u0111\u1ec1 s\u1ebd \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh v\u00e0 lu\u00f4n hi\u1ec3n th\u1ecb khi b\u1ea1n cu\u1ed9n sang ph\u1ea3i.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-8\"<\/picture><\/p>\n

T\u00ednh n\u0103ng Freeze Panes ch\u1ec9 \u00e1p d\u1ee5ng cho d\u00f2ng ti\u00eau \u0111\u1ec1 \u0111\u1ea7u ti\u00ean ho\u1eb7c c\u1ed9t ti\u00eau \u0111\u1ec1 \u0111\u1ea7u ti\u00ean. N\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh c\u1ea3 d\u00f2ng ti\u00eau \u0111\u1ec1 v\u00e0 c\u1ed9t ti\u00eau \u0111\u1ec1, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t con tr\u1ecf v\u00e0o \u00f4 b\u00ean d\u01b0\u1edbi \u00f4 ti\u00eau \u0111\u1ec1 \u0111\u1ea7u ti\u00ean v\u00e0 sau \u0111\u00f3 \u00e1p d\u1ee5ng t\u00ednh n\u0103ng Freeze Panes.<\/span><\/p>\n

Th\u1ee7 thu\u1eadt Excel sao ch\u00e9p d\u1eef li\u1ec7u nhanh ch\u00f3ng<\/h2>\n

\u0110\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u nhanh ch\u00f3ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft th\u1ee7 thu\u1eadt Excel. \u0110\u1ea7u ti\u00ean b\u1ea1n qu\u00e9t to\u00e0n b\u1ed9 d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p sau \u0111\u00f3 nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + C tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u v\u00e0o Clipboard. K\u1ebf ti\u1ebfp, b\u1ea1n ch\u1ecdn \u00f4 n\u01a1i b\u1ea1n mu\u1ed1n d\u00e1n d\u1eef li\u1ec7u sao ch\u00e9p sau \u0111\u00f3 nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + V tr\u00ean b\u00e0n ph\u00edm \u0111\u1ec3 d\u00e1n d\u1eef li\u1ec7u t\u1eeb Clipboard v\u00e0o \u00f4 \u0111\u00e3 ch\u1ecdn.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-9\"<\/picture><\/p>\n

Sau khi th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c tr\u00ean, d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c sao ch\u00e9p v\u00e0 d\u00e1n v\u00e0o \u00f4 m\u1ee5c ti\u00eau m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. Ph\u00edm t\u1eaft Ctrl + C \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 sao ch\u00e9p (Copy) v\u00e0 ph\u00edm t\u1eaft Ctrl + V \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 d\u00e1n (Paste) trong h\u1ea7u h\u1ebft c\u00e1c \u1ee9ng d\u1ee5ng tr\u00ean m\u00e1y t\u00ednh, kh\u00f4ng ch\u1ec9 ri\u00eang trong Excel. V\u00ec v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y \u0111\u1ec3 sao ch\u00e9p v\u00e0 d\u00e1n d\u1eef li\u1ec7u trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng kh\u00e1c nhau.<\/span><\/p>\n

M\u1edf nhi\u1ec1u b\u1ea3ng t\u00ednh Excel c\u00f9ng l\u00fac<\/h2>\n

B\u1ea1n mu\u1ed1n m\u1edf nhi\u1ec1u b\u1ea3ng t\u00ednh Excel c\u00f9ng m\u1ed9t l\u00fac b\u1eb1ng th\u1ee7 thu\u1eadt Excel? \u0110\u1ec3 m\u1edf nhi\u1ec1u b\u1ea3ng t\u00ednh Excel c\u00f9ng m\u1ed9t l\u00fac, \u0111\u1ea7u ti\u00ean h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng b\u1ea1n \u0111ang \u1edf trong th\u01b0 m\u1ee5c ch\u1ee9a c\u00e1c t\u1ec7p tin Excel m\u00e0 b\u1ea1n mu\u1ed1n m\u1edf. Sau \u0111\u00f3 nh\u1ea5n v\u00e0 gi\u1eef ph\u00edm Ctrl tr\u00ean b\u00e0n ph\u00edm. Trong khi gi\u1eef ph\u00edm Ctrl, nh\u1ea5p chu\u1ed9t tr\u00e1i v\u00e0o c\u00e1c t\u1ec7p tin Excel m\u00e0 b\u1ea1n mu\u1ed1n m\u1edf. B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nhi\u1ec1u t\u1ec7p tin c\u00f9ng m\u1ed9t l\u00fac. C\u00e1c t\u1ec7p tin m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m n\u1ed5i b\u1eadt. Khi b\u1ea1n \u0111\u00e3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c t\u1ec7p tin Excel c\u1ea7n m\u1edf, nh\u1ea5n Enter tr\u00ean b\u00e0n ph\u00edm.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-11\"<\/picture><\/p>\n

Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc tr\u00ean, c\u00e1c t\u1ec7p tin Excel m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c m\u1edf c\u00f9ng m\u1ed9t l\u00fac v\u00e0 hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh. B\u1ea1n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh b\u1eb1ng c\u00e1ch ch\u1ecdn tab t\u01b0\u01a1ng \u1ee9ng v\u1edbi t\u1eebng b\u1ea3ng t\u00ednh. Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y ch\u1ec9 \u00e1p d\u1ee5ng cho vi\u1ec7c m\u1edf nhi\u1ec1u t\u1ec7p tin Excel t\u1eeb c\u00f9ng m\u1ed9t th\u01b0 m\u1ee5c ho\u1eb7c th\u01b0 m\u1ee5c con. N\u1ebfu t\u1ec7p tin Excel n\u1eb1m \u1edf c\u00e1c th\u01b0 m\u1ee5c kh\u00e1c nhau, b\u1ea1n c\u1ea7n \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ebfn t\u1eebng th\u01b0 m\u1ee5c v\u00e0 l\u1eb7p l\u1ea1i quy tr\u00ecnh tr\u00ean.<\/span><\/p>\n

Th\u1ee7 thu\u1eadt Excel Ctrl + ~<\/h2>\n

\u0110\u1ec3 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl + ~ (d\u1ea5u ch\u1ea5m ng\u00e3). \u0110\u1ea7u ti\u00ean b\u1ea1n m\u1edf b\u1ea3ng t\u00ednh Excel ch\u1ee9a c\u00e1c c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb sau \u0111\u00f3 nh\u1ea5n v\u00e0 gi\u1eef ph\u00edm Ctrl tr\u00ean b\u00e0n ph\u00edm. Trong khi gi\u1eef ph\u00edm Ctrl, nh\u1ea5n ph\u00edm ~ (d\u1ea5u ch\u1ea5m ng\u00e3) tr\u00ean b\u00e0n ph\u00edm. C\u00e1c \u00f4 trong b\u1ea3ng t\u00ednh s\u1ebd chuy\u1ec3n sang ch\u1ebf \u0111\u1ed9 hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c. C\u00e1c c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong \u00f4 thay v\u00ec k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n. \u0110\u1ec3 quay l\u1ea1i ch\u1ebf \u0111\u1ed9 hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb k\u1ebft qu\u1ea3, b\u1ea1n ch\u1ec9 c\u1ea7n th\u1ef1c hi\u1ec7n l\u1ea1i ph\u00edm t\u1eaft Ctrl + ~.<\/span><\/p>\n

\"10-thu-thuat-excel-cuc-ky-huu-ich-bat-buoc-phai-nho-10\"<\/picture><\/p>\n

Khi b\u1ea1n s\u1eed d\u1ee5ng ph\u00edm t\u1eaft n\u00e0y, n\u00f3 s\u1ebd gi\u00fap b\u1ea1n ki\u1ec3m tra v\u00e0 xem c\u00e1c c\u00f4ng th\u1ee9c trong b\u1ea3ng t\u00ednh m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. \u0110i\u1ec1u n\u00e0y r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n mu\u1ed1n ki\u1ec3m tra t\u00ednh \u0111\u00fang \u0111\u1eafn c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c ho\u1eb7c x\u00e1c \u0111\u1ecbnh c\u00e1c l\u1ed7i trong c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i ki\u1ec3m tra t\u1eebng \u00f4 m\u1ed9t.<\/span><\/p>\n

T\u1ea1m k\u1ebft<\/b><\/h2>\n

Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd v\u00e0 h\u1eefu d\u1ee5ng nh\u1ea5t \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn trong l\u0129nh v\u1ef1c x\u1eed l\u00fd d\u1eef li\u1ec7u v\u00e0 t\u00ednh to\u00e1n. Tuy nhi\u00ean, nhi\u1ec1u ng\u01b0\u1eddi v\u1eabn ch\u01b0a kh\u00e1m ph\u00e1 h\u1ebft ti\u1ec1m n\u0103ng v\u00e0 c\u00e1c t\u00ednh n\u0103ng h\u1eefu \u00edch m\u00e0 Excel cung c\u1ea5p. V\u1edbi b\u00e0i vi\u1ebft n\u00e0y,<\/span> Ho\u00e0ng H\u00e0 Mobile<\/span><\/a> \u0111\u00e3 gi\u00fap b\u1ea1n kh\u00e1m ph\u00e1 th\u00eam 10 th\u1ee7 thu\u1eadt Excel c\u1ef1c k\u1ef3 h\u1eefu \u00edch. H\u00e3y ghi nh\u1edb ch\u00fang v\u00e0 theo d\u00f5i ch\u00fang t\u00f4i \u0111\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u m\u1eb9o s\u1eed d\u1ee5ng Excel \u0111\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.<\/span><\/p>\n

XEM TH\u00caM:<\/span><\/p>\n