{"id":4565,"date":"2024-12-06T12:11:50","date_gmt":"2024-12-06T12:11:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/chi-dan-du-lieu-hoac-dien-cong-thuc-vao-o-khong-bi-an\/"},"modified":"2024-12-06T12:11:50","modified_gmt":"2024-12-06T12:11:50","slug":"chi-dan-du-lieu-hoac-dien-cong-thuc-vao-o-khong-bi-an","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/chi-dan-du-lieu-hoac-dien-cong-thuc-vao-o-khong-bi-an\/","title":{"rendered":"Ch\u1ec9 d\u00e1n d\u1eef li\u1ec7u ho\u1eb7c \u0111i\u1ec1n c\u00f4ng th\u1ee9c v\u00e0o \u00f4 kh\u00f4ng b\u1ecb \u1ea9n"},"content":{"rendered":"
\n

\u0110\u00e3 c\u00f3 l\u00fac b\u1ea1n mu\u1ed1n \u0111i\u1ec1n nhanh d\u1eef li\u1ec7u ho\u1eb7c c\u00f4ng th\u1ee9c v\u00e0o 1 c\u1ed9t d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n \u1edf c\u00e1c c\u1ed9t kh\u00e1c, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ef9 thu\u1eadt \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y \u0111\u1ec3 c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c \u0111\u00f3 m\u1ed9t c\u00e1ch nhanh nh\u1ea5t v\u01a1i H\u1ecdc Excel Online<\/strong><\/a><\/p>\n

\u1ede \u0111\u00e2y, m\u00ecnh s\u1ebd \u0111\u01b0a ra 1 v\u00ed d\u1ee5 minh h\u1ecda cho vi\u1ec7c n\u00e0y: ch\u00fang ta s\u1ebd \u0111i \u0111i\u1ec1n ch\u1eef \u201cYes\u201d v\u00e0o c\u1ed9t Bonus trong b\u1ea3ng t\u00ednh c\u1ee7a ch\u00fang ta n\u1ebfu Region = \u201cWest\u201d<\/p>\n

\"1-kh\u00f4ng<\/a>
1-kh\u00f4ng copy d\u00f2ng \u1ea9n trong excel<\/figcaption><\/figure>\n

\u0110\u1ea7u ti\u00ean, ch\u00fang ta v\u1eabn ti\u1ebfn h\u00e0nh l\u1ecdc d\u1eef li\u1ec7u nh\u01b0 b\u00ecnh th\u01b0\u1eddng:<\/p>\n

\"2-kh\u00f4ng<\/a>
2-kh\u00f4ng copy d\u00f2ng \u1ea9n trong excel<\/figcaption><\/figure>\n

Sau \u0111\u00f3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng \u1edf c\u1ed9t H:<\/p>\n

\"3-kh\u00f4ng<\/a>
3-kh\u00f4ng copy d\u00f2ng \u1ea9n trong excel<\/figcaption><\/figure>\n

Sau \u0111\u00f3 v\u00e0o th\u1ebb Home\u00a0<\/strong>r\u1ed3i sau \u0111\u00f3 b\u1ea5m n\u00fat\u00a0Find & Select\u00a0<\/strong>r\u1ed3i ch\u1ecdn menu\u00a0Go To Special \u2026\u00a0<\/strong>(Ph\u00edm t\u1eaft Ctrl + G \/ r\u1ed3i b\u1ea5m n\u00fat Special)<\/p>\n

\"4-kh\u00f4ng<\/a>
4-kh\u00f4ng copy d\u00f2ng \u1ea9n trong excel<\/figcaption><\/figure>\n

Trong h\u1ed9p tho\u1ea1i\u00a0Go To Special,\u00a0<\/strong>ch\u1ecdn\u00a0Visible cells only<\/strong><\/p>\n

\"5-kh\u00f4ng<\/a>
5-kh\u00f4ng copy d\u00f2ng \u1ea9n trong excel<\/figcaption><\/figure>\n

Sau \u0111\u00f3 b\u1ea1n s\u1ebd th\u1ea5y v\u00f9ng ch\u1ecdn c\u00f3 s\u1ef1 thay \u0111\u1ed5i nh\u01b0 sau<\/p>\n

\"chi-dan-du-lieu-vao-o-khong-bi-an-08\"<\/a><\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u \u0111i\u1ec1n ch\u1eef \u201cYes\u201d ho\u1eb7c g\u00f5 c\u00f4ng th\u1ee9c v\u00e0o trong thanh c\u00f4ng th\u1ee9c sau \u0111\u00f3 b\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm\u00a0CTRL + ENTER\u00a0<\/strong>\u0111\u1ec3 nh\u1eadp d\u1eef li\u1ec7u ho\u1eb7c c\u00f4ng th\u1ee9c v\u00e0o nh\u1eefng \u00f4 kh\u00f4ng b\u1ecb \u1ea9n n\u00e0y. N\u1ebfu tr\u01b0\u1edbc nh\u1eefng thao t\u00e1c trong b\u00e0i, b\u1ea1n \u0111ang copy 1 \u00f4 d\u1eef li\u1ec7u, th\u00ec b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft CTRL + V \u0111\u1ec3 d\u00e1n d\u1eef li\u1ec7u \u0111\u00f3 v\u00e0o nh\u1eefng \u00f4 \u0111ang \u0111\u01b0\u1ee3c nh\u00ecn th\u1ea5y.<\/p>\n

Ch\u00fa \u00fd<\/strong>: N\u1ebfu b\u1ea1n kh\u00f4ng c\u1ea7n d\u00e1n d\u1eef li\u1ec7u \u0111\u00e3 copy tr\u01b0\u1edbc \u0111\u00f3, th\u00ec b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u0111i\u1ec1n d\u1eef li\u1ec7u ho\u1eb7c c\u00f4ng th\u1ee9c v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean trong v\u00f9ng nh\u00ecn th\u1ea5y \u1edf c\u1ed9t H sau \u0111\u00f3 d\u00f9ng Fill Handle \u0111\u1ec3 k\u00e9o d\u1eef li\u1ec7u v\u00e0 c\u00f4ng th\u1ee9c \u0111\u00f3 xu\u1ed1ng.<\/p>\n

\"chi-dan-du-lieu-vao-o-khong-bi-an-06\"<\/a><\/p>\n

V\u00e0 k\u1ebft qu\u1ea3 l\u00e0<\/p>\n

\"6-kh\u00f4ng<\/a>
6-kh\u00f4ng copy d\u00f2ng \u1ea9n trong excel<\/figcaption><\/figure>\n<\/div>\n
\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4566,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4565","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4565","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=4565"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4565\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4566"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}