{"id":3951,"date":"2020-03-05T00:00:00","date_gmt":"2020-03-05T00:00:00","guid":{"rendered":"http:\/\/applestore.vn\/cac-to-hop-phim-tat-cuc-huu-dung-trong-excel-n61042\/"},"modified":"2021-12-21T09:36:53","modified_gmt":"2021-12-21T02:36:53","slug":"phim-tat-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/phim-tat-trong-excel\/","title":{"rendered":"69+ Ph\u00edm t\u1eaft trong Excel h\u1eefu d\u1ee5ng nh\u1ea5t m\u00e0 b\u1ea1n n\u00ean bi\u1ebft"},"content":{"rendered":"

V\u1edbi nh\u1eefng ng\u01b0\u1eddi c\u00f3 c\u00f4ng vi\u1ec7c y\u00eau c\u1ea7u ph\u1ea3i s\u1eed d\u1ee5ng Excel<\/strong> h\u00e0ng ng\u00e0y nh\u01b0 k\u1ebf to\u00e1n, th\u1ee7 kho\u2026. th\u00ec vi\u1ec7c ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c m\u1ed9t ch\u00fat th\u1eddi gian x\u1eed l\u00fd c\u00e1c t\u00e1c v\u1ee5 l\u00e0 r\u1ea5t qu\u00fd b\u00e1u. V\u00e0 \u0111\u1ec3 tinh g\u1ecdn \u0111\u01b0\u1ee3c th\u1eddi gian l\u00e0m vi\u1ec7c th\u00ec c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft trong excel l\u00e0 r\u1ea5t quan tr\u1ecdng. <\/strong><\/span><\/p>\n

Tuy nhi\u00ean kh\u00f4ng ph\u1ea3i ai c\u0169ng bi\u1ebft \u0111\u01b0\u1ee3c c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft trong excel h\u1eefu d\u1ee5ng n\u00e0y.<\/em><\/span><\/p>\n

B\u00e0i vi\u1ebft n\u00e0y Bencomputer<\/strong> s\u1ebd t\u1ed5ng h\u1ee3p c\u00e1c ph\u00edm t\u1eaft trong excel c\u1ef1c h\u1eefu d\u1ee5ng \u0111\u1ec3 c\u00e1c b\u1ea1n tham kh\u1ea3o nh\u00e9!<\/span><\/p>\n

\"69+
69+ Ph\u00edm t\u1eaft trong Excel h\u1eefu d\u1ee5ng nh\u1ea5t m\u00e0 b\u1ea1n n\u00ean bi\u1ebft<\/span><\/figcaption><\/figure>\n

Ngo\u00e0i vi\u1ec7c s\u1eed d\u1ee5ng nhi\u1ec1u th\u00e0nh quen v\u00e0 nh\u1edb ho\u1eb7c ghi ch\u00e9p l\u1ea1i c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft trong excel, ch\u00fang ta c\u00f3 th\u00eam m\u1ed9t c\u00e1ch n\u1eefa \u0111\u1ec3 nh\u1edb c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm d\u1ec5 d\u00e0ng h\u01a1n \u0111\u00f3 l\u00e0 ph\u00e2n lo\u1ea1i c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm theo ch\u1ee7 \u0111\u1ec1.<\/span><\/p>\n

Bencomputer s\u1ebd chia c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm theo c\u00e1c \u0111\u1ea7u m\u1ee5c \u0111\u1ec3 c\u00e1c b\u1ea1n d\u1ec5 d\u00e0ng theo d\u00f5i.<\/span><\/p>\n

1. Ph\u00edm t\u1eaft trong Excel k\u1ebft h\u1ee3p v\u1edbi CTRL v\u00e0 ALT<\/strong><\/span><\/h2>\n

a. Ph\u00edm t\u1eaft \u0111i\u1ec1u h\u01b0\u1edbng<\/strong><\/span><\/h3>\n\n\n\n\n\n\n\n\n\n\n
PH\u00cdM T\u1eaeT<\/strong><\/span><\/td>\nC\u00d4NG D\u1ee4NG<\/strong><\/span><\/td>\n<\/tr>\n
ALT + TAB<\/span><\/td>\nChuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh<\/span><\/td>\n<\/tr>\n
CTRL + TAB<\/span><\/td>\nChuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c\u00a0file Excel \u0111ang m\u1edf<\/span><\/td>\n<\/tr>\n
CTRL + PAGE UP<\/span><\/td>\nSang sheet b\u00ean tr\u00e1i<\/span><\/td>\n<\/tr>\n
CTRL + PAGE DOWN<\/span><\/td>\nSang sheet b\u00ean ph\u1ea3i<\/span><\/td>\n<\/tr>\n
HOME<\/span><\/td>\nDi chuy\u1ec3n v\u1ec1 \u0111\u1ea7u d\u00f2ng<\/span><\/td>\n<\/tr>\n
CTRL + HOME<\/span><\/td>\nDi chuy\u1ec3n v\u1ec1 d\u00f2ng v\u00e0 c\u1ed9t \u0111\u1ea7u ti\u00ean trong sheet<\/span><\/td>\n<\/tr>\n
CTRL + END<\/span><\/td>\nDi chuy\u1ec3n v\u1ec1 d\u00f2ng v\u00e0 c\u1ed9t cu\u1ed1i c\u00f9ng trong sheet<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

b. C\u00e1c ph\u00edm t\u1eaft thao t\u00e1c<\/strong><\/span><\/h3>\n\n\n\n\n\n\n\n\n\n
CTRL + N<\/span><\/td>\nT\u1ea1o file m\u1edbi<\/span><\/td>\n<\/tr>\n
CTRL + O<\/span><\/td>\nM\u1edf file \u0111\u00e3 l\u01b0u<\/span><\/td>\n<\/tr>\n
CTRL + P<\/span><\/td>\nIn<\/span><\/td>\n<\/tr>\n
CTRL + S<\/span><\/td>\nL\u01b0u trang<\/span><\/td>\n<\/tr>\n
CTRL + W<\/span><\/td>\n\u0110\u00f3ng trang hi\u1ec7n t\u1ea1i<\/span><\/td>\n<\/tr>\n
ALT + =<\/span><\/td>\nS\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Auto Sum<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + A<\/span><\/td>\nCh\u00e8n d\u1ea5u ( ) v\u00e0 c\u00e1c \u0111\u1ed1i s\u1ed1 sau khi nh\u1eadp t\u00ean h\u00e0m<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

R\u1ea5t \u0111\u01a1n gi\u1ea3n nh\u01b0ng l\u1ea1i d\u1ec5 nh\u1ea7m, c\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1edb theo c\u00e1c k\u00ed t\u1ef1 ch\u1eef v\u00e0 t\u1ef1 \u0111\u1ed9ng \u0111\u00ednh th\u00eam n\u00fat tr\u1ee3 n\u0103ng Ctrl l\u00e0 \u0111\u01b0\u1ee3c.<\/span><\/p>\n

c. C\u00e1c ph\u00edm ch\u1ee9c n\u0103ng t\u1eaft<\/strong><\/span><\/h3>\n\n\n\n\n\n\n
F2<\/span><\/td>\nHi\u1ec7u ch\u1ec9nh d\u1eef li\u1ec7u trong \u00f4<\/span><\/td>\n<\/tr>\n
F3<\/span><\/td>\nD\u00e1n m\u1ed9t t\u00ean \u0111\u00e3 \u0111\u1eb7t trong c\u00f4ng th\u1ee9c<\/span><\/td>\n<\/tr>\n
F4 ho\u1eb7c CTRL + Y<\/span><\/td>\nL\u1eb7p l\u1ea1i thao t\u00e1c v\u1eeba th\u1ef1c hi\u1ec7n<\/span><\/td>\n<\/tr>\n
F5<\/span><\/td>\n\u0110i \u0111\u1ebfn v\u1ecb tr\u00ed x\u00e1c \u0111\u1ecbnh theo tham chi\u1ebfu<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

C\u00e1c ph\u00edm ch\u1ee9c n\u0103ng c\u00f3 s\u1eb5n kh\u00f4ng c\u1ea7n k\u1ebft h\u1ee3p v\u1edbi ph\u00edm ph\u1ee5 tr\u1ee3 n\u00e0o kh\u00e1c. Kh\u00e1 d\u1ec5 nh\u1edb ch\u1ec9 c\u1ea7n l\u00e0m v\u00e0i l\u1ea7n l\u00e0 quen.<\/span><\/p>\n

d. Ph\u00edm t\u1eaft sao ch\u00e9p<\/strong><\/span><\/h3>\n\n\n\n\n\n\n\n\n\n\n
CTRL + C<\/span><\/td>\nSao ch\u00e9p<\/span><\/td>\n<\/tr>\n
CTRL + D<\/span><\/td>\nCh\u00e9p gi\u00e1 tr\u1ecb t\u1eeb \u00f4 \u1edf tr\u00ean \u00f4 hi\u1ec7n h\u00e0nh v\u00e0o \u00f4 hi\u1ec7n h\u00e0nh<\/span><\/td>\n<\/tr>\n
CTRL + R<\/span><\/td>\nCh\u00e9p d\u1eef li\u1ec7u t\u1eeb b\u00ean tr\u00e1i qua ph\u1ea3i<\/span><\/td>\n<\/tr>\n
CTRL + V<\/span><\/td>\nD\u00e1n<\/span><\/td>\n<\/tr>\n
CTRL + X<\/span><\/td>\nC\u1eaft<\/span><\/td>\n<\/tr>\n
CTRL + Z<\/span><\/td>\nQuay l\u1ea1i thao t\u00e1c v\u1eeba th\u1ef1c hi\u1ec7n<\/span><\/td>\n<\/tr>\n
CTRL + DELETE<\/span><\/td>\nXo\u00e1 t\u1ea5t c\u1ea3 ch\u1eef trong m\u1ed9t d\u00f2ng<\/span><\/td>\n<\/tr>\n
ALT + ENTER<\/span><\/td>\nXu\u1ed1ng d\u00f2ng trong \u00f4<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

C\u00e1c t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft n\u00e0y r\u1ea5t quan tr\u1ecdng trong vi\u1ec7c thao t\u00e1c trong excel v\u00e0 c\u1ea7n ph\u1ea3i l\u01b0u \u00fd nhi\u1ec1u h\u01a1n \u0111\u1ec3 ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian t\u1ed1i \u01b0u.<\/span><\/p>\n

e. Ph\u00edm t\u1eaft \u0111\u1ecbnh d\u1ea1ng<\/strong><\/span><\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
CTRL + \u2013<\/span><\/td>\nX\u00f3a d\u00f2ng, c\u1ed9t<\/span><\/td>\n<\/tr>\n
CTRL + ;<\/span><\/td>\nC\u1eadp nh\u1eadt ng\u00e0y th\u00e1ng<\/span><\/td>\n<\/tr>\n
CTRL + 0<\/span><\/td>\n\u1ea8n c\u00e1c c\u1ed9t \u0111ang ch\u1ecdn<\/span><\/td>\n<\/tr>\n
CTRL + 1<\/span><\/td>\nG\u1ecdi h\u1ed9p tho\u1ea1i Format Cells<\/span><\/td>\n<\/tr>\n
CTRL+ 5<\/span><\/td>\nB\u1eadt \/ t\u1eaft ch\u1ebf \u0111\u1ed9 g\u1ea1ch gi\u1eefa kh\u00f4ng g\u1ea1ch gi\u1eefa<\/span><\/td>\n<\/tr>\n
CTRL + 9<\/span><\/td>\n\u1ea8n c\u00e1c d\u00f2ng \u0111ang ch\u1ecdn<\/span><\/td>\n<\/tr>\n
CTRL + B<\/span><\/td>\nB\u1eadt \/ t\u1eaft in \u0111\u1eadm<\/span><\/td>\n<\/tr>\n
CTRL + I<\/span><\/td>\nB\u1eadt \/ t\u1eaft in nghi\u00eang<\/span><\/td>\n<\/tr>\n
CTRL + U<\/span><\/td>\nB\u1eadt\/t\u1eaft g\u1ea1ch ch\u00e2n<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + \u2013<\/span><\/td>\nX\u00f3a \u0111\u01b0\u1eddng vi\u1ec1n (Border) cho c\u00e1c \u00f4 \u0111ang ch\u1ecdn<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + #<\/span><\/td>\n\u0110\u1ecbnh d\u1ea1ng ki\u1ec3u Data cho ng\u00e0y, th\u00e1ng, n\u0103m<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + $<\/span><\/td>\n\u0110\u1ecbnh d\u1ea1ng s\u1ed1 ki\u1ec3u Curency v\u1edbi hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + %<\/span><\/td>\n\u0110\u1ecbnh d\u1ea1ng s\u1ed1 ki\u1ec3u Percentage (kh\u00f4ng c\u00f3 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n)<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + &<\/span><\/td>\nTh\u00eam \u0111\u01b0\u1eddng vi\u1ec1n ngo\u00e0i<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + (<\/span><\/td>\nHi\u1ec3n th\u1ecb d\u00f2ng \u1ea9n<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + :<\/span><\/td>\nNh\u1eadp th\u1eddi gian<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + ?<\/span><\/td>\n\u0110\u1ecbnh d\u1ea1ng ki\u1ec3u Numer v\u1edbi hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + ^<\/span><\/td>\n\u0110\u1ecbnh d\u1ea1ng s\u1ed1 ki\u1ec3u Exponential v\u1edbi hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + ~<\/span><\/td>\n\u0110\u1ecbnh d\u1ea1ng s\u1ed1 ki\u1ec3u General<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + \u201d<\/span><\/td>\nCh\u00e9p gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 ph\u00eda tr\u00ean v\u00e0o v\u1ecb tr\u00ed con tr\u1ecf c\u1ee7a \u00f4 hi\u1ec7n h\u00e0nh<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + =<\/span><\/td>\nCh\u00e8n \u00f4 tr\u1ed1ng ho\u1eb7c d\u00f2ng tr\u1ed1ng<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + 0<\/span><\/td>\nHi\u1ec7n c\u00e1c c\u1ed9t \u0111ang ch\u1ecdn<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + 5<\/span><\/td>\n\u0110\u1ecbnh d\u1ea1ng format l\u00e0 ph\u1ea7n tr\u0103m<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + 9<\/span><\/td>\nHi\u1ec7n c\u00e1c d\u00f2ng \u0111ang ch\u1ecdn<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

C\u00e1c t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft n\u00e0y t\u01b0\u01a1ng \u0111\u1ed1i ph\u1ee9c t\u1ea1p v\u00e0 ph\u1ea3i s\u1eed d\u1ee5ng k\u00e9p nhi\u1ec1u ph\u00edm tr\u1ee3 n\u0103ng. M\u1eb7c d\u00f9 h\u01a1i kh\u00f3 nh\u1edb m\u1ed9t ch\u00fat nh\u01b0ng l\u1ea1i c\u1ef1c k\u00ec h\u1eefu d\u1ee5ng, ch\u1ec9 c\u1ea7n thu\u1ed9c n\u1eb1m l\u00f2ng c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm n\u00e0y, b\u1ea1n d\u1ec5 d\u00e0ng tr\u1edf th\u00e0nh \u201ccao th\u1ee7 excel\u201d trong th\u1eddi gian ng\u1eafn.<\/span><\/p>\n

f. Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u<\/strong><\/span><\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
ALT + DOWN ARROW<\/span><\/td>\nHi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t hi\u1ec7n h\u00e0nh<\/span><\/td>\n<\/tr>\n
CTRL + ARROW<\/span><\/td>\nDi chuy\u1ec3n \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u tr\u01b0\u1edbc \u00f4 tr\u1ed1ng<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + END<\/span><\/td>\nM\u1edf r\u1ed9ng v\u00f9ng ch\u1ecdn \u0111\u1ebfn \u00f4 c\u00f3 s\u1eed d\u1ee5ng cu\u1ed1i c\u00f9ng<\/span><\/td>\n<\/tr>\n
CTRL + SHIFT + HOME<\/span><\/td>\nM\u1edf r\u1ed9ng v\u00f9ng ch\u1ecdn v\u1ec1 \u0111\u1ea7u worksheet<\/span><\/td>\n<\/tr>\n
CTRL + SPACEBAR<\/span><\/td>\nCh\u1ecdn c\u1ea3 c\u1ed9t<\/span><\/td>\n<\/tr>\n
CTRL + \u2019<\/span><\/td>\nCh\u00e9p gi\u00e1 tr\u1ecb \u00f4 ph\u00eda tr\u00ean v\u00e0o v\u1ecb tr\u00ed con tr\u1ecf c\u1ee7a \u00f4 hi\u1ec7n h\u00e0nh<\/span><\/td>\n<\/tr>\n
CTRL + K<\/span><\/td>\nCh\u00e8n m\u1ed9t Hyperlink<\/span><\/td>\n<\/tr>\n
ESC<\/span><\/td>\nB\u1ecf qua d\u1eef li\u1ec7u \u0111ang thay \u0111\u1ed5i<\/span><\/td>\n<\/tr>\n
SHIFT + ARROW<\/span><\/td>\nCh\u1ecdn v\u00f9ng<\/span><\/td>\n<\/tr>\n
SHIFT + ENTER<\/span><\/td>\nGhi d\u1eef li\u1ec7u v\u00e0o \u00f4 v\u00e0 di chuy\u1ec3n l\u00ean tr\u00ean trong v\u00f9ng ch\u1ecdn<\/span><\/td>\n<\/tr>\n
SHIFT + HOME<\/span><\/td>\nM\u1edf r\u1ed9ng v\u00f9ng ch\u1ecdn v\u1ec1 d\u00f2ng \u0111\u1ea7u ti\u00ean<\/span><\/td>\n<\/tr>\n
SHIFT + PAGE DOWN<\/span><\/td>\nM\u1edf r\u1ed9ng v\u00f9ng ch\u1ecdn xu\u1ed1ng m\u1ed9t m\u00e0n h\u00ecnh<\/span><\/td>\n<\/tr>\n
SHIFT + PAGE UP<\/span><\/td>\nM\u1edf r\u1ed9ng v\u00f9ng ch\u1ecdn l\u00ean m\u1ed9t m\u00e0n h\u00ecnh<\/span><\/td>\n<\/tr>\n
SHIFT + SPACEBAR<\/span><\/td>\nCh\u1ecdn c\u1ea3 d\u00f2ng<\/span><\/td>\n<\/tr>\n
SHIFT + F2<\/span><\/td>\nCh\u00e8n comment<\/span><\/td>\n<\/tr>\n
SHIFT + TAB<\/span><\/td>\nGhi d\u1eef li\u1ec7u v\u00e0o \u00f4 v\u00e0o di chuy\u1ec3n qua tr\u00e1i v\u00f9ng ch\u1ecdn<\/span><\/td>\n<\/tr>\n
TAB<\/span><\/td>\nGhi d\u1eef li\u1ec7u v\u00e0o \u00f4 v\u00e0o di chuy\u1ec3n qua ph\u1ea3i v\u00f9ng ch\u1ecdn<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

T\u01b0\u01a1ng t\u1ef1 nh\u01b0 m\u1ee5c tr\u00ean, ph\u1ea7n n\u00e0y g\u1ed3m c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm c\u00f3 c\u00f4ng d\u1ee5ng quen thu\u1ed9c v\u00e0 r\u1ea5t hay s\u1eed d\u1ee5ng. N\u1ebfu c\u00f3 th\u1ec3 h\u00e3y c\u1ed1 g\u1eafng luy\u1ec7n t\u1eadp h\u00e0ng ng\u00e0y \u0111\u1ec3 chanh ch\u00f3ng nhu\u1ea7n nhuy\u1ec5n c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm n\u00e0y h\u01a1n.<\/span><\/p>\n

2. C\u00e1c ph\u00edm t\u1eaft k\u1ebft h\u1ee3p ph\u00edm tr\u1ee3 n\u0103ng Alt v\u00e0 c\u00e1c ch\u1eef g\u1ea1ch d\u01b0\u1edbi c\u1ee7a menu<\/strong><\/span><\/h2>\n

T\u1ed5 h\u1ee3p c\u00e1c ph\u00edm t\u1eaft h\u1eefu d\u1ee5ng trong excel \u0111\u01b0\u1ee3c b\u1ea3o l\u01b0u t\u1eeb c\u00e1c phi\u00ean b\u1ea3n c\u0169 nh\u1ea5t cho \u0111\u1ebfn nay, kh\u00e1c \u0111\u00f4i ch\u00fat so v\u1edbi word sau c\u00e1c phi\u00ean b\u1ea3n, \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 thu\u1eadn ti\u1ec7n s\u1eed d\u1ee5ng m\u00e0 kh\u00f4ng m\u1ea5t th\u1eddi gian t\u00ecm hi\u1ec3u v\u00e0 l\u00e0m quen l\u1ea1i.<\/span><\/p>\n

Nguy\u00ean t\u1eafc chung c\u1ee7a m\u1ee5c 2 n\u00e0y l\u00e0 thao t\u00e1c g\u1ed3m ph\u00edm Alt v\u00e0 c\u00e1c k\u00fd t\u1ef1 g\u1ea1ch d\u01b0\u1edbi trong menu c\u1ee7a Excel 2003 (tham kh\u1ea3o \u1ea3nh b\u00ean d\u01b0\u1edbi).<\/span><\/p>\n

L\u01b0u \u00fd: ch\u1ec9 c\u1ea7n nh\u1ea5n Alt 1 l\u1ea7n, kh\u00f4ng c\u1ea7n nh\u1ea5n gi\u1eef.<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
ALT + D P<\/span><\/td>\nInsert \/ PivotTable<\/span><\/td>\n<\/tr>\n
ALT + A E<\/span><\/td>\nData \/ Text to Column<\/span><\/td>\n<\/tr>\n
ALT + D B<\/span><\/td>\nData \/ Subtotal<\/span><\/td>\n<\/tr>\n
ALT + O H U<\/span><\/td>\nHi\u1ec7n sheet \u0111\u00e3 \u1ea9n<\/span><\/td>\n<\/tr>\n
ALT + O H H<\/span><\/td>\n\u1ea8n sheet<\/span><\/td>\n<\/tr>\n
ALT + O C A<\/span><\/td>\nT\u1ef1 canh ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ed9t<\/span><\/td>\n<\/tr>\n
ALT + E S<\/span><\/td>\nD\u00e1n Special<\/span><\/td>\n<\/tr>\n
ALT + D F F<\/span><\/td>\nData \/ Filter<\/span><\/td>\n<\/tr>\n
ALT + W F + ENTER<\/span><\/td>\nView\u00a0\/\u00a0Freeze ho\u1eb7c Unfreeze Panes<\/span><\/td>\n<\/tr>\n
ALT + W S<\/span><\/td>\nView\u00a0\/\u00a0Split<\/span><\/td>\n<\/tr>\n
ALT + N + (Type of chart)<\/span><\/td>\nCh\u00e8n bi\u1ec3u \u0111\u1ed3<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

C\u00f3 v\u1ebb h\u01a1i nhi\u1ec1u k\u00ed t\u1ef1 ph\u1ea3i nh\u1edb, nh\u01b0ng \u201ctr\u0103m hay kh\u00f4ng b\u1eb1ng tay quen\u201d<\/strong>, ch\u1ec9 c\u1ea7n ch\u0103m ch\u1ec9 luy\u1ec7n t\u1eadp v\u00e0 s\u1eed d\u1ee5ng h\u00e0ng ng\u00e0y th\u00ec c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm h\u1eefu d\u1ee5ng trong excel n\u00e0y s\u1ebd kh\u00f4ng th\u1ec3 l\u00e0m kh\u00f3 b\u1ea1n.<\/span><\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft trong Excel h\u1eefu d\u1ee5ng<\/strong> m\u00e0 Bencomputer \u0111\u00e3 t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n lo\u1ea1i theo t\u1eebng \u0111\u1ec1 m\u1ee5c \u0111\u1ec3 b\u1ea1n d\u1ec5 d\u00e0ng h\u1ecdc thu\u1ed9c v\u00e0 s\u1eed d\u1ee5ng h\u01a1n.<\/span><\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/em><\/span><\/p>\n

Tham kh\u1ea3o th\u00eam:<\/p>\n