{"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
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t

M\u1ee5c L\u1ee5c B\u00e0i Vi\u1ebft<\/h4>\t\t\t\t\t\t\t
<\/i><\/div>\n\t\t\t\t
<\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t
\n\t\t\t
\n\t\t\t\t<\/i>\n\t\t\t<\/div>\n\t\t<\/div>\n\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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>


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\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

2, 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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\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\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

\u00a0<\/p>

K\u1ebft qu\u1ea3 sau khi \u00e1p d\u1ee5ng c\u00e1ch gi\u1eef ti\u00eau \u0111\u1ec1 trong Excel: \u0110\u01b0\u1eddng vi\u1ec1n m\u1edd nh\u1ea1t m\u00e0u x\u00e1m xu\u1ea5t hi\u1ec7n ng\u0103n c\u00e1ch c\u1ed9t ti\u00eau \u0111\u1ec1 \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u00f3ng b\u0103ng v\u00e0 ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a 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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

2.2, C\u00e1ch Kh\u00f3a Nhi\u1ec1u C\u1ed9t Trong Excel<\/span><\/span>

<\/h2><\/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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

T\u01b0\u01a1ng t\u1ef1 c\u00e1ch \u0111\u00f3ng b\u0103ng (Freeze) 1 c\u1ed9t, thay v\u00ec ch\u1ecdn c\u1ed9t ti\u00eau \u0111\u1ec1, b\u1ea1n c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t trong Excel:<\/span><\/p>\n

\n<\/p>

B\u01b0\u1edbc 1:<\/span> X\u00e1c \u0111\u1ecbnh c\u00e1c c\u1ed9t c\u1ea7n ghim, di chuy\u1ec3n \u0111\u1ebfn c\u1ed9t ngay b\u00ean ph\u1ea3i khu v\u1ef1c c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/span><\/p>\n

\u0110\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh \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 c\u1ed9t 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>


<\/span><\/p>

B\u01b0\u1edbc 2:<\/span> Ch\u1ecdn <\/span>Tab View<\/span> >> <\/span>Freeze Panes<\/span> >> <\/span>Freeze Panes<\/span>.<\/span><\/p>


<\/span><\/p>

V\u00ed d\u1ee5: N\u1ebfu b\u1ea1n mu\u1ed1n kh\u00f3a 3 c\u1ed9t \u0111\u1ea7u, ch\u1ecdn c\u1ed9t D l\u00e0 c\u1ed9t b\u00ean ph\u1ea3i 3 c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh:<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"T\u01b0\u01a1ng\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

\u0110\u01b0\u1eddng vi\u1ec1n th\u1ec3 hi\u1ec7n gi\u1edbi h\u1ea1n c\u1ee7a c\u00e1c c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh xu\u1ea5t hi\u1ec7n. L\u00fac n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o con tr\u1ecf chu\u1ed9t \u0111\u1ebfn c\u00e1c c\u1ed9t kh\u00e1c m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t 3 c\u1ed9t \u0111\u1ea7u \u0111\u00e3 \u0111\u01b0\u1ee3c kh\u00f3a b\u1eb1ng Freeze nh\u01b0 sau:<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

3, C\u00e1ch C\u1ed1 \u0110\u1ecbnh \u00d4 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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Ngo\u00e0i c\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t, c\u1ed1 \u0111\u1ecbnh h\u00e0ng trong Excel, kh\u00f3a \u00f4 gi\u00fap b\u1ea1n c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng v\u00e0 c\u1ed9t c\u00f9ng m\u1ed9t l\u00fac.<\/span><\/p>

\u00a0<\/span><\/p>

\u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3, c\u1ea7n ch\u1ecdn 1 \u00f4 d\u01b0\u1edbi h\u00e0ng cu\u1ed1i c\u00f9ng v\u00e0 b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i c\u00f9ng c\u1ea7n kh\u00f3a, sau \u0111\u00f3 v\u00e0o <\/span>Tab View <\/span>>> Ch\u1ecdn <\/span>Freeze Panes <\/span>>> <\/span>Freeze Panes<\/span>.<\/span><\/p>

\u00a0<\/span><\/p>

V\u00ed d\u1ee5 v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u d\u01b0\u1edbi \u0111\u00e2y, ngo\u00e0i vi\u1ec7c c\u1ea7n quan s\u00e1t 5 d\u00f2ng \u0111\u1ea7u c\u1ee7a b\u1ea3ng t\u00ednh \u0111\u1ec3 bi\u1ebft m\u1ed7i c\u1ed9t d\u1eef li\u1ec7u \u0111\u1ea1i di\u1ec7n cho th\u00e1ng n\u00e0o, th\u00ec c\u1ea7n quan s\u00e1t 3 c\u1ed9t \u0111\u1ea7u \u0111\u1ec3 bi\u1ebft c\u00e1c ch\u1ec9 ti\u00eau n\u00e0o thu\u1ed9c c\u00e1n c\u00e2n th\u01b0\u01a1ng m\u1ea1i n\u00e0o, c\u00f3 \u0111\u01a1n v\u1ecb t\u00ednh ra sao \u0111ang \u0111\u01b0\u1ee3c tr\u00edch d\u1eabn.<\/span><\/p>

\u00a0<\/p>

Ch\u1ecdn \u00f4 D6, s\u1eed d\u1ee5ng Freeze Panes th\u00ec 5 h\u00e0ng ph\u00eda tr\u00ean \u00f4 D6 v\u00e0 3 c\u1ed9t A, B, C b\u00ean tr\u00e1i \u00f4 D6 s\u1ebd \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh:<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"C\u00e1ch\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

4. <\/span><\/font>L\u01b0u \u00dd Khi S\u1eed D\u1ee5ng Freeze \u0110\u1ec3 C\u1ed1 \u0110\u1ecbnh H\u00e0ng 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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

4.1, B\u1ecf C\u1ed1 \u0110\u1ecbnh C\u1ed9t Ho\u1eb7c C\u1ed1 \u0110\u1ecbnh D\u00f2ng 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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

\u0110\u1ec3 ng\u01b0ng \u0111\u00f3ng b\u0103ng c\u1ed9t ho\u1eb7c h\u00e0ng, ch\u1ec9 c\u1ea7n nh\u1ea5n v\u00e0o <\/span>Tab View <\/span>>> <\/span>Freeze Panes <\/span>>> <\/span>Unfreeze 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\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\"B\u1ecf\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

V\u1edbi m\u1ed9t trang t\u00ednh Excel \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh h\u00e0ng c\u1ed9t t\u1eeb tr\u01b0\u1edbc khi\u1ebfn 1 s\u1ed1 d\u00f2ng \u0111\u1ea7u ho\u1eb7c 1 s\u1ed1 c\u1ed9t \u0111\u1ea7u trang kh\u00f4ng hi\u1ec3n th\u1ecb, b\u1ea1n n\u00ean Unfreeze \u0111\u1ec3 quan s\u00e1t to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh v\u00e0 quy\u1ebft \u0111\u1ecbnh xem n\u00ean c\u1ed1 \u0111\u1ecbnh d\u00f2ng v\u00e0 c\u1ed9t n\u00e0o.<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

4.2, Di Chuy\u1ec3n Trong B\u1ea3ng T\u00ednh Khi Th\u1ef1c Hi\u1ec7n Kh\u00f3a \u00d4 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
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Ph\u00edm t\u1eaft di chuy\u1ec3n \u0111\u1ebfn \u00f4 \u0111\u1ea7u ti\u00ean trong b\u1ea3ng t\u00ednh trong Excel \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh nh\u01b0 sau:<\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t