{"id":3254,"date":"2024-12-03T01:35:07","date_gmt":"2024-12-03T01:35:07","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-han-che-so-hang-va-cot-trong-trang-tinh-excel\/"},"modified":"2024-12-03T01:35:07","modified_gmt":"2024-12-03T01:35:07","slug":"cach-han-che-so-hang-va-cot-trong-trang-tinh-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-han-che-so-hang-va-cot-trong-trang-tinh-excel\/","title":{"rendered":"C\u00e1ch h\u1ea1n ch\u1ebf s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t trong trang t\u00ednh Excel"},"content":{"rendered":"
\n

Khi chia s\u1ebd b\u1ea3ng t\u00ednh Excel v\u1edbi ng\u01b0\u1eddi kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng mu\u1ed1n ng\u01b0\u1eddi kh\u00e1c xem m\u1ed9t s\u1ed1 d\u00f2ng ho\u1eb7c c\u1ed9t. Sau \u0111\u00e2y H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn v\u00e0i m\u1eb9o nhanh \u0111\u1ec3 h\u1ea1n ch\u1ebf s\u1ed1 d\u00f2ng v\u00e0 c\u1ed9t trong trang t\u00ednh Excel.<\/p>\n

H\u1ea1n ch\u1ebf s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t b\u1eb1ng c\u00e1ch v\u00f4 hi\u1ec7u h\u00f3a thanh tr\u01b0\u1ee3t trong Excel<\/strong><\/p>\n

Trong Excel, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp v\u00f9ng tr\u01b0\u1ee3t \u0111\u1ec3 ng\u0103n c\u1ea3n vi\u1ec7c xem h\u00e0ng v\u00e0 c\u1ed9t c\u1ee7a v\u00f9ng kh\u00e1c<\/p>\n

B\u01b0\u1edbc 1: Nh\u1ea5p ph\u1ea3i v\u00e0o t\u00ean trang t\u00ednh, ch\u1ecdn View Code<\/strong><\/p>\n

<\/p>\n

B\u01b0\u1edbc 2: B\u00e2y gi\u1edd b\u1ea1n s\u1ebd m\u1edf \u0111\u01b0\u1ee3c c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications, <\/strong>b\u1ea1n c\u1ea7n m\u1edf thu\u1ed9c t\u00ednh c\u1ee7a n\u00f3 b\u1eb1ng c\u00e1ch nh\u1ea5p View<\/strong> > Properties Window<\/strong>.<\/p>\n

<\/p>\n

Ch\u00fa \u00fd: <\/strong>N\u1ebfu c\u1eeda s\u1ed5 thu\u1ed9c t\u00ednh \u0111\u00e3 m\u1edf r\u1ed3i, th\u00ec h\u00e3y b\u1ecf qua b\u01b0\u1edbc n\u00e0y<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n

Xem th\u00eam:\u00a0T\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n

Step 3: Trong c\u1eeda s\u1ed5 thu\u1ed9c t\u00ednh, ki\u1ebfm ScrollArea<\/strong> \u1edf b\u00ean tr\u00e1i c\u1eeda s\u1ed5, v\u00e0 nh\u1eadp v\u00e0o \u00f4 b\u00ean c\u1ea1nh v\u00f9ng c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb.<\/p>\n

<\/p>\n

B\u01b0\u1edbc 4: \u0110\u00f3ng c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications<\/strong><\/p>\n

Sau \u0111\u00f3 b\u1ea1n s\u1ebd th\u1ea5y c\u1ea3 thanh tr\u01b0\u1ee3t ngang v\u00e0 d\u1ecdc \u0111\u1ec1u c\u1ed1 \u0111\u1ecbnh, b\u1ea1n kh\u00f4ng th\u1ec3 k\u00e9o qua d\u00f2ng v\u00e0 c\u1ed9t kh\u00e1c ngo\u00e0i v\u00f9ng \u0111\u00e3 ch\u1ecdn.<\/p>\n

Gi\u1edbi h\u1ea1n s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t b\u1eb1ng c\u00e1c \u1ea9n h\u00e0ng v\u00e0 c\u1ed9t<\/strong><\/p>\n

B\u00ean c\u1ea1nh vi\u1ec7c thi\u1ebft l\u1eadp v\u00f9ng tr\u01b0\u1ee3t, ch\u00fang ta c\u00f2n c\u00f3 th\u1ec3 gi\u1edbi h\u1ea1n s\u1ed1 d\u00f2ng v\u00e0 c\u1ed9t b\u1eb1ng c\u00e1ch \u1ea9n h\u00e0ng c\u1ed9t kh\u00f4ng \u0111\u01b0\u1ee3c chia s\u1ebb.<\/p>\n

B\u01b0\u1edbc 1: B\u00ean c\u1ea1nh ph\u1ea7n d\u1eef li\u1ec7u chia s\u1ebb, b\u1ea1n c\u1ea7n ch\u1ecdn ph\u1ea7n c\u00f2n l\u1ea1i v\u00e0 \u1ea9n ch\u00fang. Ch\u1ecdn c\u1ed9t \u0111\u1ea7u ti\u00ean cua3 ph\u1ea7n kh\u00f4ng mu\u1ed1n chia s\u1ebb d\u1eef li\u1ec7u, nh\u1ea5n Ctrl <\/strong>+ Shift<\/strong> + v\u00e0 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t.<\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5p ph\u1ea3i t\u1ea1i nh\u1eefng c\u1ed9t \u0111\u00e3 ch\u1ecdn, ch\u1ecdn Hide.<\/strong><\/p>\n

<\/p>\n

B\u01b0\u1edbc 3: Ch\u1ecdn h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a ph\u1ea7n kh\u00f4ng mu\u1ed1n chia s\u1ebd d\u1eef li\u1ec7u, nh\u1ea5n Ctrl <\/strong><\/em>+ Shift<\/em><\/strong> + \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 nh\u1eefng h\u00e0ng ph\u00eda d\u01b0\u1edbi b\u1ea3ng d\u1eef li\u1ec7u, sau \u0111\u00f3 \u1ea9n ch\u00fang.<\/p>\n

B\u01b0\u1edbc 4: Ch\u1ecdn ph\u1ea7n kh\u00f4ng mu\u1ed1n chia s\u1ebb ph\u00eda tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch nh\u1ea5p d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng, nh\u1ea5n Ctrl<\/em><\/strong>+ Shift<\/em><\/strong> +\u00a0, sau \u0111\u00f3 \u1ea9n ch\u00fang.<\/p>\n

B\u01b0\u1edbc 5: L\u00e0m l\u1ea1i v\u1edbi ph\u1ea7n kh\u00f4ng chia s\u1ebb b\u00ean tr\u00e1i b\u1ea3ng, b\u1ea5m ph\u00edm t\u1eaft Ctrl <\/em><\/strong>+ Shift<\/em><\/strong>+, sau \u0111\u00f3 \u1ea9n ch\u00fang.<\/p>\n

B\u1ea1n c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau<\/p>\n

<\/p>\n

R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/a><\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3255,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3254","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3254"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3254\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3255"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}