{"id":8586,"date":"2021-08-23T12:19:42","date_gmt":"2021-08-23T05:19:42","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=8586"},"modified":"2021-08-23T12:19:42","modified_gmt":"2021-08-23T05:19:42","slug":"co-dinh-cac-hang-trong-excel","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/co-dinh-cac-hang-trong-excel\/","title":{"rendered":"C\u1ed1 \u0111\u1ecbnh c\u00e1c h\u00e0ng trong Excel"},"content":{"rendered":"

Khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c trang t\u00ednh Excel, b\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y v\u00f4 c\u00f9ng kh\u00f3 ch\u1ecbu m\u1ed7i khi k\u00e9o chu\u1ed9t s\u1ebd l\u00e0m m\u1ea5t ti\u00eau \u0111\u1ec1 ho\u1eb7c c\u00e1c h\u00e0ng ch\u1ee9a nh\u1eefng n\u1ed9i dung quan tr\u1ecdng. Trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn t\u00ednh n\u0103ng c\u1ed1 \u0111\u1ecbnh h\u00e0ng. V\u1eady c\u00e1ch c\u1ed1 \u0111\u1ecbnh h\u00e0ng trong Excel \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o, h\u00e3y c\u00f9ng\u00a0 tham kh\u1ea3o c\u00e1c n\u1ed9i dung th\u00f4ng qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y nh\u00e9.<\/p>\n

1. C\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ea7u ti\u00ean trong Excel<\/strong><\/h3>\n

\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh h\u00e0ng \u0111\u1ea7u ti\u00ean trong Excel, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong>\u00a0M\u1edf trang t\u00ednh Excel c\u00f3 ch\u1ee9a h\u00e0ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh. Tr\u00ean thanh c\u00f4ng c\u1ee5, b\u1ea1n ch\u1ecdnView<\/strong>\u00a0-> ch\u1ecdn ti\u1ebfp\u00a0Freeze Panes.<\/strong>\u00a0Cu\u1ed1i c\u00f9ng ch\u1ecdn\u00a0Freeze Top Row<\/strong><\/p>\n

\"C\u00e1ch<\/strong><\/p>\n

1.1<\/strong><\/p>\n

B\u01b0\u1edbc 2:<\/strong>L\u00fac n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng nh\u1eadn th\u1ea5y c\u00e1c h\u00e0ng \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng \u0111\u01b0\u1eddng k\u1ebb \u0111en \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c \u0111\u01b0\u1eddng k\u1ebb t\u1ea1i c\u00e1c h\u00e0ng kh\u00e1c trong b\u1ea3ng t\u0129nh Excel. V\u1eady l\u00e0 c\u00e1c b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh xong thao t\u00e1c c\u1ed1 \u0111\u1ecbnh h\u00e0ng \u0111\u1ea7u ti\u00ean trong Excel v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n r\u1ed3i nh\u00e9.<\/p>\n

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

1.2<\/strong><\/p>\n

C\u1ed1 \u0111\u1ecbnh nhi\u1ec1u h\u00e0ng trong Excel<\/strong><\/h3>\n

\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u h\u00e0ng trong Excel, b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:
\nB\u01b0\u1edbc 1:<\/strong>\u00a0M\u1edf trang t\u00ednh Excel v\u00e0 l\u1ef1a ch\u1ecdn nh\u00f3m h\u00e0ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/p>\n

Ti\u1ebfp theo b\u1ea1n \u1ea5n chu\u1ed9t tr\u00e1i v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a h\u00e0ng n\u1eb1m ph\u00eda d\u01b0\u1edbi nh\u00f3m h\u00e0ng m\u00e0 b\u1ea1n c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/p>\n

V\u00ed d\u1ee5: Nh\u01b0 m\u00f4 t\u1ea3 trong h\u00ecnh \u1ea3nh m\u00e0 Unica cung c\u1ea5p, b\u1ea1n mu\u1ed1n nh\u00f3m 2 h\u00e0ng 1 2 trong trang t\u00ednh Excel, b\u1ea1n d\u00f9ng chu\u1ed9t tr\u00e1i v\u00e0 ch\u1ecdn \u00f4\u00a0A3<\/strong>.<\/p>\n

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

2.1<\/strong><\/p>\n

B\u01b0\u1edbc 2:<\/strong>\u00a0Tr\u00ean thanh c\u00f4ng c\u1ee5 Excel, b\u1ea1n chon\u00a0View<\/strong>\u00a0-> ti\u1ebfp t\u1ee5c ch\u1ecdnFreeze Panes<\/strong>-> v\u00e0 ch\u1ecdn ti\u1ebfp\u00a0Freeze Panes.<\/strong><\/p>\n

\"C\u00e1ch<\/strong><\/p>\n

2.2<\/strong><\/p>\n

B\u01b0\u1edbc 3:<\/strong>\u00a0L\u00fac n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng nh\u1eadn th\u1ea5y c\u00e1c nh\u00f3m h\u00e0ng \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng \u0111\u01b0\u1eddng k\u1ebb \u0111en \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c \u0111\u01b0\u1eddng k\u1ebb t\u1ea1i c\u00e1c h\u00e0ng, c\u00e1c c\u1ed9t\u00a0 kh\u00e1c trong b\u1ea3ng t\u0129nh Excel. V\u1eady l\u00e0 c\u00e1c b\u1ea1n \u0111\u00e3 ho\u00e0n th\u00e0nh xong thao t\u00e1c c\u1ed1 \u0111\u1ecbnh nh\u00f3m h\u00e0ng trong Excel v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n r\u1ed3i nh\u00e9.<\/p>\n

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

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng….<\/p>\n","protected":false},"excerpt":{"rendered":"

Khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c trang t\u00ednh Excel, b\u1ea1n s\u1ebd c\u1ea3m th\u1ea5y v\u00f4 c\u00f9ng kh\u00f3 ch\u1ecbu m\u1ed7i khi k\u00e9o chu\u1ed9t s\u1ebd l\u00e0m m\u1ea5t ti\u00eau \u0111\u1ec1 ho\u1eb7c c\u00e1c h\u00e0ng ch\u1ee9a nh\u1eefng n\u1ed9i dung quan tr\u1ecdng. Trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn t\u00ednh n\u0103ng c\u1ed1 \u0111\u1ecbnh h\u00e0ng. V\u1eady c\u00e1ch c\u1ed1 \u0111\u1ecbnh h\u00e0ng […]<\/p>\n","protected":false},"author":3,"featured_media":8589,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-8586","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=8586"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/8586\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/8589"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=8586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=8586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=8586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}