{"id":620,"date":"2020-07-25T01:56:30","date_gmt":"2020-07-24T18:56:30","guid":{"rendered":"https:\/\/hoctin.vn\/?p=620"},"modified":"2020-07-25T01:56:32","modified_gmt":"2020-07-24T18:56:32","slug":"cach-co-dinh-dong-trong-excel","status":"publish","type":"post","link":"https:\/\/hoctin.vn\/cach-co-dinh-dong-trong-excel\/","title":{"rendered":"C\u00e1ch C\u1ed1 \u0110\u1ecbnh C\u1ed9t, V\u00f9ng D\u1eef Li\u1ec7u V\u00e0 C\u1ed1 \u0110\u1ecbnh D\u00f2ng Trong Excel"},"content":{"rendered":"\t\t
Khi l\u00e0m vi\u1ec7c v\u1edbi m\u1ed9t danh s\u00e1ch d\u1eef li\u1ec7u l\u1edbn tr\u00ean b\u1ea3ng t\u00ednh Excel, c\u1ed1 \u0111\u1ecbnh d\u00f2ng, c\u1ed9t trong Excel l\u00e0 m\u1ed9t t\u00ednh n\u0103ng h\u1eefu \u00edch gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y c\u00e1c ti\u00eau \u0111\u1ec1 ho\u1eb7c c\u1ed9t hi\u1ec3n th\u1ecb khi \u0111i \u0111\u1ebfn c\u00e1c v\u00f9ng kh\u00e1c trong b\u1ea3ng t\u00ednh.<\/span><\/p> \u00a0<\/span><\/p> Trong b\u00e0i vi\u1ebft n\u00e0y, hoctin.vn s\u1ebd h\u01b0\u1edbng d\u1eabn cho c\u00e1c b\u1ea1n c\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n m\u00e0 hi\u1ec7u qu\u1ea3. Ngo\u00e0i c\u00e1ch c\u1ed1 \u0111\u1ecbnh h\u00e0ng trong Excel, b\u00e0i vi\u1ebft gi\u1edbi thi\u1ec7u c\u00e1c t\u00ednh n\u0103ng kh\u00e1c khi s\u1eed d\u1ee5ng Freeze Panes: \u0111\u00f3ng b\u0103ng c\u1ed9t, c\u1ed1 \u0111\u1ecbnh \u00f4 v\u00e0 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u khung m\u1ed9t l\u00fac trong Excel 2007, 2010, 2013, 2016 v\u00e0 2019.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t C\u00e1ch c\u1ed1 \u0111\u1ecbnh ti\u00eau \u0111\u1ec1 v\u00e0 hi\u1ec7n d\u00f2ng \u0111\u1ea7u ti\u00ean trong Excel:<\/span><\/p> B\u01b0\u1edbc 1:<\/span> Di chuy\u1ec3n \u0111\u1ebfn d\u00f2ng \u0111\u1ea7u c\u1ee7a trang t\u00ednh.<\/span><\/p> Mu\u1ed1n gi\u1eef d\u00f2ng ti\u00eau \u0111\u1ec1, c\u1ea7n ph\u1ea3i l\u00e0m hi\u1ec7n d\u00f2ng ti\u00eau \u0111\u1ec1 r\u1ed3i m\u1edbi s\u1eed d\u1ee5ng c\u1ed1 \u0111\u1ecbnh 1 d\u00f2ng b\u1eb1ng Freeze panes \u1edf Tab View trong Excel, n\u1ebfu kh\u00f4ng Excel s\u1ebd m\u1eb7c \u0111\u1ecbnh ghim h\u00e0ng \u0111\u1ea7u ti\u00ean \u0111ang hi\u1ec3n th\u1ecb tr\u00ean b\u1ea3ng t\u00ednh.<\/span><\/p> \u00a0<\/p> B\u01b0\u1edbc 2: <\/span>Ch\u1ecdn <\/span>View <\/span>>> <\/span>Freeze Panes <\/span>>> <\/span>Freeze Top Row<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t V\u00ed d\u1ee5 ghim d\u00f2ng \u0111\u1ea7u ti\u00ean: N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n c\u1ed1 \u0111\u1ecbnh d\u00f2ng s\u1ed1 3 m\u00e0 kh\u00f4ng mu\u1ed1n hi\u1ec3n th\u1ecb d\u00f2ng 1+2, k\u00e9o con l\u0103n chu\u1ed9t ho\u1eb7c \u0111i\u1ec1u ch\u1ec9nh thanh cu\u1ed9n \u0111\u1ebfn khi m\u00e0n h\u00ecnh ch\u1ec9 hi\u1ec3n th\u1ecb t\u1eeb d\u00f2ng s\u1ed1 3 tr\u1edf \u0111i v\u00e0 s\u1eed d\u1ee5ng Freeze Top Row trong Excel:<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t B\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u1edf v\u00ed d\u1ee5 tr\u00ean, d\u00f2ng 54 hi\u1ec3n th\u1ecb ngay d\u01b0\u1edbi d\u00f2ng 3 do trang t\u00ednh \u0111\u00e3 gi\u1eef d\u00f2ng 3 ghim \u1edf \u0111\u1ea7u trang.<\/span><\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t T\u01b0\u01a1ng t\u1ef1 c\u00e1ch \u0111\u00f3ng b\u0103ng (Freeze) 1 d\u00f2ng, thay v\u00ec ch\u1ecdn h\u00e0ng ti\u00eau \u0111\u1ec1, b\u1ea1n c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng trong Excel:<\/span><\/p> \u00a0<\/span><\/p> B\u01b0\u1edbc 1:<\/span> X\u00e1c \u0111\u1ecbnh c\u00e1c d\u00f2ng c\u1ea7n ghim, di chuy\u1ec3n \u0111\u1ebfn d\u00f2ng ngay b\u00ean d\u01b0\u1edbi khu v\u1ef1c d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/span><\/p> \u0110\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c d\u00f2ng m\u00e0 b\u1ea1n mu\u1ed1n kh\u00f3a \u0111\u1ec1u hi\u1ec3n th\u1ecb t\u1ea1i th\u1eddi \u0111i\u1ec3m th\u1ef1c hi\u1ec7n thao t\u00e1c. N\u1ebfu m\u1ed9t s\u1ed1 h\u00e0ng kh\u00f4ng hi\u1ec3n th\u1ecb, b\u1ea1n s\u1ebd kh\u00f4ng nh\u00ecn th\u1ea5y ch\u00fang sau khi \u0111\u00f3ng b\u0103ng b\u1eb1ng Freeze Panes.<\/span><\/p> K\u1ebft qu\u1ea3 c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel s\u1ebd nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi: 7 h\u00e0ng \u0111\u1ea7u trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh v\u00e0 s\u1ebd lu\u00f4n hi\u1ec3n th\u1ecb khi b\u1ea1n di chuy\u1ec3n \u0111\u1ebfn b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o trong trang t\u00ednh:<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t T\u01b0\u01a1ng t\u1ef1 c\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng trong Excel, \u0111\u1ec3 gi\u1eef nguy\u00ean c\u1ed9t trong Excel:<\/span><\/p> \u00a0<\/span><\/p> B\u01b0\u1edbc 1:<\/span> Di chuy\u1ec3n \u0111\u1ebfn c\u1ed9t \u0111\u1ea7u c\u1ee7a trang t\u00ednh ho\u1eb7c k\u00e9o con l\u0103n chu\u1ed9t\/ con tr\u1ecf chu\u1ed9t \u0111\u1ea3m b\u1ea3o c\u1ed9t ti\u00eau \u0111\u1ec1 xu\u1ea5t hi\u1ec7n v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i b\u1ea3ng t\u00ednh Excel.<\/span><\/p> \u00a0<\/span><\/p> B\u01b0\u1edbc 2: <\/span>Ch\u1ecdn <\/span>View <\/span>>> <\/span>Freeze Panes <\/span>>> <\/span>Freeze First Column<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\tM\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t
1, C\u00e1ch C\u1ed1 \u0110\u1ecbnh D\u00f2ng Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
1.1, C\u00e1ch Kh\u00f3a D\u00f2ng \u0110\u1ea7u Ti\u00ean Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
1.2, C\u00e1ch C\u1ed1 \u0110\u1ecbnh Nhi\u1ec1u H\u00e0ng Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
B\u01b0\u1edbc 2: <\/span>Ch\u1ecdn Tab <\/span>View <\/span>>> <\/span>Freeze Panes <\/span>>> <\/span>Freeze Panes<\/span>.<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t2, C\u00e1ch C\u1ed1 \u0110\u1ecbnh C\u1ed9t Trong Excel<\/span><\/span><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
2.1, C\u00e1ch C\u1ed1 \u0110\u1ecbnh C\u1ed9t Ti\u00eau \u0110\u1ec1 Trong Excel<\/span><\/span><\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t