{"id":11659,"date":"2025-01-15T04:49:10","date_gmt":"2025-01-15T04:49:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-chinh-sua-danh-gia-va-sua-loi-cong-thuc-trong-excel\/"},"modified":"2025-01-15T04:49:10","modified_gmt":"2025-01-15T04:49:10","slug":"cach-chinh-sua-danh-gia-va-sua-loi-cong-thuc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-chinh-sua-danh-gia-va-sua-loi-cong-thuc-trong-excel\/","title":{"rendered":"C\u00e1ch ch\u1ec9nh s\u1eeda, \u0111\u00e1nh gi\u00e1 v\u00e0 s\u1eeda l\u1ed7i c\u00f4ng th\u1ee9c trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t v\u00e0i c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 \u0111\u1ec3 ki\u1ec3m tra v\u00e0 s\u1eeda l\u1ed7i c\u00f4ng th\u1ee9c trong Excel.\u00a0C\u00e1ch s\u1eed d\u1ee5ng\u00a0ph\u00edm F9\u00a0\u0111\u1ec3 \u0111\u00e1nh gi\u00e1 t\u1eebng ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 tham chi\u1ebfu ho\u1eb7c \u0111\u01b0\u1ee3c tham chi\u1ebfu b\u1edfi m\u1ed9t c\u00f4ng th\u1ee9c nh\u1ea5t \u0111\u1ecbnh, c\u00e1ch x\u00e1c \u0111\u1ecbnh l\u1ed7i kh\u00f4ng kh\u1edbp ho\u1eb7c sai v\u1ecb tr\u00ed, v\u00e0 nhi\u1ec1u th\u1ee9 kh\u00e1c.<\/em><\/p>\n<p style=\"text-align: justify\"><strong>Ph\u00edm F2 trong Excel \u2013 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c<\/strong><\/p>\n<p style=\"text-align: justify\">Ph\u00edm\u00a0F2\u00a0trong Excel lai gi\u1eefa\u00a0ch\u1ebf \u0111\u1ed9 <em>Edit\u00a0<\/em>v\u00e0\u00a0\u00a0<em>Enter<\/em>.\u00a0Khi b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i c\u00f4ng th\u1ee9c hi\u1ec7n t\u1ea1i, h\u00e3y ch\u1ecdn \u00f4 c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n\u00a0F2\u00a0\u0111\u1ec3 v\u00e0o\u00a0<strong><em>Edit mode<\/em><\/strong>.\u00a0M\u1ed9t khi b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y, con tr\u1ecf s\u1ebd b\u1eaft \u0111\u1ea7u nh\u1ea5p nh\u00e1y \u1edf cu\u1ed1i d\u1ea5u ngo\u1eb7c trong thanh c\u00f4ng th\u1ee9c ho\u1eb7c \u00f4 c\u00f4ng th\u1ee9c (t\u00f9y thu\u1ed9c v\u00e0o t\u00f9y ch\u1ecdn\u00a0<strong><em>Allow editing directly in cells<\/em><\/strong> \u0111\u01b0\u1ee3c ch\u1ecdn\u00a0hay kh\u00f4ng ch\u1ecdn).\u00a0V\u00e0 b\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 ch\u1ec9nh s\u1eeda n\u00e0o trong c\u00f4ng th\u1ee9c:<\/p>\n<ul style=\"text-align: justify\">\n<li>S\u1eed d\u1ee5ng m\u0169i t\u00ean tr\u00e1i v\u00e0 ph\u1ea3i \u0111\u1ec3 \u0111i\u1ec1u h\u01b0\u1edbng trong c\u00f4ng th\u1ee9c.<\/li>\n<li>S\u1eed d\u1ee5ng c\u00e1c ph\u00edm m\u0169i t\u00ean c\u00f9ng v\u1edbi Shift \u0111\u1ec3 ch\u1ecdn c\u00e1c ph\u1ea7n c\u00f4ng th\u1ee9c (c\u0169ng c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u1eb1ng chu\u1ed9t).<\/li>\n<li>Nh\u1ea5n\u00a0<em>Delete\u00a0<\/em>ho\u1eb7c\u00a0<em>Backspace<\/em>\u00a0\u0111\u1ec3 x\u00f3a tham chi\u1ebfu \u00f4 nh\u1ea5t \u0111\u1ecbnh ho\u1eb7c c\u00e1c ph\u1ea7n t\u1eed kh\u00e1c c\u1ee7a c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Khi b\u1ea1n ho\u00e0n t\u1ea5t ch\u1ec9nh s\u1eeda, nh\u1ea5n Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tho\u00e1t ch\u1ebf \u0111\u1ed9 Ch\u1ec9nh s\u1eeda m\u00e0 kh\u00f4ng th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 thay \u0111\u1ed5i n\u00e0o \u0111\u1ed1i v\u1edbi c\u00f4ng th\u1ee9c, h\u00e3y nh\u1ea5n ph\u00edm Esc.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u1ec9nh s\u1eeda tr\u1ef1c ti\u1ebfp trong \u00f4 ho\u1eb7c trong thanh c\u00f4ng th\u1ee9c<\/strong><\/p>\n<p style=\"text-align: justify\">Theo m\u1eb7c \u0111\u1ecbnh, vi\u1ec7c nh\u1ea5n ph\u00edm\u00a0<strong>F2<\/strong>\u00a0trong Excel s\u1ebd \u0111\u1eb7t con tr\u1ecf v\u00e0o cu\u1ed1i c\u00f4ng th\u1ee9c trong m\u1ed9t \u00f4.\u00a0N\u1ebfu b\u1ea1n th\u00edch ch\u1ec9nh s\u1eeda trong\u00a0thanh c\u00f4ng th\u1ee9c Excel\u00a0, h\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5p v\u00e0o\u00a0<em>File\u00a0&gt;\u00a0Options<\/em>\u00a0.<\/li>\n<li>Trong ng\u0103n b\u00ean tr\u00e1i, ch\u1ecdn\u00a0<em>Advanced<\/em>\u00a0.<\/li>\n<li>Trong ng\u0103n b\u00ean ph\u1ea3i, b\u1ecf ch\u1ecdn t\u00f9y ch\u1ecdn\u00a0<strong><em>Allow editing directly in cells<\/em> <\/strong>b\u00ean d\u01b0\u1edbi\u00a0<strong><em>Editing Options<\/em><\/strong>.<\/li>\n<li>Nh\u1ea5p\u00a0<em>OK<\/em>\u00a0\u0111\u1ec3 l\u01b0u c\u00e1c thay \u0111\u1ed5i v\u00e0 \u0111\u00f3ng h\u1ed9p tho\u1ea1i.<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/allow-editing-in-cells.png\" alt=\"For the F2 key to position the cursor in the formula bar, uncheck the 'Allow editing directly in cells' option.\" title=\"allow-editing-in-cells\"><\/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\/2025\/01\/vba101_92019-nho-54.gif\" title=\"vba101_92019-nho-54\"><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\/2025\/01\/ex101_92019-nho-317.gif\" title=\"ex101_92019-nho-317\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Hi\u1ec7n nay, <strong>F2 <\/strong>th\u01b0\u1eddng \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t c\u00e1ch c\u1ed5 \u0111i\u1ec3n \u0111\u1ec3 ch\u1ec9nh s\u1eeda c\u00e1c c\u00f4ng th\u1ee9c.\u00a0Hai c\u00e1ch kh\u00e1c \u0111\u1ec3 v\u00e0o <strong><em>Edit mode <\/em><\/strong>\u00a0l\u00e0:<\/p>\n<ul style=\"text-align: justify\">\n<li>Nh\u1ea5p \u0111\u00fap v\u00e0o \u00f4, ho\u1eb7c<\/li>\n<li>Nh\u1ea5p v\u00e0o b\u1ea5t c\u1ee9 n\u01a1i n\u00e0o trong thanh c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u1eady F2 c\u00f3 hi\u1ec7u qu\u1ea3 h\u01a1n hay n\u00f3 c\u00f3 l\u1ee3i th\u1ebf g\u00ec?\u00a0Kh\u00f4ng. \u0110\u01a1n gi\u1ea3n l\u00e0 m\u1ed9t s\u1ed1 ng\u01b0\u1eddi th\u00edch l\u00e0m vi\u1ec7c v\u1edbi b\u00e0n ph\u00edm trong khi nh\u1eefng ng\u01b0\u1eddi kh\u00e1c l\u1ea1i th\u1ea5y thu\u1eadn ti\u1ec7n h\u01a1n khi s\u1eed d\u1ee5ng chu\u1ed9t.<\/p>\n<p style=\"text-align: justify\">Cho d\u00f9 b\u1ea1n ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p ch\u1ec9nh s\u1eeda n\u00e0o, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y ch\u1ebf \u0111\u1ed9 <strong><em>Edit mode<\/em><\/strong> \u1edf g\u00f3c d\u01b0\u1edbi c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a m\u00e0n h\u00ecnh.\u00a0Ngay sau khi b\u1ea1n nh\u1ea5n\u00a0ph\u00edm <strong><em>F2<\/em><\/strong>\u00a0, ho\u1eb7c nh\u1ea5p \u0111\u00fap v\u00e0o \u00f4, ho\u1eb7c nh\u1ea5p v\u00e0o thanh c\u00f4ng th\u1ee9c, t\u1eeb\u00a0<strong><em>Edit<\/em>\u00a0<\/strong>\u00a0s\u1ebd xu\u1ea5t hi\u1ec7n ngay b\u00ean d\u01b0\u1edbi tab sheet:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-edit-mode.png\" alt=\"A visual indication that Microsoft Excel is in the Edit mode.\" title=\"excel-edit-mode\"><\/p>\n<p style=\"text-align: justify\"><strong>Ph\u00edm F9 trong Excel \u2013 \u0111\u00e1nh gi\u00e1 c\u00e1c ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c<\/strong><\/p>\n<p style=\"text-align: justify\">Trong Microsoft Excel,\u00a0ph\u00edm F9\u00a0l\u00e0 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 nhanh ch\u00f3ng \u0111\u1ec3 ki\u1ec3m tra v\u00e0 s\u1eeda l\u1ed7i c\u00f4ng th\u1ee9c.\u00a0N\u00f3 cho ph\u00e9p b\u1ea1n \u0111\u00e1nh gi\u00e1 ch\u1ec9 ph\u1ea7n \u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn c\u1ee7a c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch thay th\u1ebf c\u00e1c gi\u00e1 tr\u1ecb th\u1ef1c ho\u1eb7c thay b\u1eb1ng k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n.\u00a0V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a\u00a0ph\u00edm <strong><em>F9<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3\u00a0c\u00f4ng th\u1ee9c <strong><em>IF<\/em><\/strong>\u00a0trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n:<\/p>\n<p style=\"text-align: justify\"><strong>=IF(AVERAGE(A2:A6)&gt;AVERAGE(B2:B6),\u201dGood\u201d,\u201dBad\u201d)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u00e1nh gi\u00e1 t\u1eebng h\u00e0m Average\u00a0c\u00f3 trong c\u00f4ng th\u1ee9c, th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 c\u00f3 c\u00f4ng th\u1ee9c, trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 D1.<\/li>\n<li>Nh\u1ea5n\u00a0F2\u00a0ho\u1eb7c nh\u1ea5p \u0111\u00fap v\u00e0o \u00f4 \u0111\u00e3 ch\u1ecdn \u0111\u1ec3 v\u00e0o ch\u1ebf \u0111\u1ed9 Edit mode.<\/li>\n<li>Ch\u1ecdn ph\u1ea7n c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra v\u00e0 nh\u1ea5n\u00a0F9\u00a0.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n ch\u1ecdn h\u00e0m Average \u0111\u1ea7u ti\u00ean, t\u1ee9c l\u00e0 AVERAGE (A2: A6), v\u00e0 nh\u1ea5n\u00a0F9\u00a0, Excel s\u1ebd hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-f9-key.png\" alt=\"Select the function and press F9 to see the calculated value.\" title=\"excel-f9-key\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u1ec9 ch\u1ecdn ph\u1ea1m vi \u00f4 (A2: A6) v\u00e0 nh\u1ea5n\u00a0F9\u00a0, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf thay v\u00ec c\u00e1c tham chi\u1ebfu \u00f4:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-f9-key.png\" alt=\"Select the function and press F9 to see the calculated value.\" title=\"excel-f9-key\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3\u00a0<strong>tho\u00e1t<\/strong>\u00a0ch\u1ebf \u0111\u1ed9 \u0111\u00e1nh gi\u00e1 c\u00f4ng th\u1ee9c, b\u1ea5m\u00a0ph\u00edm Esc\u00a0.<\/p>\n<p style=\"text-align: justify\">\u00a0<strong><em>M\u1eb9o<\/em><\/strong><strong><em> F9<\/em><\/strong><strong><em>:<\/em><\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>H\u00e3y ch\u1eafc ch\u1eafn \u0111\u00e3 ch\u1ecdn m\u1ed9t ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c tr\u01b0\u1edbc khi nh\u1ea5n F9, n\u1ebfu kh\u00f4ng ph\u00edm F9 s\u1ebd thay th\u1ebf to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c v\u1edbi gi\u00e1 tr\u1ecb \u0111\u00e3 \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n c\u1ee7a n\u00f3.<\/li>\n<li>Khi \u1edf ch\u1ebf \u0111\u1ed9 \u0111\u00e1nh gi\u00e1 c\u00f4ng th\u1ee9c, kh\u00f4ng nh\u1ea5n ph\u00edm Enter v\u00ec \u0111i\u1ec1u n\u00e0y s\u1ebd thay th\u1ebf ph\u1ea7n \u0111\u00e3 ch\u1ecdn b\u1eb1ng gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n ho\u1eb7c gi\u00e1 tr\u1ecb \u00f4.\u00a0\u0110\u1ec3 gi\u1eef l\u1ea1i c\u00f4ng th\u1ee9c g\u1ed1c, nh\u1ea5n ph\u00edm Esc \u0111\u1ec3 h\u1ee7y th\u1eed nghi\u1ec7m c\u00f4ng th\u1ee9c v\u00e0 tho\u00e1t kh\u1ecfi ch\u1ebf \u0111\u1ed9 \u0111\u00e1nh gi\u00e1 c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<blockquote>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">Th\u1ee7 thu\u1eadt Excel hay<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">K\u1ef9 thu\u1eadt\u00a0 F9\u00a0\u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch cho vi\u1ec7c ki\u1ec3m tra c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p, ch\u1eb3ng h\u1ea1n nh\u01b0 c\u00e1c c\u00f4ng th\u1ee9c l\u1ed3ng nhau ho\u1eb7c\u00a0c\u00e1c c\u00f4ng th\u1ee9c m\u1ea3ng, v\u00ec n\u00f3 bao g\u1ed3m nhi\u1ec1u ph\u00e9p t\u00ednh trung gian ho\u1eb7c c\u00e1c ph\u00e9p th\u1eed logic.\u00a0Ph\u01b0\u01a1ng ph\u00e1p s\u1eeda l\u1ed7i n\u00e0y cho ph\u00e9p b\u1ea1n thu h\u1eb9p m\u1ed9t l\u1ed7i \u0111\u1ebfn m\u1ed9t ph\u1ea1m vi ho\u1eb7c h\u00e0m c\u1ee5 th\u1ec3 g\u00e2y ra.<\/p>\n<p style=\"text-align: justify\"><strong>S\u1eeda l\u1ed7i m\u1ed9t c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Evaluate Formula feature<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 c\u00e1c c\u00f4ng th\u1ee9c trong Excel l\u00e0\u00a0t\u00f9y ch\u1ecdn\u00a0<strong><em>Evaluate Formula feature<\/em> <\/strong>n\u1eb1m tr\u00ean\u00a0tab\u00a0<strong><em>Formulas<\/em><\/strong>, trong\u00a0nh\u00f3m\u00a0<strong><em>Formula Auditing<\/em><\/strong><em>.<\/em><\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-evaluate-formula.png\" alt=\"The Evaluate Formula button on the ribbon\" title=\"excel-evaluate-formula\"><\/p>\n<p style=\"text-align: justify\">Ngay sau khi b\u1ea1n nh\u1ea5p v\u00e0o n\u00fat n\u00e0y,\u00a0h\u1ed9p tho\u1ea1i\u00a0<strong>E<em>valuate Formula<\/em><\/strong> s\u1ebd b\u1eadt l\u00ean, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra t\u1eebng ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c theo th\u1ee9 t\u1ef1 t\u00ednh c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">T\u1ea5t c\u1ea3 b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<strong>Evaluate\u00a0<\/strong>v\u00e0 ki\u1ec3m tra gi\u00e1 tr\u1ecb c\u1ee7a ph\u1ea7n c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c g\u1ea1ch ch\u00e2n.\u00a0K\u1ebft qu\u1ea3 c\u1ee7a \u0111\u00e1nh gi\u00e1 g\u1ea7n nh\u1ea5t \u0111\u01b0\u1ee3c in nghi\u00eang.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/evaluate-formula-dialog-box.png\" alt=\"Click the Evaluate button and examine the value of the underlined formula part.\" title=\"evaluate-formula-dialog-box\"><\/p>\n<p style=\"text-align: justify\">Ti\u1ebfp t\u1ee5c nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<strong>Evaluate\u00a0<\/strong>cho \u0111\u1ebfn khi t\u1eebng ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c ki\u1ec3m tra.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 k\u1ebft th\u00fac \u0111\u00e1nh gi\u00e1, nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<strong>Close\u00a0<\/strong>.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u00e1nh gi\u00e1 c\u00f4ng th\u1ee9c t\u1eeb \u0111\u1ea7u, h\u00e3y nh\u1ea5p v\u00e0o\u00a0<strong>Restart<\/strong>\u00a0.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu ph\u1ea7n g\u1ea1ch ch\u00e2n c\u1ee7a c\u00f4ng th\u1ee9c l\u00e0 m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 c\u00f3 ch\u1ee9a c\u00f4ng th\u1ee9c kh\u00e1c, nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong>Step In<\/strong>\u00a0\u0111\u1ec3 c\u00f4ng th\u1ee9c kh\u00e1c hi\u1ec3n th\u1ecb trong\u00a0h\u1ed9p\u00a0<em>Evaluation. <\/em>\u0110\u1ec3 tr\u1edf v\u1ec1 c\u00f4ng th\u1ee9c tr\u01b0\u1edbc, nh\u1ea5p v\u00e0o\u00a0<strong>Step Out<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/evaluate-formula-stepin.png\" alt=\"Click the &lt;strong&gt;Step In&lt;\/strong&gt; button to evaluate another formula that the underlined part refers to.\" title=\"evaluate-formula-stepin\"><br \/>\n<strong>Ch\u00fa \u00fd.\u00a0<\/strong>N\u00fat\u00a0<em>Step In<\/em>\u00a0kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\u1ed1i v\u1edbi tham chi\u1ebfu \u00f4 ch\u1ec9 \u0111\u1ebfn m\u1ed9t c\u00f4ng th\u1ee9c kh\u00e1c trong m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c.\u00a0Ngo\u00e0i ra, n\u00f3 c\u0169ng kh\u00f4ng \u00e1p d\u1ee5ng cho m\u1ed9t tham chi\u1ebfu \u00f4 xu\u1ea5t hi\u1ec7n trong c\u00f4ng th\u1ee9c l\u1ea7n th\u1ee9 hai (nh\u01b0 v\u00ed d\u1ee5 th\u1ee9 hai c\u1ee7a D1 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean).<\/p>\n<p style=\"text-align: justify\"><strong>L\u00e0m n\u1ed5i b\u1eadt v\u00e0 kh\u1edbp c\u00e1c c\u1eb7p d\u1ea5u ngo\u1eb7c \u0111\u01a1n trong m\u1ed9t c\u00f4ng th\u1ee9c<\/strong><\/p>\n<p style=\"text-align: justify\">Khi t\u1ea1o c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p trong Excel, b\u1ea1n th\u01b0\u1eddng c\u1ea7n nhi\u1ec1u c\u1eb7p ngo\u1eb7c \u0111\u01a1n \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh th\u1ee9 t\u1ef1 c\u1ee7a ph\u00e9p t\u00ednh ho\u1eb7c t\u1ed5 ch\u1ee9c m\u1ed9t v\u00e0i h\u00e0m kh\u00e1c nhau.\u00a0\u0110i\u1ec1u n\u00e0y d\u1ec5 g\u00e2y nh\u1ea7m l\u1eabn, b\u1ecf qu\u00ean, ho\u1eb7c th\u1eeba ngo\u1eb7c \u0111\u01a1n trong c\u00e1c c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n b\u1ecf l\u1ee1 ho\u1eb7c \u0111\u1eb7t sai d\u1ea5u ngo\u1eb7c \u0111\u01a1n m\u00e0 nh\u1ea5n ph\u00edm Enter, Microsoft Excel s\u1ebd hi\u1ec3n th\u1ecb m\u1ed9t c\u1ea3nh b\u00e1o g\u1ee3i \u00fd \u0111\u1ec3 s\u1eeda c\u00f4ng th\u1ee9c cho b\u1ea1n:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/missing-parentheses-alert.png\" alt=\"Microsoft Excel displays an alert suggesting to fix the formula for you automatically.\" title=\"missing-parentheses-alert\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u1ed3ng \u00fd v\u1edbi \u0111\u1ec1 xu\u1ea5t s\u1eeda \u0111\u1ed5i, h\u00e3y nh\u1ea5p v\u00e0o\u00a0<em>Yes<\/em>.\u00a0N\u1ebfu c\u00f4ng th\u1ee9c ch\u1ec9nh s\u1eeda kh\u00f4ng ph\u1ea3i l\u00e0 \u0111i\u1ec1u b\u1ea1n mu\u1ed1n, h\u00e3y nh\u1ea5p v\u00e0o\u00a0<em>No<\/em>\u00a0v\u00e0 th\u1ef1c hi\u1ec7n ch\u1ec9nh s\u1eeda theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>Microsoft Excel kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng s\u1eeda c\u00e1c d\u1ea5u ngo\u1eb7c b\u1ecb thi\u1ebfu ho\u1eb7c kh\u00f4ng t\u01b0\u01a1ng x\u1ee9ng.\u00a0V\u00ec v\u1eady, lu\u00f4n lu\u00f4n xem x\u00e9t l\u1ea1i \u0111\u1ec1 xu\u1ea5t s\u1eeda \u0111\u1ed5i c\u1ea9n th\u1eadn tr\u01b0\u1edbc khi ch\u1ea5p nh\u1eadn n\u00f3.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 gi\u00fap b\u1ea1n\u00a0<strong>c\u00e2n b\u1eb1ng c\u00e1c c\u1eb7p d\u1ea5u ngo\u1eb7c \u0111\u01a1n<\/strong>\u00a0, Excel cung c\u1ea5p ba ki\u1ec3u tr\u1ef1c quan khi b\u1ea1n g\u00f5 ho\u1eb7c ch\u1ec9nh s\u1eeda m\u1ed9t c\u00f4ng th\u1ee9c:<\/p>\n<ul style=\"text-align: justify\">\n<li>Khi nh\u1eadp m\u1ed9t c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p c\u00f3 ch\u1ee9a nhi\u1ec1u d\u1ea5u ngo\u1eb7c \u0111\u01a1n, Excel s\u1ebd t\u1ea1o ra c\u00e1c c\u1eb7p d\u1ea5u ngo\u1eb7c \u0111\u01a1n v\u1edbi c\u00e1c m\u00e0u kh\u00e1c nhau \u0111\u1ec3 d\u1ec5 d\u00e0ng nh\u1eadn di\u1ec7n ch\u00fang.\u00a0C\u1eb7p ngo\u1eb7c ngo\u00e0i c\u00f9ng lu\u00f4n lu\u00f4n l\u00e0 m\u00e0u \u0111en.\u00a0\u0110i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh xem b\u1ea1n \u0111\u00e3 ch\u00e8n \u0111\u00fang s\u1ed1 ngo\u1eb7c \u0111\u01a1n v\u00e0o c\u00f4ng th\u1ee9c hay ch\u01b0a.<\/li>\n<li>Khi b\u1ea1n g\u00f5 d\u1ea5u \u0111\u00f3ng ngo\u1eb7c trong c\u00f4ng th\u1ee9c, Excel s\u1ebd in \u0111\u1eadm c\u1eb7p d\u1ea5u ngo\u1eb7c \u0111\u01a1n (d\u1ea5u ngo\u1eb7c \u0111\u01a1n b\u1ea1n v\u1eeba nh\u1eadp v\u00e0 d\u1ea5u ngo\u1eb7c \u0111\u01a1n b\u00ean tr\u00e1i).\u00a0N\u1ebfu b\u1ea1n ngh\u0129 b\u1ea1n \u0111\u00e3 g\u00f5 d\u1ea5u ngo\u1eb7c \u0111\u00f3ng cu\u1ed1i c\u00f9ng trong c\u00f4ng th\u1ee9c v\u00e0 Excel kh\u00f4ng in \u0111\u1eadm d\u1ea5u ngo\u1eb7c m\u1edf, th\u00ec d\u1ea5u ngo\u1eb7c \u0111\u01a1n c\u1ee7a b\u1ea1n kh\u00f4ng kh\u1edbp ho\u1eb7c kh\u00f4ng c\u00e2n b\u1eb1ng.<\/li>\n<li>Khi b\u1ea1n di chuy\u1ec3n trong c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1c ph\u00edm m\u0169i t\u00ean v\u00e0 v\u01b0\u1ee3t qua m\u1ed9t d\u1ea5u ngo\u1eb7c \u0111\u01a1n, d\u1ea5u ngo\u1eb7c \u0111\u01a1n kh\u00e1c trong c\u1eb7p \u0111\u01b0\u1ee3c in \u0111\u1eadm v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u00f9ng m\u00e0u.\u00a0B\u1eb1ng c\u00e1ch n\u00e0y, Excel c\u1ed1 g\u1eafng l\u00e0m cho c\u00e1c c\u1eb7p ngo\u1eb7c \u0111\u01a1n r\u00f5 r\u00e0ng h\u01a1n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong h\u00ecnh sau, t\u00f4i \u0111\u00e3 di chuy\u1ec3n qua d\u1ea5u \u0111\u00f3ng ngo\u1eb7c cu\u1ed1i c\u00f9ng b\u1eb1ng ph\u00edm m\u0169i t\u00ean, v\u00e0 c\u1eb7p d\u1ea5u ngo\u1eb7c ngo\u00e0i (m\u00e0u \u0111en) \u0111\u00e3 \u0111\u01b0\u1ee3c in \u0111\u1eadm:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/parenthesis-pairs-excel.png\" alt=\"Parenthesis pairs in an Excel formula\" title=\"parenthesis-pairs-excel\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu trong m\u1ed9t c\u00f4ng th\u1ee9c nh\u1ea5t \u0111\u1ecbnh<\/strong><\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n s\u1eeda l\u1ed7i m\u1ed9t c\u00f4ng th\u1ee9c trong Excel, c\u00e1c \u00f4 tham chi\u1ebfu c\u0169ng c\u1ea7n \u0111\u01b0\u1ee3c xem x\u00e9t. \u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ph\u1ee5 thu\u1ed9c, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n\u00a0ph\u00edm t\u1eaft\u00a0<strong><em>Ctrl +\u00a0[.<\/em><\/strong>\u00a0Excel s\u1ebd in \u0111\u1eadm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 m\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n \u0111\u1ec1 c\u1eadp \u0111\u1ebfn, v\u00e0 di chuy\u1ec3n v\u00f9ng l\u1ef1a ch\u1ecdn \u0111\u1ebfn \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu \u0111\u1ea7u ti\u00ean ho\u1eb7c m\u1ed9t d\u1ea3i \u00f4.<\/li>\n<li>\u0110\u1ec3 \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ebfn \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu ti\u1ebfp theo, nh\u1ea5n Enter.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, t\u00f4i ch\u1ecdn \u00f4 F4 v\u00e0 nh\u1ea5n\u00a0<strong><em>Ctrl + [<\/em><\/strong>\u00a0.\u00a0Hai \u00f4 (C4 v\u00e0 E4) \u0111\u01b0\u1ee3c tham chi\u1ebfu trong c\u00f4ng th\u1ee9c c\u1ee7a F4 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u, \u00f4 C4 \u0111\u01b0\u1ee3c ch\u1ecdn:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/highlight-referenced-cells.png\" alt=\"Highlighting all cells the formula refers to\" title=\"highlight-referenced-cells\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ebfn \u00f4 \u0111\u00e3 ch\u1ecdn<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1c\u00a0th\u1ee7 thu\u1eadt tr\u01b0\u1edbc\u00a0\u0111\u00e3 h\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u00e1nh d\u1ea5u c\u00e1c \u00f4 tham chi\u1ebfu trong m\u1ed9t c\u00f4ng th\u1ee9c nh\u1ea5t \u0111\u1ecbnh.\u00a0Nh\u01b0ng n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm ra t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c \u0111\u1ec1 c\u1eadp \u0111\u1ebfn m\u1ed9t \u00f4 \u0111\u1eb7c bi\u1ec7t?\u00a0V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n x\u00f3a m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u kh\u00f4ng li\u00ean quan ho\u1eb7c \u0111\u00e3 c\u0169 trong m\u1ed9t b\u1ea3ng t\u00ednh, nh\u01b0ng b\u1ea1n mu\u1ed1n ch\u1eafc r\u1eb1ng vi\u1ec7c x\u00f3a s\u1ebd kh\u00f4ng l\u00e0m h\u1ecfng b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c n\u00e0o hi\u1ec7n c\u00f3.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 cho tr\u01b0\u1edbc, h\u00e3y ch\u1ecdn \u00f4 \u0111\u00f3 v\u00e0 nh\u1ea5n\u00a0ph\u00edm t\u1eaft\u00a0<strong><em>Ctrl +\u00a0]<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Gi\u1ed1ng nh\u01b0 trong v\u00ed d\u1ee5 tr\u01b0\u1edbc, c\u00f4ng th\u1ee9c \u0111\u1ea7u ti\u00ean tr\u00ean b\u1ea3ng t\u00ednh s\u1ebd \u0111\u01b0\u1ee3c ch\u1ecdn.\u00a0\u0110\u1ec3 ch\u1ecdn nh\u1eefng c\u00f4ng th\u1ee9c kh\u00e1c, nh\u1ea5n ph\u00edm Enter li\u00ean t\u1ee5c.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, t\u00f4i \u0111\u00e3 ch\u1ecdn \u00f4 C4, nh\u1ea5n\u00a0<strong><em>Ctrl +]<\/em><\/strong>\u00a0v\u00e0 Excel ngay l\u1eadp t\u1ee9c \u0111\u00e1nh d\u1ea5u c\u00e1c \u00f4 (E4 v\u00e0 F4) c\u00f3 ch\u1ee9a tham chi\u1ebfu C4:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/highlight-formulas-reference-cell.png\" alt=\"Highlighting all formulas that reference the selected cell\" title=\"highlight-formulas-reference-cell\"><br \/>\n<strong>Theo d\u00f5i c\u00e1c m\u1ed1i quan h\u1ec7 gi\u1eefa c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 c\u00e1c \u00f4 trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 hi\u1ec3n th\u1ecb tr\u1ef1c quan c\u00e1c \u00f4 li\u00ean quan \u0111\u1ebfn m\u1ed9t c\u00f4ng th\u1ee9c nh\u1ea5t \u0111\u1ecbnh l\u00e0 s\u1eed d\u1ee5ng n\u00fat\u00a0<strong><em>Trace Precedents<\/em><\/strong>\u00a0 v\u00e0 \u00a0<strong>Trace Dependents<\/strong>\u00a0n\u1eb1m tr\u00ean\u00a0tab\u00a0<strong><em>Formulas<\/em><em>\u00a0&gt;\u00a0Formula Auditing<\/em><\/strong>\u00a0group.<\/p>\n<p style=\"text-align: justify\"><strong>Trace Precedents\u00a0 \u2013 hi\u1ec3n th\u1ecb \u00f4 cung c\u1ea5p d\u1eef li\u1ec7u cho m\u1ed9t c\u00f4ng th\u1ee9c cho tr\u01b0\u1edbc<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>Trace Precedents<\/em><\/strong> ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 ph\u00edm t\u1eaft <strong><em>Ctrl + [<\/em><\/strong>\u00a0, t\u1ee9c l\u00e0 hi\u1ec3n th\u1ecb c\u00e1c \u00f4 cung c\u1ea5p d\u1eef li\u1ec7u cho \u00f4 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\">S\u1ef1 kh\u00e1c bi\u1ec7t l\u00e0\u00a0ph\u00edm t\u1eaft\u00a0<strong><em>Ctrl + [<\/em><\/strong> l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu trong m\u1ed9t c\u00f4ng th\u1ee9c, trong khi nh\u1ea5n v\u00e0o n\u00fat\u00a0<strong><em>Trace Precedents<\/em><\/strong><em> s\u1ebd<\/em>\u00a0v\u1ebd \u0111\u01b0\u1eddng v\u1ea1ch m\u00e0u xanh t\u1eeb c\u00e1c \u00f4 \u0111\u01b0\u1ee3c tham chi\u1ebfu \u0111\u1ebfn \u00f4 c\u00f4ng th\u1ee9c \u0111\u00e3 ch\u1ecdn, nh\u01b0 h\u00ecnh sau:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-trace-precedents.png\" alt=\"Click the Trace Precedents button to show cells that supply data for a selected formula.\" title=\"excel-trace-precedents\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0ph\u00edm t\u1eaft\u00a0<strong><em>Alt + T U T<\/em><\/strong>\u00a0\u0111\u1ec3 \u0111\u01b0\u1eddng n\u00e0y bi\u1ebfn m\u1ea5t.<\/p>\n<p style=\"text-align: justify\"><strong>Trace Dependents \u2013 hi\u1ec3n th\u1ecb c\u00e1c c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 \u0111\u00e3 cho<\/strong><\/p>\n<p style=\"text-align: justify\">N\u00fat\u00a0<strong>Trace Dependents<\/strong>\u00a0ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0\u00a0ph\u00edm t\u1eaft\u00a0<strong><em>Ctrl +\u00a0]<\/em><\/strong>.\u00a0N\u00f3 ch\u1ec9 ra c\u00e1c \u00f4 ph\u1ee5 thu\u1ed9c v\u00e0o \u00f4 \u0111\u00f3, t\u1ee9c l\u00e0 c\u00e1c \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">Trong h\u00ecnh sau, \u00f4 D2 \u0111\u01b0\u1ee3c ch\u1ecdn, c\u00e1c \u0111\u01b0\u1eddng k\u1ebb m\u00e0u xanh ch\u1ec9 t\u1edbi c\u00e1c c\u00f4ng th\u1ee9c c\u00f3 ch\u1ee9a tham chi\u1ebfu D2:<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-trace-dependents.png\" alt=\"click the Trace Dependents button to show formulas that reference the selected cell.\" title=\"excel-trace-dependents\"><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 b\u1eadt t\u00ednh n\u0103ng n\u00e0y l\u00e0 nh\u1ea5p v\u00e0o\u00a0ph\u00edm t\u1eaft\u00a0Alt + T U D\u00a0.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.\u00a0<\/strong>\u0110\u1ec3 \u1ea9n c\u00e1c m\u0169i t\u00ean, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong><em>Remove Arrows<\/em> <\/strong>n\u1eb1m b\u00ean d\u01b0\u1edbi\u00a0<strong><em>Trace Dependents<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><strong>Gi\u00e1m s\u00e1t c\u00f4ng th\u1ee9c v\u00e0 <\/strong><strong>k\u1ebft qu\u1ea3 <\/strong><strong>c\u1ee7a ch\u00fang (Watch Window)<\/strong><\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi b\u1ed9 d\u1eef li\u1ec7u l\u1edbn, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i c\u00e1c c\u00f4ng th\u1ee9c quan tr\u1ecdng nh\u1ea5t trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh v\u00e0 xem c\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00e3 t\u00ednh thay \u0111\u1ed5i khi b\u1ea1n ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u ngu\u1ed3n.\u00a0<strong><em>Watch Window<\/em> <\/strong>c\u1ee7a Excel \u0111\u01b0\u1ee3c t\u1ea1o ra cho m\u1ee5c \u0111\u00edch n\u00e0y.<\/p>\n<p style=\"text-align: justify\"><strong><em>Watch Window<\/em><\/strong>\u00a0s\u1ebd hi\u1ec3n th\u1ecb c\u00e1c thu\u1ed9c t\u00ednh \u00f4, ch\u1eb3ng h\u1ea1n nh\u01b0 t\u00ean b\u1ea3ng t\u00ednh v\u00e0 trang, \u00f4 ho\u1eb7c t\u00ean d\u00e3y n\u1ebfu c\u00f3, \u0111\u1ecba ch\u1ec9 \u00f4, gi\u00e1 tr\u1ecb v\u00e0 c\u00f4ng th\u1ee9c, trong m\u1ed9t c\u1eeda s\u1ed5 ri\u00eang bi\u1ec7t.\u00a0B\u1eb1ng c\u00e1ch n\u00e0y, b\u1ea1n lu\u00f4n nh\u00ecn th\u1ea5y nh\u1eefng d\u1eef li\u1ec7u quan tr\u1ecdng nh\u1ea5t trong nh\u00e1y m\u1eaft, ngay c\u1ea3 khi b\u1ea1n \u0111ang chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c b\u1ea3ng t\u00ednh kh\u00e1c nhau.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/monitor-formulas-watch-window.png\" alt=\"Use Excel's Watch Window to monitor the key formulas in a workbook.\" title=\"monitor-formulas-watch-window\"><\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch <\/strong><strong>th\u00eam c\u00e1c \u00f4 v\u00e0o c\u1eeda s\u1ed5 Watch Window\u00a0<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 hi\u1ec3n th\u1ecb\u00a0<strong><em>Watch Window<\/em><\/strong>\u00a0v\u00e0 th\u00eam c\u00e1c \u00f4 \u0111\u1ec3 theo d\u00f5i, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn (nh\u1eefng) \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n xem.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>M\u1eb9o.\u00a0<\/strong>N\u1ebfu b\u1ea1n mu\u1ed1n theo d\u00f5i t\u1ea5t c\u1ea3 c\u00e1c \u00f4 c\u00f3 c\u00f4ng th\u1ee9c tr\u00ean trang t\u00ednh, h\u00e3y chuy\u1ec3n \u0111\u1ebfn\u00a0tab\u00a0<strong><em>Home\u00a0 &gt;\u00a0Editing<\/em><\/strong><em>\u00a0, <\/em>nh\u1ea5n <strong><em>Find &amp; Replace<\/em><\/strong>, sau \u0111\u00f3 nh\u1ea5p v\u00e0o\u00a0<strong><em>Go To Special<\/em><\/strong><em>, <\/em>v\u00e0 ch\u1ecdn <strong><em>Formulas<\/em><\/strong><em>.<\/em><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Chuy\u1ec3n sang\u00a0<em>tab <\/em><strong><em>Formulas\u00a0 &gt;\u00a0Formula Auditing<\/em><\/strong>, v\u00e0 nh\u1ea5n\u00a0<strong>Watch\u00a0 Window<\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-watch-window-1.png\" alt=\"Use Excel's Watch Window to monitor cells with important formulas\" title=\"excel-watch-window-1\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li><strong><em>Watch Window\u00a0<\/em><\/strong>s\u1ebd xu\u1ea5t hi\u1ec7n v\u00e0 b\u1ea1n nh\u1ea5p v\u00e0o\u00a0<strong><em>Add Watch\u2026<\/em><\/strong>\u00a0.<\/li>\n<\/ol>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-add-watch.png\" alt=\"Click the Add Watch\u2026 button to add a cell to the Watch Window.\" title=\"excel-add-watch\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd <\/strong><strong>Watch Window<\/strong>:<\/p>\n<ul style=\"text-align: justify\">\n<li>B\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 th\u00eam m\u1ed9t l\u1ea7n xem cho m\u1ed7i \u00f4.<\/li>\n<li>C\u00e1c \u00f4 c\u00f3 tham chi\u1ebfu b\u00ean ngo\u00e0i cho c\u00e1c b\u1ea3ng t\u00ednh kh\u00e1c ch\u1ec9 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb khi c\u00e1c b\u1ea3ng t\u00ednh \u0111\u00f3 \u0111ang m\u1edf.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong>C\u00e1ch <\/strong><strong>lo\u1ea1i b\u1ecf c\u00e1c \u00f4 t\u1eeb Watch Window<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 x\u00f3a c\u00e1c \u00f4 nh\u1ea5t \u0111\u1ecbnh kh\u1ecfi\u00a0<strong><em>Watch Window<\/em><\/strong>, h\u00e3y ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n x\u00f3a v\u00e0 nh\u1ea5p v\u00e0o <strong><em>Delete Watch<\/em><\/strong>:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-delete-watch.png\" alt=\"Click the Delete Watch button to remove a cell from the Watch Window.\" title=\"excel-delete-watch\"><br \/>\n<strong>M\u1eb9o.\u00a0<\/strong>\u0110\u1ec3 x\u00f3a nhi\u1ec1u \u00f4 m\u1ed9t l\u1ea7n, nh\u1ea5n\u00a0Ctrl\u00a0v\u00e0 ch\u1ecdn c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n x\u00f3a.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch<\/strong><strong> di chuy\u1ec3n v\u00e0 c\u1eaft b\u1edbt Watch Window<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ed1ng nh\u01b0 b\u1ea5t k\u1ef3 thanh c\u00f4ng c\u1ee5 n\u00e0o,\u00a0<strong><em>Watch Window<\/em><\/strong> c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c di chuy\u1ec3n ho\u1eb7c g\u1eafn l\u00ean ph\u00eda tr\u00ean, b\u00ean d\u01b0\u1edbi, b\u00ean tr\u00e1i, ho\u1eb7c b\u00ean ph\u1ea3i c\u1ee7a m\u00e0n h\u00ecnh.\u00a0\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, ch\u1ec9 c\u1ea7n k\u00e9o\u00a0<strong><em>Watch Window<\/em><\/strong>\u00a0b\u1eb1ng chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: N\u1ebfu b\u1ea1n g\u1eafn<em> <strong>Watch<\/strong><\/em><strong>\u00a0<em>Window <\/em><\/strong>xu\u1ed1ng d\u01b0\u1edbi c\u00f9ng, n\u00f3 s\u1ebd lu\u00f4n hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi c\u00e1c tab c\u1ee7a b\u1ea3ng v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra c\u00e1c c\u00f4ng th\u1ee9c ch\u00ednh m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i di chuy\u1ec3n l\u00ean xu\u1ed1ng c\u00e1c \u00f4 c\u00f4ng th\u1ee9c nhi\u1ec1u l\u1ea7n.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/docked-watch-window.png\" alt=\"Watch Window docked to the bottom of the screen\" title=\"docked-watch-window\"><br \/>\nCu\u1ed1i c\u00f9ng, t\u00f4i mu\u1ed1n chia s\u1ebb m\u1ed9t v\u00e0i m\u1eb9o kh\u00e1c c\u00f3 th\u1ec3 h\u1eefu \u00edch cho vi\u1ec7c \u0111\u00e1nh gi\u00e1 v\u00e0 s\u1eeda l\u1ed7i c\u00e1c c\u00f4ng th\u1ee9c Excel c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o s\u1eeda l\u1ed7i c\u00f4ng th\u1ee9c:<\/strong><\/p>\n<ol>\n<li style=\"text-align: justify\">\u0110\u1ec3 xem to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c d\u00e0i m\u00e0 kh\u00f4ng ch\u1ed3ng ch\u00e9o n\u1ed9i dung c\u1ee7a \u00f4 l\u00e2n c\u1eadn, s\u1eed d\u1ee5ng thanh c\u00f4ng th\u1ee9c.\u00a0N\u1ebfu c\u00f4ng th\u1ee9c qu\u00e1 d\u00e0i \u0111\u1ec3 kh\u1edbp v\u1edbi thanh c\u00f4ng th\u1ee9c m\u1eb7c \u0111\u1ecbnh, h\u00e3y m\u1edf r\u1ed9ng n\u00f3 b\u1eb1ng c\u00e1ch nh\u1ea5n\u00a0<em><strong>Ctrl + Shift + U<\/strong><\/em>\u00a0ho\u1eb7c k\u00e9o khung d\u01b0\u1edbi c\u1ee7a n\u00f3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng con chu\u1ed9t\u00a0.<\/li>\n<li style=\"text-align: justify\">\u0110\u1ec3 xem t\u1ea5t c\u1ea3 c\u00f4ng th\u1ee9c tr\u00ean trang thay v\u00ec k\u1ebft qu\u1ea3 c\u1ee7a ch\u00fang, nh\u1ea5n\u00a0<strong><em>Ctrl +`\u00a0<\/em><\/strong>ho\u1eb7c nh\u1ea5p v\u00e0o n\u00fat<em>\u00a0<strong>Show Formulas<\/strong> <\/em>\u00a0tr\u00ean\u00a0tab\u00a0<strong><em>Formulas.<\/em><\/strong><\/li>\n<\/ol>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u00a0 \u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table \u2026<\/p>\n<p>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<\/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\/2025\/01\/vba101_92019-nho-54.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11660,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11659","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\/11659","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=11659"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11659\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11660"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}