{"id":9572,"date":"2025-01-02T10:09:42","date_gmt":"2025-01-02T10:09:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-dao-nguoc-dau-nhieu-so-cung-luc-don-gian-chi-voi-toi-da-6-lan-nhan-chuot\/"},"modified":"2025-01-02T10:09:42","modified_gmt":"2025-01-02T10:09:42","slug":"huong-dan-dao-nguoc-dau-nhieu-so-cung-luc-don-gian-chi-voi-toi-da-6-lan-nhan-chuot","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-dao-nguoc-dau-nhieu-so-cung-luc-don-gian-chi-voi-toi-da-6-lan-nhan-chuot\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u0111\u1ea3o ng\u01b0\u1ee3c d\u1ea5u nhi\u1ec1u s\u1ed1 c\u00f9ng l\u00fac \u0111\u01a1n gi\u1ea3n ch\u1ec9 v\u1edbi t\u1ed1i \u0111a 6 l\u1ea7n nh\u1ea5n chu\u1ed9t"},"content":{"rendered":"
\n

H\u00e3y gi\u1ea3 s\u1eed r\u1eb1ng b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng v\u1edbi c\u00e1c con s\u1ed1. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch \u0111\u1ea3o ng\u01b0\u1ee3c d\u1ea5u c\u1ee7a to\u00e0n b\u1ed9 b\u1ea3ng \u0111\u00f3 c\u00f9ng l\u00fac ch\u1ec9 v\u1edbi c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n. C\u1ee5 th\u1ec3, h\u00e3y \u0111\u1ecdc: \u0111\u1ea3o ng\u01b0\u1ee3c d\u1ea5u nhi\u1ec1u s\u1ed1 c\u00f9ng l\u00fac ch\u1ec9 v\u1edbi v\u00e0i click chu\u1ed9t.<\/p>\n

\u0110\u1ea3o ng\u01b0\u1ee3c d\u1ea5u nhi\u1ec1u s\u1ed1 c\u00f9ng l\u00fac b\u1eb1ng thao t\u00e1c Copy Paste<\/h3>\n
B\u1ea3ng s\u1ed1 v\u1ec1 c\u01a1 b\u1ea3n s\u1ebd tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0y<\/figcaption><\/figure>\n

B\u00e2y gi\u1edd, \u0111\u1ec3 \u0111\u1ed5i d\u1ea5u, ta s\u1ebd l\u00e0m theo c\u00e1c b\u01b0\u1edbc, c\u1ee5 th\u1ec3 l\u00e0 c\u00e1c click sau:<\/p>\n

T\u1ea1i \u00f4 b\u1ea5t k\u00ec, g\u00f5 \u201c-1\u201d.<\/p>\n

<\/p>\n

Click 1:\u00a0<\/em>Click v\u00e0o \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb -1.<\/p>\n

Click 2:\u00a0<\/em>Click chu\u1ed9t ph\u1ea3i ch\u1ecdn Copy<\/strong>.<\/p>\n

<\/p>\n

Click 3:\u00a0<\/em>K\u00e9o th\u1ea3 ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng.<\/p>\n

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

<\/p>\n

Click 4:\u00a0<\/em>Click chu\u1ed9t ph\u1ea3i ch\u1ecdn\u00a0Paste Special.<\/strong><\/p>\n

Click 5:\u00a0<\/em>Khi h\u1ed9p tho\u1ea1i\u00a0Paste Special<\/strong> hi\u1ec7n ra, ch\u1ecdn\u00a0Mutiply.<\/strong><\/p>\n

<\/p>\n

Click 6:\u00a0<\/em>Click\u00a0OK.<\/strong><\/p>\n

K\u1ebft qu\u1ea3:<\/p>\n

<\/p>\n

Gi\u1ea3i th\u00edch:<\/strong><\/p>\n

-Ta v\u1eeba l\u00e0m thao t\u00e1c nh\u00e2n m\u1ed9t b\u1ea3ng v\u1edbi -1, m\u00e0 m\u1ed9t s\u1ed1 khi nh\u00e2n v\u1edbi -1 s\u1ebd \u0111\u1ed5i d\u1ea5u c\u1ee7a n\u00f3.<\/em><\/p>\n

L\u01b0u \u00fd:<\/strong><\/p>\n

-D\u1eef li\u1ec7u d\u1ea1ng Text trong b\u1ea3ng s\u1ebd \u0111\u01b0\u1ee3c b\u1ecf qua, kh\u00f4ng b\u1ecb d\u00ednh l\u1ed7i #VALUE! nh\u01b0 khi th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n b\u00ecnh th\u01b0\u1eddng.<\/p>\n

-D\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng (th\u1ef1c ra c\u0169ng l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng Number), khi chuy\u1ec3n sang d\u1ea5u \u00e2m s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb ng\u00e0y th\u00e1ng n\u1eefa.<\/p>\n

\u00a0<\/p>\n

V\u1eady l\u00e0 ch\u1ec9 v\u1edbi t\u1ed1i \u0111a 6 click, ta \u0111\u00e3 \u0111\u1ea3o ng\u01b0\u1ee3c d\u1ea5u nhi\u1ec1u s\u1ed1 c\u00f9ng l\u00fac r\u1ed3i. Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n

Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\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":9573,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9572","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\/9572","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=9572"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9572\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9573"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}