{"id":18168,"date":"2026-04-17T15:00:55","date_gmt":"2026-04-17T08:00:55","guid":{"rendered":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/?p=18168"},"modified":"2026-05-28T12:05:46","modified_gmt":"2026-05-28T05:05:46","slug":"cach-co-dinh-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/goc-ky-nang\/cach-co-dinh-cot-trong-excel","title":{"rendered":"C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel: H\u01b0\u1edbng d\u1eabn Freeze Panes chi ti\u1ebft t\u1eeb A-Z"},"content":{"rendered":"\n

Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u r\u1ed9ng h\u00e0ng ch\u1ee5c c\u1ed9t, vi\u1ec7c cu\u1ed9n ngang li\u00ean t\u1ee5c khi\u1ebfn b\u1ea1n m\u1ea5t d\u1ea5u c\u1ed9t t\u00ean nh\u00e2n vi\u00ean ho\u1eb7c m\u00e3 s\u1ea3n ph\u1ea9m. C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/strong> b\u1eb1ng Freeze Panes gi\u00fap gi\u1eef nguy\u00ean c\u1ed9t quan tr\u1ecdng \u1edf b\u00ean tr\u00e1i m\u00e0n h\u00ecnh d\u00f9 b\u1ea1n cu\u1ed9n sang ph\u1ea3i bao nhi\u00eau. B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi ti\u1ebft t\u1eebng b\u01b0\u1edbc, k\u00e8m m\u1eb9o x\u1eed l\u00fd khi c\u1ed1 \u0111\u1ecbnh c\u1ea3 h\u00e0ng l\u1eabn c\u1ed9t c\u00f9ng l\u00fac.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\n

T\u1ed5ng quan nhanh<\/strong><\/p>\n

<\/p>\n

\u2013 Ch\u1ee9c n\u0103ng: Freeze Panes (C\u1ed1 \u0111\u1ecbnh ng\u0103n) gi\u1eef h\u00e0ng\/c\u1ed9t c\u1ed1 \u0111\u1ecbnh khi cu\u1ed9n.<\/p>\n

<\/p>\n

\u2013 V\u1ecb tr\u00ed: Tab View \u2192 Freeze Panes (Windows) ho\u1eb7c View \u2192 Freeze Panes (Mac).<\/p>\n

<\/p>\n

\u2013 3 t\u00f9y ch\u1ecdn: Freeze Panes (t\u00f9y ch\u1ecdn), Freeze Top Row (h\u00e0ng \u0111\u1ea7u), Freeze First Column (c\u1ed9t \u0111\u1ea7u).<\/p>\n

<\/p>\n

\u2013 \u00c1p d\u1ee5ng: Excel 2010, 2013, 2016, 2019, 2021, Microsoft 365.<\/p>\n<\/div>\n\n\n\n

1. C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean trong Excel<\/h2>\n\n\n\n

\u0110\u00e2y l\u00e0 thao t\u00e1c ph\u1ed5 bi\u1ebfn nh\u1ea5t: gi\u1eef c\u1ed9t A (th\u01b0\u1eddng ch\u1ee9a STT, m\u00e3, t\u00ean) c\u1ed1 \u0111\u1ecbnh khi cu\u1ed9n ngang.<\/p>\n\n\n\n

B\u01b0\u1edbc 1: M\u1edf file Excel ch\u1ee9a b\u1ea3ng d\u1eef li\u1ec7u r\u1ed9ng.<\/p>\n\n\n\n

B\u01b0\u1edbc 2: V\u00e0o tab View<\/strong> (Xem) tr\u00ean thanh Ribbon.<\/p>\n\n\n\n

B\u01b0\u1edbc 3: Click Freeze Panes<\/strong> \u2192 ch\u1ecdn Freeze First Column<\/strong>.<\/p>\n\n\n\n

B\u01b0\u1edbc 4: M\u1ed9t \u0111\u01b0\u1eddng vi\u1ec1n m\u1edd xu\u1ea5t hi\u1ec7n \u1edf c\u1ea1nh ph\u1ea3i c\u1ed9t A \u2013 t\u1eeb gi\u1edd khi cu\u1ed9n sang ph\u1ea3i, c\u1ed9t A lu\u00f4n hi\u1ec3n th\u1ecb.<\/p>\n\n\n\n

\u0110\u1ec3 h\u1ee7y: V\u00e0o View \u2192 Freeze Panes \u2192 Unfreeze Panes<\/strong>.<\/p>\n\n\n\n

\n

\u201cC\u1ed1 \u0111\u1ecbnh c\u1ed9t gi\u1ed1ng nh\u01b0 \u0111\u00f3ng \u0111inh t\u1ea5m b\u1ea3ng t\u00ean v\u00e0o b\u00e0n \u2013 d\u00f9 gi\u1ea5y t\u1edd b\u00ean c\u1ea1nh x\u00ea d\u1ecbch th\u1ebf n\u00e0o, b\u1ea1n lu\u00f4n bi\u1ebft m\u00ecnh \u0111ang nh\u00ecn d\u1eef li\u1ec7u c\u1ee7a ai.\u201d \u2013 Chia s\u1ebb ph\u1ed5 bi\u1ebfn trong c\u1ed9ng \u0111\u1ed3ng Excel Vi\u1ec7t Nam.<\/p>\n<\/blockquote>\n\n\n\n

2. C\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t trong Excel<\/h2>\n\n\n\n

Khi c\u1ea7n gi\u1eef c\u1ed1 \u0111\u1ecbnh 2\u20133 c\u1ed9t (v\u00ed d\u1ee5: c\u1ed9t A = STT, c\u1ed9t B = M\u00e3 NV, c\u1ed9t C = H\u1ecd t\u00ean), l\u00e0m nh\u01b0 sau:<\/p>\n\n\n\n

B\u01b0\u1edbc<\/th>Thao t\u00e1c<\/th>Gi\u1ea3i th\u00edch<\/th><\/tr><\/thead>
1<\/td>Click v\u00e0o \u00f4 D1 (c\u1ed9t ngay SAU c\u1ed9t cu\u1ed1i c\u1ea7n c\u1ed1 \u0111\u1ecbnh)<\/td>Excel s\u1ebd c\u1ed1 \u0111\u1ecbnh t\u1ea5t c\u1ea3 c\u1ed9t B\u00caN TR\u00c1I \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn<\/td><\/tr>
2<\/td>V\u00e0o View \u2192 Freeze Panes \u2192 Freeze Panes (t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean)<\/td>C\u1ed1 \u0111\u1ecbnh 3 c\u1ed9t A, B, C<\/td><\/tr>
3<\/td>Cu\u1ed9n ngang \u0111\u1ec3 ki\u1ec3m tra<\/td>3 c\u1ed9t \u0111\u1ea7u lu\u00f4n hi\u1ec3n th\u1ecb, c\u00e1c c\u1ed9t ph\u00eda sau cu\u1ed9n b\u00ecnh th\u01b0\u1eddng<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Nguy\u00ean t\u1eafc quan tr\u1ecdng: click v\u00e0o \u00f4 ngay SAU v\u00f9ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh<\/strong>. V\u00ed d\u1ee5 mu\u1ed1n c\u1ed1 \u0111\u1ecbnh 5 c\u1ed9t \u2192 click v\u00e0o \u00f4 F1, r\u1ed3i Freeze Panes. Excel s\u1ebd c\u1ed1 \u0111\u1ecbnh t\u1ea5t c\u1ea3 c\u1ed9t t\u1eeb A \u0111\u1ebfn E.<\/p>\n\n\n\n

3. C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ea3 h\u00e0ng v\u00e0 c\u1ed9t c\u00f9ng l\u00fac<\/h2>\n\n\n\n

Tr\u01b0\u1eddng h\u1ee3p ph\u1ed5 bi\u1ebfn: gi\u1eef h\u00e0ng 1 (ti\u00eau \u0111\u1ec1) + 2 c\u1ed9t \u0111\u1ea7u (STT, t\u00ean) c\u00f9ng c\u1ed1 \u0111\u1ecbnh. \u0110\u00e2y l\u00e0 k\u1ef9 thu\u1eadt quan tr\u1ecdng nh\u1ea5t khi l\u00e0m b\u1ea3ng l\u01b0\u01a1ng, b\u1ea3ng ch\u1ea5m c\u00f4ng, b\u1ea3ng t\u1ed3n kho.<\/p>\n\n\n\n

\u2013 Click v\u00e0o \u00f4 C2<\/strong> (\u00f4 giao gi\u1eefa c\u1ed9t ngay SAU v\u00f9ng c\u1ed1 \u0111\u1ecbnh v\u00e0 h\u00e0ng ngay B\u00caN D\u01af\u1edaI h\u00e0ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh).<\/p>\n\n\n\n

\u2013 V\u00e0o View \u2192 Freeze Panes \u2192 Freeze Panes<\/strong> (t\u00f9y ch\u1ecdn \u0111\u1ea7u ti\u00ean).<\/p>\n\n\n\n

\u2013 K\u1ebft qu\u1ea3: h\u00e0ng 1 c\u1ed1 \u0111\u1ecbnh khi cu\u1ed9n d\u1ecdc, c\u1ed9t A\u2013B c\u1ed1 \u0111\u1ecbnh khi cu\u1ed9n ngang.<\/p>\n\n\n\n

\n

L\u01b0u \u00fd quan tr\u1ecdng<\/strong><\/p>\n

<\/p>\n

\u2013 Freeze Panes ch\u1ec9 \u00e1p d\u1ee5ng cho 1 sheet t\u1ea1i 1 th\u1eddi \u0111i\u1ec3m. M\u1ed7i sheet c\u00f3 c\u00e0i \u0111\u1eb7t Freeze ri\u00eang.<\/p>\n

<\/p>\n

\u2013 N\u1ebfu \u0111ang \u1edf ch\u1ebf \u0111\u1ed9 Page Layout, Freeze Panes s\u1ebd b\u1ecb v\u00f4 hi\u1ec7u h\u00f3a \u2013 c\u1ea7n chuy\u1ec3n v\u1ec1 Normal view.<\/p>\n

<\/p>\n

\u2013 Freeze Panes kh\u00f4ng \u1ea3nh h\u01b0\u1edfng t\u1edbi in \u1ea5n. Mu\u1ed1n l\u1eb7p l\u1ea1i ti\u00eau \u0111\u1ec1 khi in, d\u00f9ng Page Layout \u2192 Print Titles thay v\u00ec Freeze.<\/p>\n

<\/p>\n

\u2013 V\u1edbi Excel Online (Microsoft 365 web), Freeze Panes ho\u1ea1t \u0111\u1ed9ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0ng giao di\u1ec7n n\u00fat h\u01a1i kh\u00e1c: View \u2192 Freeze Panes.<\/p>\n<\/div>\n\n\n\n

4. C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel tr\u00ean Mac<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Tr\u00ean macOS, c\u00e1c b\u01b0\u1edbc t\u01b0\u01a1ng t\u1ef1 nh\u01b0ng giao di\u1ec7n Ribbon kh\u00e1c \u0111\u00f4i ch\u00fat. Tab View<\/strong> n\u1eb1m tr\u00ean thanh menu (kh\u00f4ng ph\u1ea3i Ribbon n\u1ebfu d\u00f9ng Excel 2016 Mac). T\u1eeb Excel 2019 Mac tr\u1edf l\u00ean, giao di\u1ec7n gi\u1ed1ng Windows v\u1edbi tab View \u2192 Freeze Panes \u0111\u1ea7y \u0111\u1ee7 3 t\u00f9y ch\u1ecdn.<\/p>\n\n\n\n

N\u1ebfu d\u00f9ng Google Sheets thay v\u00ec Excel, t\u00ednh n\u0103ng t\u01b0\u01a1ng \u0111\u01b0\u01a1ng l\u00e0 View \u2192 Freeze<\/strong> \u2192 ch\u1ecdn s\u1ed1 c\u1ed9t\/h\u00e0ng c\u1ea7n freeze. Google Sheets cho ph\u00e9p t\u00f9y ch\u1ec9nh s\u1ed1 c\u1ed9t freeze d\u1ec5 h\u01a1n Excel v\u00ec c\u00f3 thanh k\u00e9o tr\u1ef1c quan.<\/p>\n\n\n\n

5. M\u1eb9o n\u00e2ng cao v\u1edbi Freeze Panes<\/h2>\n\n\n\n

\u2013 Split thay v\u00ec Freeze<\/strong>: n\u1ebfu c\u1ea7n xem 2 v\u00f9ng kh\u00e1c nhau trong c\u00f9ng 1 sheet, d\u00f9ng View \u2192 Split. Split chia sheet th\u00e0nh 4 \u00f4 cu\u1ed9n \u0111\u1ed9c l\u1eadp \u2013 h\u1eefu \u00edch khi so s\u00e1nh d\u1eef li\u1ec7u \u0111\u1ea7u b\u1ea3ng v\u00e0 cu\u1ed1i b\u1ea3ng.<\/p>\n\n\n\n

\u2013 K\u1ebft h\u1ee3p Freeze + Filter<\/strong>: c\u1ed1 \u0111\u1ecbnh h\u00e0ng ti\u00eau \u0111\u1ec1 r\u1ed3i b\u1eadt AutoFilter \u0111\u1ec3 v\u1eeba l\u1ecdc v\u1eeba gi\u1eef ti\u00eau \u0111\u1ec1 c\u1ed1 \u0111\u1ecbnh.<\/p>\n\n\n\n

\u2013 Freeze trong Table<\/strong>: n\u1ebfu d\u00f9ng Insert \u2192 Table, ti\u00eau \u0111\u1ec1 t\u1ef1 \u0111\u1ed9ng c\u1ed1 \u0111\u1ecbnh khi cu\u1ed9n d\u1ecdc m\u00e0 kh\u00f4ng c\u1ea7n Freeze Panes.<\/p>\n\n\n\n

\u2013 Ph\u00edm t\u1eaft<\/strong>: kh\u00f4ng c\u00f3 ph\u00edm t\u1eaft m\u1eb7c \u0111\u1ecbnh cho Freeze Panes, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 g\u00e1n b\u1eb1ng Quick Access Toolbar \u2192 Add \u2192 Freeze Panes \u0111\u1ec3 click nhanh h\u01a1n.<\/p>\n\n\n\n

B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1c th\u1ee7 thu\u1eadt Excel kh\u00e1c trong b\u00e0i vi\u1ebft c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh ch\u00f3ng ch\u00ednh x\u00e1c<\/a>. N\u1ebfu \u0111ang t\u00ecm c\u00f4ng vi\u1ec7c y\u00eau c\u1ea7u k\u1ef9 n\u0103ng Excel, xem chuy\u00ean m\u1ee5c vi\u1ec7c l\u00e0m k\u1ebf to\u00e1n \u2013 ki\u1ec3m to\u00e1n<\/a>.<\/p>\n\n\n\n

\n

L\u1eddi khuy\u00ean s\u1eed d\u1ee5ng Freeze Panes hi\u1ec7u qu\u1ea3<\/strong><\/p>\n

<\/p>\n

\u2013 Lu\u00f4n Freeze tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u nh\u1eadp d\u1eef li\u1ec7u l\u1edbn \u2013 tr\u00e1nh m\u1ea5t th\u1eddi gian cu\u1ed9n t\u00ecm ti\u00eau \u0111\u1ec1.<\/p>\n

<\/p>\n

\u2013 K\u1ebft h\u1ee3p Freeze + Conditional Formatting \u0111\u1ec3 t\u00f4 m\u00e0u h\u00e0ng\/c\u1ed9t theo \u0111i\u1ec1u ki\u1ec7n gi\u00fap \u0111\u1ecdc d\u1eef li\u1ec7u d\u1ec5 h\u01a1n.<\/p>\n

<\/p>\n

\u2013 N\u1ebfu Freeze Panes b\u1ecb \u201cx\u00e1m\u201d (disabled), ki\u1ec3m tra b\u1ea1n c\u00f3 \u0111ang \u1edf ch\u1ebf \u0111\u1ed9 Edit Cell (\u0111ang g\u00f5 trong \u00f4) \u2192 nh\u1ea5n Escape tr\u01b0\u1edbc.<\/p>\n<\/div>\n\n\n\n

6. \u1ee8ng d\u1ee5ng Freeze Panes trong c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf<\/h2>\n\n\n\n

6.1 B\u1ea3ng l\u01b0\u01a1ng v\u00e0 ch\u1ea5m c\u00f4ng<\/h3>\n\n\n\n

B\u1ea3ng l\u01b0\u01a1ng th\u01b0\u1eddng c\u00f3 h\u00e0ng ch\u1ee5c c\u1ed9t: l\u01b0\u01a1ng c\u01a1 b\u1ea3n, ph\u1ee5 c\u1ea5p, BHXH, BHYT, thu\u1ebf TNCN, th\u01b0\u1edfng KPI, t\u1ed5ng l\u01b0\u01a1ng. N\u1ebfu kh\u00f4ng Freeze c\u1ed9t t\u00ean nh\u00e2n vi\u00ean v\u00e0 m\u00e3 nh\u00e2n vi\u00ean, khi cu\u1ed9n sang c\u00e1c c\u1ed9t ph\u1ee5 c\u1ea5p ph\u00eda sau, b\u1ea1n s\u1ebd kh\u00f4ng bi\u1ebft d\u00f2ng l\u01b0\u01a1ng \u0111\u00f3 thu\u1ed9c ai. Thao t\u00e1c chu\u1ea9n: click \u00f4 C2 (sau c\u1ed9t STT v\u00e0 H\u1ecd t\u00ean, d\u01b0\u1edbi h\u00e0ng ti\u00eau \u0111\u1ec1) \u2192 Freeze Panes. K\u1ebft qu\u1ea3: h\u00e0ng 1 (ti\u00eau \u0111\u1ec1 c\u00e1c c\u1ed9t) v\u00e0 c\u1ed9t A\u2013B (STT, H\u1ecd t\u00ean) lu\u00f4n c\u1ed1 \u0111\u1ecbnh khi cu\u1ed9n ngang v\u00e0 d\u1ecdc.<\/p>\n\n\n\n

\u0110\u1eb7c bi\u1ec7t, v\u1edbi b\u1ea3ng ch\u1ea5m c\u00f4ng theo ng\u00e0y (31 c\u1ed9t cho 31 ng\u00e0y), Freeze Panes l\u00e0 b\u1eaft bu\u1ed9c v\u00ec kh\u00f4ng ai c\u00f3 th\u1ec3 nh\u1edb t\u00ean nh\u00e2n vi\u00ean khi cu\u1ed9n qua 20 c\u1ed9t ng\u00e0y. K\u1ebft h\u1ee3p Freeze v\u1edbi Conditional Formatting (t\u00f4 \u0111\u1ecf ng\u00e0y v\u1eafng, xanh ng\u00e0y \u0111i \u0111\u1ee7) gi\u00fap qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1 m\u1ed9t c\u00e1ch tr\u1ef1c quan v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n\n\n\n

6.2 B\u00e1o c\u00e1o t\u1ed3n kho \u0111a kho<\/h3>\n\n\n\n

Doanh nghi\u1ec7p c\u00f3 5\u201310 kho c\u1ea7n b\u00e1o c\u00e1o t\u1ed3n kho t\u1ed5ng h\u1ee3p: m\u1ed7i kho 1 c\u1ed9t, m\u1ed7i m\u00e3 h\u00e0ng 1 d\u00f2ng. B\u1ea3ng c\u00f3 th\u1ec3 l\u00ean \u0111\u1ebfn 50+ c\u1ed9t v\u00e0 5000+ d\u00f2ng. Freeze 3 c\u1ed9t \u0111\u1ea7u (STT, M\u00e3 h\u00e0ng, T\u00ean h\u00e0ng) + h\u00e0ng 1 (t\u00ean kho) gi\u00fap k\u1ebf to\u00e1n kho \u0111\u1ed1i chi\u1ebfu nhanh m\u00e0 kh\u00f4ng b\u1ecb lo\u1ea1n khi cu\u1ed9n gi\u1eefa c\u00e1c kho.<\/p>\n\n\n\n

6.3 Dashboard theo d\u00f5i KPI<\/h3>\n\n\n\n

Nhi\u1ec1u team s\u1eed d\u1ee5ng Excel l\u00e0m dashboard KPI v\u1edbi c\u1ed9t ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i l\u00e0 t\u00ean nh\u00e2n vi\u00ean ho\u1eb7c t\u00ean d\u1ef1 \u00e1n, c\u00e1c c\u1ed9t ph\u00eda sau l\u00e0 KPI theo tu\u1ea7n\/th\u00e1ng. Freeze c\u1ed9t t\u00ean + h\u00e0ng ti\u00eau \u0111\u1ec1 gi\u00fap bu\u1ed5i h\u1ecdp review \u0111\u1ecdc data nhanh tr\u00ean m\u00e1y chi\u1ebfu m\u00e0 kh\u00f4ng c\u1ea7n l\u1eadt qua l\u1eadt l\u1ea1i.<\/p>\n\n\n\n

6.4 X\u1eed l\u00fd khi Freeze Panes kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng<\/h3>\n\n\n\n

Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, Freeze Panes b\u1ecb v\u00f4 hi\u1ec7u h\u00f3a (n\u00fat b\u1ecb x\u00e1m). Nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn bao g\u1ed3m: \u0111ang \u1edf ch\u1ebf \u0111\u1ed9 Page Layout (c\u1ea7n chuy\u1ec3n v\u1ec1 Normal), \u0111ang edit \u00f4 (nh\u1ea5n Escape tr\u01b0\u1edbc), file \u0111ang \u1edf ch\u1ebf \u0111\u1ed9 Protected View (c\u1ea7n Enable Editing), ho\u1eb7c file \u0111ang \u0111\u01b0\u1ee3c chia s\u1ebb (Shared Workbook) v\u1edbi t\u00ednh n\u0103ng Track Changes b\u1eadt. Ngo\u00e0i ra, n\u1ebfu \u0111\u00e3 Freeze r\u1ed3i mu\u1ed1n \u0111\u1ed5i v\u1ecb tr\u00ed, ph\u1ea3i Unfreeze tr\u01b0\u1edbc r\u1ed3i Freeze l\u1ea1i \u2013 kh\u00f4ng th\u1ec3 Freeze ch\u1ed3ng l\u00ean Freeze c\u0169.<\/p>\n\n\n\n

\n

Checklist tr\u01b0\u1edbc khi Freeze Panes<\/strong><\/p>\n

<\/p>\n

\u2013 Ki\u1ec3m tra \u0111ang \u1edf Normal view (kh\u00f4ng ph\u1ea3i Page Layout, Page Break Preview).<\/p>\n

<\/p>\n

\u2013 Nh\u1ea5n Escape \u0111\u1ec3 tho\u00e1t ch\u1ebf \u0111\u1ed9 edit cell.<\/p>\n

<\/p>\n

\u2013 Click \u0111\u00fang \u00f4: \u00f4 ngay SAU v\u00e0 B\u00caN D\u01af\u1edaI v\u00f9ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh.<\/p>\n

<\/p>\n

\u2013 N\u1ebfu file Protected View \u2192 click Enable Editing tr\u01b0\u1edbc.<\/p>\n

<\/p>\n

\u2013 Unfreeze c\u0169 tr\u01b0\u1edbc khi Freeze m\u1edbi.<\/p>\n<\/div>\n\n\n\n

So s\u00e1nh Freeze Panes v\u1edbi c\u00e1c ph\u01b0\u01a1ng ph\u00e1p c\u1ed1 \u0111\u1ecbnh kh\u00e1c<\/h3>\n\n\n\n

Ngo\u00e0i Freeze Panes, Excel c\u00f2n c\u00f3 m\u1ed9t s\u1ed1 ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c \u0111\u1ec3 gi\u1eef d\u1eef li\u1ec7u hi\u1ec3n th\u1ecb khi cu\u1ed9n, m\u1ed7i ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p v\u1edbi t\u00ecnh hu\u1ed1ng kh\u00e1c nhau. Split (View \u2192 Split) chia sheet th\u00e0nh 4 v\u00f9ng cu\u1ed9n \u0111\u1ed9c l\u1eadp \u2013 h\u1eefu \u00edch khi c\u1ea7n so s\u00e1nh hai v\u00f9ng d\u1eef li\u1ec7u xa nhau trong c\u00f9ng m\u1ed9t sheet m\u00e0 kh\u00f4ng c\u1ea7n copy sang sheet kh\u00e1c. Table (Insert \u2192 Table) t\u1ef1 \u0111\u1ed9ng c\u1ed1 \u0111\u1ecbnh h\u00e0ng ti\u00eau \u0111\u1ec1 khi cu\u1ed9n d\u1ecdc m\u00e0 kh\u00f4ng c\u1ea7n Freeze \u2013 r\u1ea5t ti\u1ec7n cho b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 c\u1ea5u tr\u00fac r\u00f5 r\u00e0ng v\u1edbi ti\u00eau \u0111\u1ec1 c\u1ed9t. Print Titles (Page Layout \u2192 Print Titles) cho ph\u00e9p l\u1eb7p l\u1ea1i h\u00e0ng\/c\u1ed9t \u0111\u1ea7u ti\u00ean tr\u00ean m\u1ed7i trang khi in \u2013 kh\u00e1c ho\u00e0n to\u00e0n v\u1edbi Freeze v\u00ec ch\u1ec9 \u1ea3nh h\u01b0\u1edfng b\u1ea3n in, kh\u00f4ng \u1ea3nh h\u01b0\u1edfng giao di\u1ec7n tr\u00ean m\u00e0n h\u00ecnh.<\/p>\n\n\n\n

Khi n\u00e0o d\u00f9ng Freeze, khi n\u00e0o d\u00f9ng Table, khi n\u00e0o d\u00f9ng Split? N\u1ebfu b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 format chu\u1ea9n (ti\u00eau \u0111\u1ec1 r\u00f5, kh\u00f4ng merge cell) \u2192 d\u00f9ng Table l\u00e0 t\u1ed1t nh\u1ea5t v\u00ec t\u1ef1 \u0111\u1ed9ng Freeze + AutoFilter + format zebra. N\u1ebfu c\u1ea7n gi\u1eef nhi\u1ec1u c\u1ed9t b\u00ean tr\u00e1i + h\u00e0ng tr\u00ean \u2192 Freeze Panes l\u00e0 l\u1ef1a ch\u1ecdn duy nh\u1ea5t. N\u1ebfu c\u1ea7n xem 2 v\u00f9ng xa nhau c\u00f9ng l\u00fac \u2192 d\u00f9ng Split. N\u1ebfu c\u1ea7n l\u1eb7p ti\u00eau \u0111\u1ec1 khi in \u2192 d\u00f9ng Print Titles.<\/p>\n\n\n\n

M\u1ed9t m\u1eb9o \u00edt ng\u01b0\u1eddi bi\u1ebft: b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p Freeze Panes v\u1edbi Named Ranges \u0111\u1ec3 t\u1ea1o navigation nhanh trong file l\u1edbn. \u0110\u1eb7t t\u00ean v\u00f9ng (v\u00ed d\u1ee5 \u201cBangLuong\u201d cho v\u00f9ng A1:Z500) r\u1ed3i d\u00f9ng Name Box (\u00f4 t\u00ean \u1edf g\u00f3c tr\u00e1i tr\u00ean) \u0111\u1ec3 nh\u1ea3y nhanh t\u1edbi v\u00f9ng \u0111\u00f3 \u2013 Freeze Panes gi\u1eef ti\u00eau \u0111\u1ec1 \u1ed5n \u0111\u1ecbnh d\u00f9 b\u1ea1n nh\u1ea3y t\u1edbi \u0111\u00e2u.<\/p>\n\n\n\n

Ph\u00edm t\u1eaft v\u00e0 Quick Access Toolbar cho Freeze Panes<\/h3>\n\n\n\n

M\u1eb7c d\u00f9 Excel kh\u00f4ng c\u00f3 ph\u00edm t\u1eaft m\u1eb7c \u0111\u1ecbnh cho Freeze Panes, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ph\u00edm t\u1eaft ri\u00eang b\u1eb1ng c\u00e1ch th\u00eam n\u00fat Freeze Panes v\u00e0o Quick Access Toolbar. V\u00e0o File \u2192 Options \u2192 Quick Access Toolbar \u2192 ch\u1ecdn \u201cAll Commands\u201d \u2192 t\u00ecm \u201cFreeze Panes\u201d \u2192 Add \u2192 OK. Sau \u0111\u00f3 d\u00f9ng Alt + s\u1ed1 th\u1ee9 t\u1ef1 tr\u00ean QAT \u0111\u1ec3 k\u00edch ho\u1ea1t nhanh. V\u1edbi ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng xuy\u00ean (k\u1ebf to\u00e1n, HR, qu\u1ea3n l\u00fd kho), m\u1eb9o n\u00e0y ti\u1ebft ki\u1ec7m \u0111\u00e1ng k\u1ec3 th\u1eddi gian m\u1ed7i khi m\u1edf file m\u1edbi.<\/p>\n\n\n\n

7. Th\u1ecb tr\u01b0\u1eddng tuy\u1ec3n d\u1ee5ng y\u00eau c\u1ea7u Excel format tr\u00ean CareerLink (Th\u00e1ng 5\/2026)<\/h2>\n\n\n\n

Theo d\u1eef li\u1ec7u c\u1eadp nh\u1eadt tr\u00ean CareerLink th\u00e1ng 5\/2026, k\u1ef9 n\u0103ng \u0111\u1ecbnh d\u1ea1ng v\u00e0 c\u1ed1 \u0111\u1ecbnh c\u1ed9t Excel (Freeze Panes) l\u00e0 y\u00eau c\u1ea7u c\u01a1 b\u1ea3n trong g\u1ea7n nh\u01b0 m\u1ecdi tin tuy\u1ec3n d\u1ee5ng v\u1ecb tr\u00ed th\u01b0 k\u00fd \u2013 h\u00e0nh ch\u00ednh \u2013 k\u1ebf to\u00e1n v\u0103n ph\u00f2ng<\/strong>. H\u1ec7 th\u1ed1ng ghi nh\u1eadn kho\u1ea3ng 400\u2013550 tin Th\u01b0 k\u00fd \u2013 H\u00e0nh ch\u00e1nh + 600+ tin K\u1ebf to\u00e1n \u2013 Ki\u1ec3m to\u00e1n<\/strong>, t\u1ed5ng h\u01a1n 1.000 tin y\u00eau c\u1ea7u Excel \u1edf m\u1ee9c trung b\u00ecnh \u2013 n\u00e2ng cao.<\/p>\n\n\n\n

\n

T\u1ed5ng quan d\u1eef li\u1ec7u Excel trong tuy\u1ec3n d\u1ee5ng (CareerLink, T5\/2026)<\/strong><\/p>\n

\u2013 S\u1ed1 tin Th\u01b0 k\u00fd \u2013 HC: 400\u2013550 tin (l\u01b0\u01a1ng 9\u201325 tri\u1ec7u\/th\u00e1ng).<\/p>\n

\u2013 S\u1ed1 tin K\u1ebf to\u00e1n v\u0103n ph\u00f2ng: 200+ tin (l\u01b0\u01a1ng 10\u201322 tri\u1ec7u\/th\u00e1ng).<\/p>\n

\u2013 Top khu v\u1ef1c: TP.HCM, H\u00e0 N\u1ed9i, B\u00ecnh D\u01b0\u01a1ng, \u0110\u1ed3ng Nai.<\/p>\n

\u2013 K\u1ef9 n\u0103ng Excel \u01b0u ti\u00ean: Freeze Panes, Format as Table, Conditional Formatting, PivotTable, Power Query.<\/p>\n<\/div>\n\n\n

C\u1ed1 \u0111\u1ecbnh c\u1ed9t (Freeze Panes) l\u00e0 k\u1ef9 n\u0103ng n\u1ec1n t\u1ea3ng cho m\u1ecdi b\u00e1o c\u00e1o d\u00e0i: b\u1ea3ng l\u01b0\u01a1ng 12 th\u00e1ng, danh s\u00e1ch nh\u00e2n vi\u00ean 500+ d\u00f2ng, s\u1ed5 chi ti\u1ebft k\u1ebf to\u00e1n, b\u00e1o c\u00e1o d\u1ef1 \u00e1n nhi\u1ec1u c\u1ed9t. Theo Lu\u1eadt K\u1ebf to\u00e1n 88\/2015\/QH13 v\u00e0 Th\u00f4ng t\u01b0 200\/2014\/TT-BTC, m\u1ecdi s\u1ed5 s\u00e1ch k\u1ebf to\u00e1n \u0111i\u1ec7n t\u1eed \u0111\u1ec1u ph\u1ea3i d\u1ec5 tra c\u1ee9u v\u00e0 in \u0111\u01b0\u1ee3c \u2013 k\u1ef9 n\u0103ng \u0111\u1ecbnh d\u1ea1ng Excel chu\u1ea9n gi\u00fap \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u n\u00e0y. Tools li\u00ean quan: Microsoft Excel 365, Google Sheets, Power BI, Microsoft 365 Copilot.<\/p>\n\n\n\n\n\n\n
Vai tr\u00f2<\/th>\nM\u1ee9c l\u01b0\u01a1ng<\/th>\nY\u00eau c\u1ea7u Excel<\/th>\nTool\/Ch\u1ee9ng ch\u1ec9<\/th>\n<\/tr>\n<\/thead>\n
Th\u01b0 k\u00fd v\u0103n ph\u00f2ng<\/td>9\u201313 tri\u1ec7u\/th\u00e1ng<\/td>Freeze Panes, Format as Table<\/td>MOS Excel Specialist<\/td><\/tr>\n
H\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1<\/td>10\u201318 tri\u1ec7u\/th\u00e1ng<\/td>PivotTable, Conditional Formatting<\/td>MOS, SAP HR c\u01a1 b\u1ea3n<\/td><\/tr>\n
K\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p<\/td>12\u201322 tri\u1ec7u\/th\u00e1ng<\/td>Power Query, Macro<\/td>MISA, FAST, MOS Expert<\/td><\/tr>\n
Office Manager \/ Tr\u1ee3 l\u00fd CEO<\/td>18\u201332 tri\u1ec7u\/th\u00e1ng<\/td>Dashboard Power BI, Copilot<\/td>MOS Expert, Power BI cert<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n

B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c v\u1ecb tr\u00ed \u0111ang tuy\u1ec3n t\u1ea1i chuy\u00ean m\u1ee5c vi\u1ec7c l\u00e0m th\u01b0 k\u00fd \u2013 h\u00e0nh ch\u00e1nh<\/a> \u0111\u1ec3 h\u00ecnh dung r\u00f5 h\u01a1n JD, m\u1ee9c l\u01b0\u01a1ng v\u00e0 b\u00e0i test Excel cho t\u1eebng c\u1ea5p b\u1eadc.<\/p>\n\n\n

\n

L\u1eddi khuy\u00ean cho ng\u01b0\u1eddi d\u00f9ng Excel chuy\u00ean nghi\u1ec7p<\/strong><\/p>\n

\u2013 S\u1eed d\u1ee5ng Freeze Panes + Format as Table c\u00f9ng l\u00fac cho m\u1ecdi b\u00e1o c\u00e1o d\u00e0i h\u01a1n 50 d\u00f2ng \u2013 \u0111\u00e2y l\u00e0 ti\u00eau chu\u1ea9n b\u00e1o c\u00e1o \u1edf c\u00e1c t\u1eadp \u0111o\u00e0n FDI (P&G, Unilever, Samsung).<\/p>\n

\u2013 H\u1ecdc th\u00eam ph\u00edm t\u1eaft (Alt+W+F+F \u0111\u1ec3 Freeze Panes, Ctrl+T cho Format as Table) \u2013 t\u1ed1c \u0111\u1ed9 thao t\u00e1c nhanh l\u00e0 \u0111i\u1ec3m c\u1ed9ng l\u1edbn trong b\u00e0i test ph\u1ecfng v\u1ea5n.<\/p>\n

\u2013 L\u1ea5y ch\u1ee9ng ch\u1ec9 MOS Excel Specialist (240 USD, thi t\u1ea1i Pearson VUE) \u2013 \u0111\u00e2y l\u00e0 ch\u1ee9ng ch\u1ec9 gi\u00fap CV v\u01b0\u1ee3t qua v\u00f2ng l\u1ecdc t\u1ef1 \u0111\u1ed9ng v\u00e0 t\u0103ng 10\u201315% l\u01b0\u01a1ng kh\u1edfi \u0111i\u1ec3m.<\/p>\n<\/div>\n\n\n\n

8. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/h2>\n\n\n\n

1. Freeze Panes c\u00f3 \u1ea3nh h\u01b0\u1edfng t\u1edbi c\u00f4ng th\u1ee9c kh\u00f4ng?<\/em><\/strong><\/p>\n\n\n\n

Kh\u00f4ng. Freeze Panes ch\u1ec9 \u1ea3nh h\u01b0\u1edfng t\u1edbi giao di\u1ec7n hi\u1ec3n th\u1ecb (view), kh\u00f4ng thay \u0111\u1ed5i d\u1eef li\u1ec7u, c\u00f4ng th\u1ee9c hay v\u00f9ng tham chi\u1ebfu. M\u1ecdi ph\u00e9p t\u00ednh v\u1eabn ho\u1ea1t \u0111\u1ed9ng b\u00ecnh th\u01b0\u1eddng.<\/p>\n\n\n\n

2. T\u1ea1i sao Freeze Panes b\u1ecb l\u1ec7ch v\u1ecb tr\u00ed?<\/em><\/strong><\/p>\n\n\n\n

Th\u01b0\u1eddng do b\u1ea1n click v\u00e0o \u00f4 sai tr\u01b0\u1edbc khi Freeze. H\u00e3y Unfreeze tr\u01b0\u1edbc, click v\u00e0o \u0111\u00fang \u00f4 mong mu\u1ed1n (\u00f4 ngay SAU v\u00e0 B\u00caN D\u01af\u1edaI v\u00f9ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh) r\u1ed3i Freeze l\u1ea1i.<\/p>\n\n\n\n

3. C\u00f3 c\u00e1ch n\u00e0o c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u1edf gi\u1eefa b\u1ea3ng kh\u00f4ng?<\/em><\/strong><\/p>\n\n\n\n

Freeze Panes ch\u1ec9 c\u1ed1 \u0111\u1ecbnh c\u1ed9t t\u1eeb B\u00caN TR\u00c1I. Kh\u00f4ng th\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u1edf gi\u1eefa b\u1ea3ng. N\u1ebfu c\u1ea7n, h\u00e3y di chuy\u1ec3n (cut + insert) c\u1ed9t \u0111\u00f3 sang b\u00ean tr\u00e1i b\u1ea3ng tr\u01b0\u1edbc khi Freeze.<\/p>\n\n\n\n

C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel<\/strong> b\u1eb1ng Freeze Panes l\u00e0 k\u1ef9 n\u0103ng c\u01a1 b\u1ea3n m\u00e0 m\u1ecdi nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng c\u1ea7n n\u1eafm v\u1eefng. Ch\u1ec9 c\u1ea7n nh\u1edb nguy\u00ean t\u1eafc \u201cclick v\u00e0o \u00f4 ngay SAU v\u00f9ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh\u201d v\u00e0 ch\u1ecdn Freeze Panes, b\u1ea1n c\u00f3 th\u1ec3 gi\u1eef c\u1ed1 \u0111\u1ecbnh b\u1ea5t k\u1ef3 s\u1ed1 c\u1ed9t, h\u00e0ng ho\u1eb7c c\u1ea3 hai c\u00f9ng l\u00fac. H\u00e3y luy\u1ec7n t\u1eadp tr\u00ean file d\u1eef li\u1ec7u th\u1eadt v\u00e0 k\u1ebft h\u1ee3p v\u1edbi Filter, Conditional Formatting \u0111\u1ec3 t\u1ea1o b\u1ea3ng t\u00ednh chuy\u00ean nghi\u1ec7p, d\u1ec5 \u0111\u1ecdc.<\/p>\n\n\n\n

Minh An<\/strong><\/p>\n\n\n\n

B\u00e0i vi\u1ebft mang t\u00ednh tham kh\u1ea3o, giao di\u1ec7n v\u00e0 ch\u1ee9c n\u0103ng c\u00f3 th\u1ec3 kh\u00e1c nhau t\u00f9y phi\u00ean b\u1ea3n Excel v\u00e0 h\u1ec7 \u0111i\u1ec1u h\u00e0nh.<\/em><\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel b\u1eb1ng Freeze Panes. Xem ngay c\u00e1ch c\u1ed1 \u0111\u1ecbnh 1 c\u1ed9t, nhi\u1ec1u c\u1ed9t, c\u1ed1 \u0111\u1ecbnh c\u1ea3 h\u00e0ng v\u00e0 c\u1ed9t c\u00f9ng l\u00fac c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda.<\/p>\n","protected":false},"author":58,"featured_media":18260,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-18168","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-goc-ky-nang"],"_links":{"self":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/18168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/comments?post=18168"}],"version-history":[{"count":9,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/18168\/revisions"}],"predecessor-version":[{"id":19538,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/posts\/18168\/revisions\/19538"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media\/18260"}],"wp:attachment":[{"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/media?parent=18168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/categories?post=18168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mb668s.com\/cam-nang-7mb66-xoc-dia\/wp-json\/wp\/v2\/tags?post=18168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}