{"id":7233,"date":"2025-12-29T20:42:51","date_gmt":"2025-12-29T13:42:51","guid":{"rendered":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/?p=7233"},"modified":"2025-12-30T13:10:57","modified_gmt":"2025-12-30T06:10:57","slug":"danh-so-thu-tu-tu-dong-cap-nhat-khi-xoa-dong-trong-excel","status":"publish","type":"post","link":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/danh-so-thu-tu-tu-dong-cap-nhat-khi-xoa-dong-trong-excel\/","title":{"rendered":"C\u00c1CH \u0110\u00c1NH S\u1ed0 TH\u1ee8 T\u1ef0 T\u1ef0 \u0110\u1ed8NG C\u1eacP NH\u1eacT KHI X\u00d3A D\u00d2NG TRONG EXCEL"},"content":{"rendered":"

C\u00e1ch t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/strong><\/h3>\n

 <\/p>\n

B\u01b0\u1edbc 1:<\/strong>\u00a0B\u1ea1n m\u1edf\u00a0file Excel<\/strong>\u00a0m\u00ecnh c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 l\u00ean.<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

B\u01b0\u1edbc 2:<\/strong>\u00a0\u1ede m\u1ee5c\u00a0\u0111\u00e1nh STT, b\u1ea1n nh\u1eadp h\u00e0m =ROW()-1 (-1 n\u1ebfu b\u1ea1n b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng 2, -2 n\u1ebfu b\u1ea1n b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng 3).<\/strong><\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

B\u01b0\u1edbc 3:<\/strong>\u00a0B\u1ea1n k\u00e9o t\u1eeb\u00a0v\u1ecb tr\u00ed h\u00e0m v\u1eeba nh\u1eadp xu\u1ed1ng<\/strong>\u00a0\u0111\u1ebfn v\u1ecb tr\u00ed m\u00e0 b\u1ea1n mong mu\u1ed1n.<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

B\u01b0\u1edbc 4:<\/strong>\u00a0Gi\u1edd b\u1ea1n \u0111\u00e3 \u0111\u00e1nh \u0111\u01b0\u1ee3c s\u1ed1 th\u1ee9 t\u1ef1. N\u1ebfu b\u1ea1n mu\u1ed1n\u00a0x\u00f3a 1 h\u00e0ng \u1edf c\u1ed9t n\u00e0y<\/strong>, b\u1ea1n ch\u1ec9 vi\u1ec7c b\u1ea5m\u00a0chu\u1ed9t ph\u1ea3i v\u00e0o s\u1ed1 th\u1ee9 t\u1ef1 \u1edf h\u00e0ng b\u1ea1n c\u1ea7n x\u00f3a r\u1ed3i<\/strong>\u00a0ch\u1ecdn\u00a0Delete<\/strong>.<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

<\/div>\n

B\u01b0\u1edbc 5:<\/strong>\u00a0Gi\u1edd b\u1ea1n \u0111\u00e3 th\u1ea5y h\u00e0ng b\u1ea1n c\u1ea7n x\u00f3a \u0111\u00e3 bi\u1ebfn m\u1ea5t v\u00e0\u00a0Excel t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt<\/strong>\u00a0l\u1ea1i c\u00e1c s\u1ed1 th\u1ee9 t\u1ef1.<\/p>\n

 <\/p>\n

<\/div>\n
\"\"<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
=> V\u1eady l\u00e0 ch\u00fang ta kh\u00f4ng c\u00f2n lo khi x\u00f3a d\u00f2ng ph\u1ea3i nh\u1eadp l\u1ea1i stt n\u1eefa.<\/div>\n","protected":false},"excerpt":{"rendered":"

C\u00e1ch t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt s\u1ed1 th\u1ee9 t\u1ef1 trong Excel   B\u01b0\u1edbc 1:\u00a0B\u1ea1n m\u1edf\u00a0file Excel\u00a0m\u00ecnh c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/7233"}],"collection":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/comments?post=7233"}],"version-history":[{"count":3,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/7233\/revisions"}],"predecessor-version":[{"id":7256,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/posts\/7233\/revisions\/7256"}],"wp:attachment":[{"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/media?parent=7233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/categories?post=7233"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/taingo.ddns.net\/tinhocnhatrang\/wp-json\/wp\/v2\/tags?post=7233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}