{"id":7564,"date":"2024-12-21T17:58:39","date_gmt":"2024-12-21T17:58:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/thu-thuat-nhap-nhanh-1-du-lieu-hoac-1-cong-thuc-vao-tat-ca-cac-o-tinh-duoc-chon-tren-excel\/"},"modified":"2024-12-21T17:58:39","modified_gmt":"2024-12-21T17:58:39","slug":"thu-thuat-nhap-nhanh-1-du-lieu-hoac-1-cong-thuc-vao-tat-ca-cac-o-tinh-duoc-chon-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/thu-thuat-nhap-nhanh-1-du-lieu-hoac-1-cong-thuc-vao-tat-ca-cac-o-tinh-duoc-chon-tren-excel\/","title":{"rendered":"Th\u1ee7 thu\u1eadt nh\u1eadp nhanh 1 d\u1eef li\u1ec7u ho\u1eb7c 1 c\u00f4ng th\u1ee9c v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 t\u00ednh \u0111\u01b0\u1ee3c ch\u1ecdn tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn 2 m\u1eb9o nhanh \u0111\u1ec3 nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c ho\u1eb7c v\u0103n b\u1ea3n v\u00e0o m\u1ed9t s\u1ed1 \u00f4 trong Excel c\u00f9ng m\u1ed9t l\u00fac. N\u00f3 r\u1ea5t h\u1eefu \u00edch n\u1ebfu b\u1ea1n c\u1ea7n ch\u00e8n c\u00f4ng th\u1ee9c v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong m\u1ed9t c\u1ed9t ho\u1eb7c \u0111i\u1ec1n v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u1ed1ng trong m\u1ed9t b\u1ea3ng c\u00f3 c\u00f9ng gi\u00e1 tr\u1ecb (v\u00ed d\u1ee5: \u201cN\/A\u201d). C\u1ea3 hai th\u1ee7 thu\u1eadt \u0111\u1ec1u ho\u1ea1t \u0111\u1ed9ng trong Microsoft Excel 2016, 2013, 2010, 2007 v\u00e0 th\u1ea5p h\u01a1n. Bi\u1ebft nh\u1eefng \u0111i\u1ec1u \u0111\u01a1n gi\u1ea3n n\u00e0y s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m r\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 d\u00f9ng cho nh\u1eefng \u0111i\u1ec1u th\u00fa v\u1ecb h\u01a1n.<\/p>\n<p style=\"text-align: justify\"><strong>Xem th\u00eam ki\u1ebfn th\u1ee9c li\u00ean quan:<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2007\">Ho\u0323c excel 2007 c\u01a1 ba\u0309n<\/a><\/li>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">H\u1ecdc excel 2010<\/a><\/li>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2013\">H\u1ecdc excel 2013<\/a><\/li>\n<li style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2016\">H\u1ecdc excel 2016<\/a><\/li>\n<\/ul>\n<p><strong>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadp c\u00f9ng m\u1ed9t d\u1eef li\u1ec7u<\/strong><\/p>\n<p style=\"text-align: justify\">Sau \u0111\u00e2y l\u00e0 c\u00e1ch nhanh nh\u1ea5t b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn \u00f4:<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t<\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n n\u1eb1m trong b\u1ea3ng Excel \u0111\u1ea7y \u0111\u1ee7, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong c\u1ed9t v\u00e0 nh\u1ea5n <strong>Ctrl + Space<\/strong>.<\/li>\n<li>N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t d\u00e3y d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n (khi b\u1ea1n nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o c\u00f3 d\u1eef li\u1ec7u, b\u1ea1n kh\u00f4ng th\u1ea5y tab \u201c<strong>Tabe Tools<\/strong>\u201d \u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i):<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5787\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-67.png\" width=\"600\" height=\"138\" title=\"excel-dialog-box-launcher-1-67\"><br \/>\n<strong>L\u01b0u \u00fd<\/strong>: Ch\u1ec9 c\u1ea7n nh\u1ea5n <strong>Ctrl + Space<\/strong> s\u1ebd ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong c\u1ed9t, t\u1ee9c l\u00e0 t\u1eeb C1 \u0111\u1ebfn C1048576, ngay c\u1ea3 khi ch\u1ec9 nh\u1eefng \u00f4 C1-C100 ch\u1ee9a d\u1eef li\u1ec7u.<br \/>\n\u0110\u1eb7t con tr\u1ecf v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean trong c\u1ed9t (ho\u1eb7c \u00f4 th\u1ee9 hai n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1), sau \u0111\u00f3 nh\u1ea5n <strong>Shift + Ctrl + End<\/strong> \u0111\u1ec3 \u0111i \u0111\u1ebfn cu\u1ed1i b\u1ea3ng, gi\u1eef ph\u00edm <strong>Shift<\/strong> v\u00e0 nh\u1ea5n ph\u00edm tr\u00e1i nhi\u1ec1u l\u1ea7n cho \u0111\u1ebfn khi ch\u1ec9 c\u00f2n c\u1ed9t c\u1ea7n \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong c\u1ed9t, \u0111\u1eb7c bi\u1ec7t n\u1ebfu c\u1ed9t ch\u1ee9a m\u1ed9t s\u1ed1 \u00f4 tr\u1ed1ng gi\u1eefa d\u1eef li\u1ec7u.<\/p>\n<p><strong>Ch\u1ecdn to\u00e0n b\u1ed9 h\u00e0ng<\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-305.gif\" title=\"vba101_92019-nho-305\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-678.gif\" title=\"ex101_92019-nho-678\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n n\u1eb1m trong b\u1ea3ng Excel \u0111\u1ea7y \u0111\u1ee7, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong h\u00e0ng v\u00e0 nh\u1ea5n <strong>Shift + Space<\/strong>.<\/li>\n<li>N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n, h\u00e3y nh\u1ea5p v\u00e0o \u00f4 cu\u1ed1i c\u00f9ng trong h\u00e0ng, sau \u0111\u00f3 nh\u1ea5n <strong>Ctrl + Home<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>Ch\u1ecdn m\u1ed9t s\u1ed1 \u00f4<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1eef <strong>Ctrl<\/strong> v\u00e0 nh\u1ea5p chu\u1ed9t tr\u00e1i v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111i\u1ec1n d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng<\/strong><\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng c\u1ee7a b\u1ea1n v\u00e0 sau \u0111\u00f3 nh\u1ea5n <strong>Ctrl + A<\/strong>.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong m\u1ed9t b\u1ea3ng t\u00ednh<\/strong><br \/>\nNh\u1ea5n <strong>Ctrl + A<\/strong>, sau \u0111\u00f3 nh\u1ea5n <strong>Ctrl + A <\/strong>l\u1ea7n n\u1eefa.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u1ecdn \u00f4 tr\u1ed1ng trong m\u1ed9t khu v\u1ef1c nh\u1ea5t \u0111\u1ecbnh (h\u00e0ng, c\u1ed9t, b\u1ea3ng)<\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn khu v\u1ef1c b\u1ea1n c\u1ea7n (xem b\u00ean d\u01b0\u1edbi), v\u00ed d\u1ee5: To\u00e0n b\u1ed9 c\u1ed9t.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-select-whole-column-1.png\" alt=\"Select the column that contains blank cells\" title=\"excel-select-whole-column-1\"><\/p>\n<p style=\"text-align: justify\">Nh\u1ea5n <strong>F5<\/strong> \u0111\u1ec3 t\u1edbi h\u1ed9p tho\u1ea1i <strong>\u201cGo To\u201d\u00a0<\/strong>v\u00e0 ch\u1ecdn <strong>Special\u2026<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-goto-special.png\" alt=\"Click the Special button in the Go To dialog\" title=\"excel-goto-special\"><\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn <strong>Blanks <\/strong>trong<strong> Go To special\u00a0<\/strong>v\u00e0 nh\u1ea5p Ok.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-select-blank-cells.png\" alt=\"Select the Blanks radio button in the 'Go To special' window\" title=\"excel-select-blank-cells\"><\/p>\n<p style=\"text-align: justify\">Khi quay l\u1ea1i Excel b\u1ea1n s\u1ebd th\u1ea5y r\u1eb1ng ch\u1ec9 c\u00e1c \u00f4 tr\u1ed1ng trong v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u. S\u1ebd nhanh h\u01a1n n\u1ebfu ch\u1ecdn 3 \u00f4 tr\u1ed1ng b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o ch\u00fang b\u1eb1ng con tr\u1ecf chu\u1ed9t c\u1ee7a b\u1ea1n. Nh\u01b0ng c\u00e1ch n\u00e0y hi\u1ec7u qu\u1ea3 n\u1ebfu b\u1ea1n c\u00f3 h\u01a1n 300 kho\u1ea3ng tr\u1eafng ph\u00e2n b\u1ed1 ng\u1eabu nhi\u00ean gi\u1eefa 10000 \u00f4.<\/p>\n<p style=\"text-align: justify\"><strong> C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 ch\u00e8n m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o to\u00e0n b\u1ed9 c\u1ed9t<\/strong><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng l\u1edbn v\u00e0 b\u1ea1n mu\u1ed1n th\u00eam m\u1ed9t c\u1ed9t m\u1edbi v\u1edbi m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch c\u00e1c li\u00ean k\u1ebft v\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t c\u00e1c t\u00ean mi\u1ec1n t\u1eeb c\u00e1c li\u00ean k\u1ebft n\u00e0y cho nh\u1eefng c\u00f4ng vi\u1ec7c kh\u00e1c.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-range-urls.png\" alt=\"Extract a part of a value using formulas in the next column\" title=\"excel-range-urls\"><\/p>\n<p style=\"text-align: justify\">1. Chuy\u1ec3n \u0111\u1ed5i v\u00f9ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n th\u00e0nh m\u1ed9t b\u1ea3ng Excel. Ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong d\u1ea3i d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n v\u00e0 nh\u1ea5n <strong>Ctrl + T<\/strong> \u0111\u1ec3 xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i \u201c<strong>Create Table\u201d<\/strong>\u00a0(nh\u1ea5p\u00a0<strong>Ctrl + L<\/strong> trong Excel 2003). N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 ti\u00eau \u0111\u1ec1 c\u1ed9t, h\u00e3y \u0111\u1ea3m b\u1ea3o \u0111\u00e3 ch\u1ecdn \u00f4\u00a0<strong>\u201cMy table has headers\u201d<\/strong>. Th\u00f4ng th\u01b0\u1eddng Excel nh\u1eadn di\u1ec7n c\u00e1c ti\u00eau \u0111\u1ec1 b\u1ea3ng c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng, n\u1ebfu kh\u00f4ng, h\u00e3y ch\u1ecdn \u00f4 n\u00e0y theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-create-table.png\" alt=\"Make sure your table headers are identified\" title=\"excel-create-table\"><\/p>\n<p style=\"text-align: justify\">2. Ch\u00e8n m\u1ed9t c\u1ed9t m\u1edbi v\u00e0o b\u1ea3ng c\u1ee7a b\u1ea1n. Vi\u1ec7c th\u00eam m\u1ed9t c\u1ed9t m\u1edbi v\u00e0o m\u1ed9t b\u1ea3ng d\u1ec5 h\u01a1n nhi\u1ec1u so v\u1edbi th\u00eam v\u00e0o m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n. Ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong c\u1ed9t b\u00ean c\u1ea1nh n\u01a1i b\u1ea1n mu\u1ed1n th\u00eam c\u1ed9t m\u1edbi v\u00e0 ch\u1ecdn <strong>Insert&gt; Table Column to the Right <\/strong>(th\u00eam b\u00ean ph\u1ea3i)\u00a0(ho\u1eb7c \u201c<strong>Table column to the left<\/strong>\u201c).<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-insert-column-to-table.png\" alt=\"It is easy to insert a table column\" title=\"excel-insert-column-to-table\"><\/p>\n<p style=\"text-align: justify\">3. \u0110\u1eb7t t\u00ean cho c\u1ed9t m\u1edbi th\u00eam v\u00e0o.<br \/>\n4. Nh\u1eadp c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t m\u1edbi. T\u00f4i s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u1ec3 tr\u00edch xu\u1ea5t c\u00e1c t\u00ean mi\u1ec1n trong v\u00ed d\u1ee5 c\u1ee7a t\u00f4i: <strong>= MID (c2, FIND (\u201c:\u201d, c2, \u201c4\u201d) + 3, FIND (\u201c\/\u201d, c2,9) -FIND (\u201c: \u201c, C2,\u201d 4 \u201c) \u2013 3).<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5789 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-68.png\" width=\"600\" height=\"128\" title=\"excel-dialog-box-launcher-1-68\"><\/p>\n<p style=\"text-align: justify\">5. Nh\u1ea5n <strong>Enter.\u00a0<\/strong>Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n t\u1ea5t c\u1ea3 nh\u1eefng \u00f4 tr\u1ed1ng trong c\u1ed9t c\u1ee7a b\u1ea1n v\u1edbi c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5790 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-69.png\" width=\"600\" height=\"318\" title=\"excel-dialog-box-launcher-1-69\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n chuy\u1ec3n l\u1ea1i b\u1ea3ng c\u00f3 v\u00f9ng d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n v\u00ec m\u1ed9t l\u00fd do n\u00e0o \u0111\u00f3, h\u00e3y ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong b\u1ea3ng c\u1ee7a b\u1ea1n, sau \u0111\u00f3 nh\u1ea5n n\u00fat \u201c<strong>Convert to Range<\/strong>\u201d tr\u00ean tab <strong>Design<\/strong>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5792\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-70.png\" width=\"600\" height=\"144\" title=\"excel-dialog-box-launcher-1-70\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng m\u1eb9o n\u00e0y ch\u1ec9 khi t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong c\u1ed9t tr\u1ed1ng, v\u00ec v\u1eady c\u00e1ch t\u1ed1t nh\u1ea5t l\u00e0 th\u00eam c\u00e1c c\u1ed9t m\u1edbi.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00e8n c\u00f9ng m\u1ed9t d\u1eef li\u1ec7u v\u00e0o nhi\u1ec1u \u00f4 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Ctrl + Enter<\/strong><\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111i\u1ec1n v\u00e0o c\u00f9ng m\u1ed9t d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n. Vui l\u00f2ng xem c\u00e1c m\u1eb9o \u1edf tr\u00ean \u0111\u1ec3 nhanh ch\u00f3ng l\u1ef1a ch\u1ecdn d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed ta c\u00f3 m\u1ed9t b\u1ea3ng danh s\u00e1ch kh\u00e1ch h\u00e0ng. C\u00f3 m\u1ed9t c\u1ed9t li\u1ec7t k\u00ea c\u00e1c trang web d\u1eabn kh\u00e1ch h\u00e0ng \u0111\u1ebfn ch\u00fang t\u00f4i. Ch\u00fang t\u00f4i mu\u1ed1n l\u1ea5p \u0111\u1ea7y c\u00e1c \u00f4 tr\u1ed1ng b\u1eb1ng \u201c_unknown_\u201d \u0111\u1ec3 l\u00e0m cho vi\u1ec7c l\u1ecdc tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n trong t\u01b0\u01a1ng lai:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/clients-list.png\" alt=\"We want to enter Unknown into blank cells\" title=\"clients-list\"><\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn t\u1ea5t c\u1ea3 \u00f4 tr\u1ed1ng trong c\u1ed9t<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-blanks.png\" alt=\"Quickly select all blanks in a column\" title=\"select-blanks\"><\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5n F2 \u0111\u1ec3 ch\u1ec9nh s\u1eeda \u00f4 cu\u1ed1i c\u00f9ng v\u1eeba ch\u1ecdn v\u00e0 g\u00f5 d\u1eef li\u1ec7u v\u00e0o: c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, m\u1ed9t con s\u1ed1 ho\u1eb7c c\u00f4ng th\u1ee9c (v\u00ed d\u1ee5: \u201c_unknown_\u201d)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-edit-cell.png\" alt=\"Enter the data into the last selected cell\" title=\"excel-edit-cell\"><\/p>\n<p style=\"text-align: justify\">3. Nh\u1ea5n <strong>Ctrl+Enter\u00a0<\/strong>thay v\u00ec Enter. T\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c \u0111i\u1ec1n v\u1edbi d\u1eef li\u1ec7u b\u1ea1n v\u1eeba nh\u1eadp<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-fill-ctrl-enter.png\" alt=\"Have all cells filled in with the entered value\" title=\"excel-fill-ctrl-enter\"><\/p>\n<p style=\"text-align: justify\">Ngu\u1ed3n: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/p>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-305.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7565,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7564","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=7564"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7564\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7565"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}