{"id":4912,"date":"2024-12-08T13:12:33","date_gmt":"2024-12-08T13:12:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-giu-o-tham-chieu-co-dinh-trong-excel\/"},"modified":"2024-12-08T13:12:33","modified_gmt":"2024-12-08T13:12:33","slug":"cach-giu-o-tham-chieu-co-dinh-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/cach-giu-o-tham-chieu-co-dinh-trong-excel\/","title":{"rendered":"C\u00e1ch gi\u1eef \u00f4 tham chi\u1ebfu c\u1ed1 \u0111\u1ecbnh trong Excel"},"content":{"rendered":"
\n

Khi b\u1ea1n tham chi\u1ebfu \u00f4 trong c\u00f4ng th\u1ee9c, \u0111\u1ecba ch\u1ec9 \u00f4 s\u1ebd t\u1ef1 \u0111i\u1ec1u ch\u1ec9nh khi b\u1ea1n di chuy\u1ec3n \u0111\u1ebfn m\u1ed9t v\u00f9ng kh\u00e1c ho\u1eb7c sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u1ebfn \u00f4 kh\u00e1c. Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel<\/strong>. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch gi\u1eefa c\u1ed1 \u0111\u1ecbnh \u0111\u1ecba ch\u1ec9 \u00f4 tham chi\u1ebfu.<\/strong><\/em><\/p>\n

\"1<\/a>
1 \u2013 c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel<\/figcaption><\/figure>\n

\u0110\u1ec3 gi\u1eef c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel trong c\u00f4ng th\u1ee9c, b\u1ea1n ch\u1ec9 c\u1ea7n th\u00eam k\u00fd hi\u1ec7u $ v\u00e0o tr\u01b0\u1edbc \u00f4 tham chi\u1ebfu b\u1eb1ng c\u00e1ch nh\u1ea5n F4. H\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n

1. Ch\u1ecdn \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh.<\/p>\n

2. Tr\u00ean thanh c\u00f4ng th\u1ee9c, ch\u1ecdn \u00f4 tham chi\u1ebfu, nh\u1ea5n F4.<\/strong><\/p>\n

Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, l\u00e0 \u00f4 A1.<\/p>\n

\"2
2 \u2013 c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel<\/figcaption><\/figure>\n

V\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y A1 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh trong c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n

\"3
3 \u2013 c\u1ed1 \u0111\u1ecbnh \u00f4 trong excel<\/figcaption><\/figure>\n


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