{"id":27752,"date":"2021-07-27T14:57:07","date_gmt":"2021-07-27T07:57:07","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=27752"},"modified":"2021-11-12T16:19:11","modified_gmt":"2021-11-12T09:19:11","slug":"co-dinh-dong-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/co-dinh-dong-trong-excel\/","title":{"rendered":"C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n b\u1ea1n n\u00ean bi\u1ebft"},"content":{"rendered":"

Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 tin h\u1ecdc c\u1ea7n thi\u1ebft \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c, n\u1ebfu kh\u1ed1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u qu\u00e1 l\u1edbn, vi\u1ec7c di chuy\u1ec3n chu\u1ed9t v\u1ec1 ph\u00eda d\u01b0\u1edbi s\u1ebd khi\u1ebfn cho nh\u1eefng c\u1ed9t b\u00ean tr\u00ean kh\u00f4ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb, trong \u0111\u00f3 bao g\u1ed3m c\u1ea3 nh\u1eefng c\u1ed9t ti\u00eau \u0111\u1ec1. V\u1eady n\u00ean, vi\u1ec7c c\u1ed1 \u0111\u1ecbnh (hay c\u00f2n g\u1ecdi l\u00e0 \u0111\u00f3ng b\u0103ng) nh\u1eefng d\u00f2ng quan tr\u1ecdng \u0111\u1ec3 ti\u1ec7n theo d\u00f5i l\u00e0 m\u1ed9t v\u1ea5n \u0111\u1ec1 m\u00e0 m\u1ecdi ng\u01b0\u1eddi r\u1ea5t quan t\u00e2m. Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i ai m\u1edbi ti\u1ebfp x\u00fac v\u1edbi Excel c\u0169ng bi\u1ebft \u0111\u1ebfn k\u1ef9 n\u0103ng n\u00e0y. D\u01b0\u1edbi \u0111\u00e2y, Ben Computer s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel<\/a><\/strong><\/span> c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n.<\/p>\n

C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel \u0111\u01a1n gi\u1ea3n<\/strong><\/span><\/h2>\n

C\u00e1ch c\u1ed1 \u0111\u1ecbnh m\u1ed9t d\u00f2ng tr\u00ean Excel\u00a0<\/strong><\/span><\/h3>\n

Th\u00f4ng th\u01b0\u1eddng d\u00f2ng \u0111\u1ea7u ti\u00ean trong b\u1ea3ng Excel s\u1ebd ch\u1ee9a nh\u1eefng th\u00f4ng tin ti\u00eau \u0111\u1ec1 chung, n\u1ebfu sheet d\u1eef li\u1ec7u d\u00e0i th\u00ec khi k\u00e9o xu\u1ed1ng ph\u00eda d\u01b0\u1edbi d\u00f2ng \u0111\u1ea7u s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb v\u00e0 \u0111i\u1ec1u n\u00e0y s\u1ebd khi\u1ebfn b\u1ea1n b\u1ea5t ti\u1ec7n trong vi\u1ec7c theo d\u00f5i. \u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh m\u1ed9t d\u00f2ng \u0111\u1ea7u ti\u00ean trong b\u1ea3ng, c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y:<\/p>\n

Tr\u00ean thanh menu, ch\u1ecdn View<\/strong> =><\/strong> ch\u1ecdn Freeze Panes => <\/strong>ch\u1ecdn Freeze Top Row<\/strong><\/p>\n

Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh \u0111\u01b0\u1ee3c d\u00f2ng \u0111\u1ea7u ti\u00ean.<\/p>\n

\"C\u1ed1<\/p>\n

\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong excel b\u1ea1n ch\u1ecdn Freeze Top Row<\/strong><\/em><\/p>\n

C\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng tr\u00ean Excel<\/strong><\/span><\/h3>\n

N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1ec9 mu\u1ed1n c\u1ed1 \u0111\u1ecbnh nguy\u00ean d\u00f2ng \u0111\u1ea7u m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng, c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n c\u0169ng r\u1ea5t \u0111\u01a1n gi\u1ea3n:<\/p>\n

B\u01b0\u1edbc 1:<\/em><\/strong> \u0110\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a d\u00f2ng ngay b\u00ean d\u01b0\u1edbi d\u00f2ng b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh 5 d\u00f2ng \u0111\u1ea7u, h\u00e3y \u0111\u1eb7t tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 \u0111\u1ea7u d\u00f2ng th\u1ee9 6.<\/p>\n

B\u01b0\u1edbc 2:<\/em><\/strong> Tr\u00ean thanh menu, ch\u1ecdn View =><\/strong> ch\u1ecdn Freeze Panes<\/strong>.<\/p>\n

V\u1edbi 2 b\u01b0\u1edbc nh\u01b0 tr\u00ean, t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng tr\u01b0\u1edbc d\u00f2ng b\u1ea1n \u0111\u1eb7t tr\u1ecf chu\u1ed9t s\u1ebd \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh. Khi b\u1ea1n l\u01b0\u1edbt s\u00e2u xu\u1ed1ng ph\u00eda d\u01b0\u1edbi, nh\u1eefng d\u00f2ng \u0111\u00f3 v\u1eabn hi\u1ec3n th\u1ecb, kh\u00f4ng b\u1ecb \u1ea9n nh\u01b0 khi ch\u01b0a c\u1ed1 \u0111\u1ecbnh.<\/p>\n

\"c\u1ed1<\/p>\n

C\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng tr\u00ean excel<\/em><\/p>\n

C\u00e1ch x\u00f3a c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel\u00a0<\/strong><\/span><\/h3>\n

N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n b\u1ecf c\u1ed1 \u0111\u1ecbnh m\u1ed9t d\u00f2ng hay m\u1ed9t c\u1ed9t n\u00e0o \u0111\u00f3, c\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

Tr\u00ean thanh menu, ch\u1ecdn View<\/strong> => ch\u1ecdn Freeze Panes =><\/strong> ch\u1ecdn Unfreeze Panes.<\/strong><\/p>\n

\"X\u00f3a<\/p>\n

N\u1ebfu mu\u1ed1n x\u00f3a c\u1ed1 \u0111\u1ecbnh d\u00f2ng b\u1ea1n ch\u1ecdn Unfreeze Panes<\/em><\/p>\n

Xem th\u00eam: C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t trong Excel<\/a><\/span><\/strong><\/p><\/blockquote>\n

C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/strong><\/span><\/h2>\n

Trong Excel, ngo\u00e0i vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng, nhi\u1ec1u ng\u01b0\u1eddi c\u0169ng r\u1ea5t quan t\u00e2m \u0111\u1ebfn v\u1ea5n \u0111\u1ec1 c\u1ed1 \u0111\u1ecbnh c\u1ed9t. C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t c\u0169ng g\u1ea7n gi\u1ed1ng v\u1edbi c\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng.<\/p>\n

N\u1ebfu mu\u1ed1n c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean, ch\u1ecdn View<\/strong> =><\/strong> ch\u1ecdn Freeze First Column.<\/strong><\/p>\n

\"c\u1ed1<\/p>\n

Ch\u1ecdn Freeze First Column \u0111\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t tr\u00ean Excel<\/em><\/p>\n

Kh\u00f4ng ch\u1ec9 c\u1ed1 \u0111\u1ecbnh \u0111\u01b0\u1ee3c nhi\u1ec1u d\u00f2ng trong Excel m\u00e0 ngo\u00e0i ra c\u00e1c b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh \u0111\u01b0\u1ee3c nhi\u1ec1u c\u1ed9t, thao t\u00e1c c\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng, ch\u1ec9 kh\u00e1c \u1edf v\u1ecb tr\u00ed \u0111\u1eb7t con tr\u1ecf chu\u1ed9t. Thay v\u00ec \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a d\u00f2ng ph\u00eda d\u01b0\u1edbi d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh, c\u00e1c b\u1ea1n \u0111\u1eb7t v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t k\u1ebf b\u00ean ph\u1ea3i nh\u1eefng c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh. Ti\u1ebfp theo, tr\u00ean thanh menu, ch\u1ecdn View<\/strong> =><\/strong> ch\u1ecdn Freeze Panes<\/strong>. Khi \u0111\u00f3, t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t ph\u00eda tr\u01b0\u1edbc s\u1ebd \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh.<\/p>\n

V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh 2 c\u1ed9t \u0111\u1ea7u, h\u00e3y \u0111\u1eb7t con tr\u1ecf chu\u1ed9t v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t th\u1ee9 3.<\/p>\n

==> Note: <\/span><\/strong>N\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh c\u1ea3 d\u00f2ng v\u00e0 c\u1ed9t trong Excel, b\u1ea1n l\u1ea7n l\u01b0\u1ee3t th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c tr\u00ean \u0111\u1ed1i v\u1edbi vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t l\u00e0 \u0111\u01b0\u1ee3c.<\/em><\/p>\n

Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ea5t c\u1ea3 nh\u1eefng thao t\u00e1c li\u00ean quan \u0111\u1ebfn vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel. Nh\u1eefng ai \u0111ang l\u00e0 d\u00e2n v\u0103n ph\u00f2ng th\u00ec tuy\u1ec7t \u0111\u1ed1i kh\u00f4ng th\u1ec3 b\u1ecf qua nh\u1eefng k\u0129 n\u0103ng c\u01a1 b\u1ea3n tr\u00ean. N\u1ebfu c\u00e1c b\u1ea1n c\u00f3 b\u1ea5t c\u1ee9 chia s\u1ebb g\u00ec v\u1ec1 c\u00e1ch l\u00e0m c\u1ee7a m\u00ecnh ho\u1eb7c \u0111\u00f3ng g\u00f3p th\u00eam v\u1ec1 v\u1ea5n \u0111\u1ec1 c\u1ed1 \u0111\u1ecbnh, \u0111\u1eebng ng\u1ea7n ng\u1ea1i m\u00e0 h\u00e3y comment xu\u1ed1ng ph\u00eda d\u01b0\u1edbi \u0111\u1ec3 th\u1ea3o lu\u1eadn c\u00f9ng Ben Computer nh\u00e9!<\/p>\n

C\u00f3 th\u1ec3 b\u1ea1n s\u1ebd th\u00edch: H\u00e0m chuy\u1ec3n s\u1ed1 th\u00e0nh ch\u1eef trong Excel<\/a><\/strong><\/span><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 tin h\u1ecdc c\u1ea7n thi\u1ebft \u0111\u1ed1i v\u1edbi d\u00e2n v\u0103n ph\u00f2ng. Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c, n\u1ebfu kh\u1ed1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u qu\u00e1 l\u1edbn, vi\u1ec7c di chuy\u1ec3n chu\u1ed9t v\u1ec1 ph\u00eda d\u01b0\u1edbi s\u1ebd khi\u1ebfn cho nh\u1eefng c\u1ed9t b\u00ean tr\u00ean kh\u00f4ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb, trong \u0111\u00f3 bao g\u1ed3m c\u1ea3 nh\u1eefng c\u1ed9t ti\u00eau \u0111\u1ec1. V\u1eady n\u00ean, […]<\/p>\n","protected":false},"author":25,"featured_media":27753,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[11],"tags":[],"class_list":["post-27752","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-van-phong"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/27752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=27752"}],"version-history":[{"count":2,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/27752\/revisions"}],"predecessor-version":[{"id":43082,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/27752\/revisions\/43082"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/27753"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=27752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=27752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=27752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}