{"id":13470,"date":"2020-03-25T02:19:47","date_gmt":"2020-03-25T02:19:47","guid":{"rendered":"https:\/\/hocvienit.vn\/?p=13470"},"modified":"2024-07-03T14:36:52","modified_gmt":"2024-07-03T07:36:52","slug":"huong-dan-to-mau-tu-dong-cho-cac-o-cong-thuc-tren-excel","status":"publish","type":"post","link":"https:\/\/hocvienit.vn\/?p=13470","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng cho c\u00e1c \u00f4 c\u00f4ng th\u1ee9c tr\u00ean Excel"},"content":{"rendered":"

Ch\u00fang ta \u0111\u00e3 kh\u00f4ng c\u00f2n xa l\u1ea1 v\u1edbi c\u00e1c h\u00e0m t\u00ednh to\u00e1n trong Excel r\u1ed3i \u0111\u00fang kh\u00f4ng n\u00e0o! Tuy nhi\u00ean trong m\u1ed9t b\u1ea3ng t\u00ednh d\u00e0i c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c nhau th\u00ec vi\u1ec7c t\u00ecm ki\u1ebfm c\u0169ng nh\u01b0 ch\u1ec9nh s\u1eeda l\u00e0 v\u00f4 c\u00f9ng kh\u00f3 kh\u0103n. Cho n\u00ean, b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng cho c\u00e1c \u00f4 c\u00f4ng th\u1ee9c nh\u01b0 sau.<\/span><\/p>\n

\"H\u01b0\u1edbng
H\u01b0\u1edbng d\u1eabn t\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng cho c\u00e1c \u00f4 c\u00f4ng th\u1ee9c tr\u00ean Excel<\/figcaption><\/figure>\n

C\u00e1ch 1: T\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng cho c\u00e1c \u00f4 c\u00f4ng th\u1ee9c<\/strong><\/h2>\n

C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n

B\u01b0\u1edbc 1:<\/strong> B\u1ea1n m\u1edf ph\u1ea7n m\u1ec1m Excel.<\/span><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Sau \u0111\u00f3, b\u1ea1n chuy\u1ec3n sang tab Developer<\/strong> r\u1ed3i nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Visual Basic<\/strong>.<\/span><\/p>\n

L\u01b0u \u00fd: Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n kh\u00f4ng th\u1ea5y tab Developer th\u00ec b\u1ea1n c\u00f3 th\u1ec3 th\u00eam tab Developer b\u1eb1ng c\u00e1ch: Nh\u1ea5n v\u00e0o tab File > ch\u1ecdn Options > chuy\u1ec3n xu\u1ed1ng m\u1ee5c Customize Ribbon > \u0111\u00e1nh t\u00edch ch\u1ecdn v\u00e0o Developer trong ph\u1ea7n Main Tabs > nh\u1ea5n OK l\u00e0 xong.<\/span><\/i><\/p>\n

B\u01b0\u1edbc 3:<\/strong> Trong giao di\u1ec7n m\u1edbi hi\u1ec7n l\u00ean, b\u1ea1n nh\u1ea5n v\u00e0o Insert<\/strong> v\u00e0 ch\u1ecdn Module<\/strong>.<\/span><\/p>\n

\"T\u00f4
T\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng cho c\u00e1c \u00f4 c\u00f4ng th\u1ee9c<\/figcaption><\/figure>\n

B\u01b0\u1edbc 4:<\/strong> T\u1ea1i \u0111\u00e2y, b\u1ea1n copy v\u00e0 paste d\u00f2ng code sau \u0111\u1ec3 t\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng cho b\u1ea3ng t\u00ednh:<\/span><\/p>\n

Sub SelectFormulaCells()<\/strong><\/p>\n

\u00a0Dim Rng As Range<\/strong><\/p>\n

\u00a0Dim WorkRng As Range<\/strong><\/p>\n

\u00a0On Error Resume Next<\/strong><\/p>\n

\u00a0xTitleId = \u201cKutoolsforExcel\u201d<\/strong><\/p>\n

\u00a0Set WorkRng = Application.Selection<\/strong><\/p>\n

\u00a0Set WorkRng = Application.InputBox(\u201cRange\u201d, xTitleId, WorkRng.Address, Type:=8)<\/strong><\/p>\n

\u00a0Set WorkRng = WorkRng.SpecialCells(xlCellTypeFormulas, 23)<\/strong><\/p>\n

\u00a0Application.ScreenUpdating = False<\/strong><\/p>\n

\u00a0For Each Rng In WorkRng<\/strong><\/p>\n

\u00a0Rng.Interior.ColorIndex = 40<\/strong><\/p>\n

\u00a0Next<\/strong><\/p>\n

\u00a0Application.ScreenUpdating = True<\/strong><\/p>\n

\u00a0End Sub<\/strong><\/p>\n

L\u01b0u \u00fd: D\u00f2ng m\u00e3 \u201c Rng.Interior.ColorIndex = 40\u201d \u0111\u1ec3 ch\u1ec9 m\u00e0u s\u1eafc m\u00e0 b\u1ea1n mu\u1ed1n t\u00f4 m\u00e0u cho c\u00f4ng th\u1ee9c. Ch\u00ednh v\u00ec v\u1eady n\u1ebfu b\u1ea1n kh\u00f4ng th\u00edch m\u00e0 v\u00e0ng nh\u1ea1t (m\u00e3 m\u00e0u 40) th\u00ec c\u00f3 th\u1ec3 chuy\u1ec3n sang m\u00e3 m\u00e0u kh\u00e1c nh\u00e9!<\/span><\/i><\/p>\n

B\u01b0\u1edbc 5:<\/strong> Ti\u1ebfp \u0111\u1ebfn, b\u1ea1n chuy\u1ec3n v\u1ec1 c\u1eeda s\u1ed5 Excel \u0111\u1ec3 ch\u1ecdn khung \u00e1p d\u1ee5ng m\u00e3 v\u00e0 nh\u1ea5n Enter<\/strong> l\u00e0 xong.<\/span><\/p>\n

 <\/p>\n

C\u00e1ch 2: Nh\u1eadn bi\u1ebft nhanh c\u00e1c \u00f4 c\u00f4ng th\u1ee9c<\/strong><\/h2>\n

N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n \u0111\u00e1nh d\u1ea5u c\u00e1c \u00f4 c\u00f4ng th\u1ee9c m\u00e0 ch\u1ec9 mu\u1ed1n nh\u1eadn bi\u1ebft nhanh \u0111\u1ec3 ch\u1ec9nh s\u1eeda lu\u00f4n th\u00ec b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n

B\u01b0\u1edbc 1:<\/strong> Tr\u00ean Excel, b\u1ea1n ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u r\u1ed3i nh\u1ea5n F5<\/strong>.<\/span><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Trong c\u1eeda s\u1ed5 Go To<\/strong>, b\u1ea1n nh\u1ea5n v\u00e0o n\u00fat Special\u2026<\/strong><\/span><\/p>\n

B\u01b0\u1edbc 3:<\/strong> Ti\u1ebfp theo, b\u1ea1n t\u00edch ch\u1ecdn v\u00e0o \u00f4 Formulas<\/strong> v\u00e0 nh\u1ea5n OK<\/strong>.<\/span><\/p>\n

Gi\u1edd \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c nh\u1eefng \u00f4 c\u00f4ng th\u1ee9c r\u1ed3i \u0111\u1ea5y.<\/span><\/p>\n

 <\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 chia s\u1ebb c\u1ee7a HOCVIENiT.vn v\u1ec1 h\u01b0\u1edbng d\u1eabn t\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng cho c\u00e1c \u00f4 c\u00f4ng th\u1ee9c tr\u00ean Excel. Hi v\u1ecdng ch\u00fang gi\u00fap \u00edch cho b\u1ea1n. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng!<\/span><\/p>\n

N\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 th\u1eafc m\u1eafc n\u00e0o v\u1ec1 c\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan \u0111\u1ebfn m\u00e1y t\u00ednh th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft n\u00e0y. V\u00e0 \u0111\u1eebng qu\u00ean \u0111\u00f3n \u0111\u1ecdc c\u00e1c b\u00e0i vi\u1ebft m\u1edbi nh\u1ea5t c\u1ee7a HOCVIENiT.vn nh\u00e9.<\/span><\/p>\n

C\u00e1c b\u00e0i vi\u1ebft li\u00ean quan:<\/p>\n

B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch xu\u1ed1ng d\u00f2ng trong Excel ch\u01b0a?<\/a><\/p>\n

S\u1eeda l\u1ed7i Protected view trong Excel<\/a><\/p>\n

Th\u1ee7 thu\u1eadt s\u1eeda l\u1ed7i file excel b\u1ecb m\u1ea5t \u0111\u1ecbnh d\u1ea1ng<\/a><\/p><\/blockquote>\n

M\u1ecdi chi ti\u1ebft xin vui l\u00f2ng li\u00ean h\u1ec7:<\/i><\/p>\n

C\u00d4NG TY C\u1ed4 PH\u1ea6N H\u1eccC VI\u1ec6N IT<\/strong>
\nMST: 0108733789<\/strong>
\nT\u1ed5ng \u0111\u00e0i h\u1ed7 tr\u1ee3: 024 3566 8686 \u2013 Hotline: 0981 223 001<\/strong>
\nFacebook:<\/strong>\u00a0www.fb.com\/hocvienit<\/a><\/p>\n

\u0110\u0103ng k\u00fd k\u00eanh Youtube \u0111\u1ec3 theo d\u00f5i c\u00e1c b\u00e0i h\u1ecdc c\u1ee7a Hu\u1ea5n luy\u1ec7n vi\u00ean t\u1ed1t nh\u1ea5t:<\/strong>\u00a0http:\/\/bit.ly\/Youtube_HOCVIENiT<\/a><\/p>\n

Tham gia c\u1ed9ng \u0111\u1ed3ng H\u1ecdc vi\u1ec7n IT.vn t\u1ea1i:<\/strong>\u00a0https:\/\/www.facebook.com\/groups\/www.hocvienit.vn\/<\/a><\/p>\n

Tr\u1ee5 s\u1edf H\u00e0 N\u1ed9i:<\/strong>\u00a0S\u1ed1 8 ng\u00f5 117 Th\u00e1i H\u00e0, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i<\/p>\n

H\u1ed3 Ch\u00ed Minh:<\/strong>\u00a0S\u1ed1 283\/45 C\u00e1ch M\u1ea1ng Th\u00e1ng T\u00e1m, Ph\u01b0\u1eddng 12, Qu\u1eadn 10,\u00a0TP.HCM
\nH\u1ea3i Ph\u00f2ng:<\/strong>\u00a0S\u1ed1 94 Qu\u00e1n Nam, L\u00ea Ch\u00e2n, H\u1ea3i Ph\u00f2ng<\/p>\n

Th\u00e1i Nguy\u00ean:<\/strong>\u00a0S\u1ed1 297 L\u01b0\u01a1ng Ng\u1ecdc Quy\u1ebfn, TP. Th\u00e1i Nguy\u00ean
\nH\u1ecdc vi\u1ec7n IT.vn \u2013 Truy\u1ec1n ngh\u1ec1 th\u1ef1c t\u1ebf c\u00f9ng b\u1ea1n \u0111\u1ebfn th\u00e0nh c\u00f4ng!\u00a0<\/i><\/strong><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Ch\u00fang ta \u0111\u00e3 kh\u00f4ng c\u00f2n xa l\u1ea1 v\u1edbi c\u00e1c h\u00e0m t\u00ednh to\u00e1n trong Excel r\u1ed3i \u0111\u00fang kh\u00f4ng n\u00e0o! Tuy nhi\u00ean trong m\u1ed9t b\u1ea3ng t\u00ednh d\u00e0i c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c nhau th\u00ec vi\u1ec7c t\u00ecm ki\u1ebfm c\u0169ng nh\u01b0 ch\u1ec9nh s\u1eeda l\u00e0 v\u00f4 c\u00f9ng kh\u00f3 kh\u0103n. Cho n\u00ean, b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u00f4 m\u00e0u t\u1ef1 \u0111\u1ed9ng cho c\u00e1c \u00f4 c\u00f4ng th\u1ee9c nh\u01b0 sau.<\/p>\n","protected":false},"author":95,"featured_media":13473,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[96,94],"tags":[482],"_links":{"self":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/13470"}],"collection":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/users\/95"}],"replies":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13470"}],"version-history":[{"count":0,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/posts\/13470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=\/wp\/v2\/media\/13473"}],"wp:attachment":[{"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hocvienit.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}