{"id":3477,"date":"2024-12-03T02:39:40","date_gmt":"2024-12-03T02:39:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-co-dinh-shapes-khong-bi-thay-doi-ngoai-y-muon-trong-excel\/"},"modified":"2024-12-03T02:39:40","modified_gmt":"2024-12-03T02:39:40","slug":"huong-dan-cach-co-dinh-shapes-khong-bi-thay-doi-ngoai-y-muon-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-co-dinh-shapes-khong-bi-thay-doi-ngoai-y-muon-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh Shapes kh\u00f4ng b\u1ecb thay \u0111\u1ed5i ngo\u00e0i \u00fd mu\u1ed1n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Shapes l\u00e0 c\u00e1c h\u00ecnh kh\u1ed1i \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o trong\u00a0Excel. Tuy nhi\u00ean\u00a0\u0111\u00f4i khi b\u1ea1n th\u1ea5y k\u00edch th\u01b0\u1edbc c\u1ee7a Shapes thay\u00a0\u0111\u1ed5i m\u1ed9t c\u00e1ch ngo\u00e0i\u00a0\u00fd mu\u1ed1n. V\u1eady l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 kh\u1eafc ph\u1ee5c\u00a0\u0111i\u1ec1u n\u00e0y? h\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch c\u1ed1 \u0111\u1ecbnh Shapes kh\u00f4ng b\u1ecb thay \u0111\u1ed5i ngo\u00e0i \u00fd mu\u1ed1n trong\u00a0Excel nh\u00e9.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674e6f6b75a46\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-co-dinh-shapes-khong-bi-thay-doi-ngoai-y-muon-trong-excel.html#Cach_chen_Shapes_vao_trong_bang_tinh_Excel\" title=\"C\u00e1ch ch\u00e8n Shapes v\u00e0o trong b\u1ea3ng t\u00ednh\u00a0Excel\">C\u00e1ch ch\u00e8n Shapes v\u00e0o trong b\u1ea3ng t\u00ednh\u00a0Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-co-dinh-shapes-khong-bi-thay-doi-ngoai-y-muon-trong-excel.html#Cach_thiet_lap_co_dinh_Shapes_khong_bi_thay_doi_ngoai_y_muon\" title=\"C\u00e1ch thi\u1ebft l\u1eadp\u00a0c\u1ed1 \u0111\u1ecbnh Shapes kh\u00f4ng b\u1ecb thay \u0111\u1ed5i ngo\u00e0i \u00fd mu\u1ed1n\">C\u00e1ch thi\u1ebft l\u1eadp\u00a0c\u1ed1 \u0111\u1ecbnh Shapes kh\u00f4ng b\u1ecb thay \u0111\u1ed5i ngo\u00e0i \u00fd mu\u1ed1n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_chen_Shapes_vao_trong_bang_tinh_Excel\"><\/span>C\u00e1ch ch\u00e8n Shapes v\u00e0o trong b\u1ea3ng t\u00ednh\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u1eafc l\u1ea1i m\u1ed9t ch\u00fat v\u1ec1 c\u00e1ch ch\u00e8n Shapes v\u00e0o trong\u00a0Excel nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Trong <strong>th\u1ebb\u00a0Insert<\/strong> ch\u1ecdn <strong>Shapes<\/strong> (thu\u1ed9c nh\u00f3m illustrations)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25459\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-shapes.png\" width=\"599\" height=\"155\" title=\"insert-shapes\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Ch\u1ecdn h\u00ecnh kh\u1ed1i m\u00e0 b\u1ea1n mu\u1ed1n th\u1ec3 hi\u1ec7n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25460\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chon-shape-de-insert.png\" width=\"342\" height=\"423\" title=\"chon-shape-de-insert\"><\/p>\n<p>C\u00f3 r\u1ea5t nhi\u1ec1u lo\u1ea1i h\u00ecnh kh\u1ed1i, trong\u00a0\u0111\u00f3 hay d\u00f9ng l\u00e0:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-268.gif\" title=\"ex101_92019-nho-268\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>H\u00ecnh ch\u1eef nh\u1eadt (nh\u00f3m<strong> Rectangles<\/strong>)<\/li>\n<li>H\u00ecnh\u00a0\u0111\u01b0\u1eddng k\u1ebb, m\u0169i t\u00ean (nh\u00f3m <strong>Lines<\/strong>)<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: Thi\u1ebft l\u1eadp t\u00f4 m\u00e0u,\u00a0\u0111\u1ecbnh d\u1ea1ng\u2026 cho h\u00ecnh kh\u1ed1i theo\u00a0\u00fd mu\u1ed1n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25461\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dinh-dang-cho-shapes.png\" width=\"996\" height=\"199\" title=\"dinh-dang-cho-shapes\"><\/p>\n<p>Khi ch\u1ecdn h\u00ecnh kh\u1ed1i\u00a0\u0111\u00e3 ch\u00e8n v\u00e0o trong b\u1ea3ng t\u00ednh, tr\u00ean thanh c\u00f4ng c\u1ee5 s\u1ebd xu\u1ea5t hi\u1ec7n th\u1ebb Drawing Tools &gt; Format. T\u1ea1i\u00a0\u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3\u00a0\u0111\u1ecbnh d\u1ea1ng cho h\u00ecnh kh\u1ed1i v\u1ec1 m\u00e0u s\u1eafc,\u00a0\u0111\u01b0\u1eddng vi\u1ec1n, m\u00e0u ch\u1eef b\u00ean trong h\u00ecnh kh\u1ed1i\u2026<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thiet_lap_co_dinh_Shapes_khong_bi_thay_doi_ngoai_y_muon\"><\/span>C\u00e1ch thi\u1ebft l\u1eadp\u00a0c\u1ed1 \u0111\u1ecbnh Shapes kh\u00f4ng b\u1ecb thay \u0111\u1ed5i ngo\u00e0i \u00fd mu\u1ed1n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y, ch\u00fang ta d\u1ef1a v\u00e0o 1 thu\u1ed9c t\u00ednh c\u1ee7a Shapes. C\u00e1ch thi\u1ebft l\u1eadp nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o Shapes c\u1ea7n thi\u1ebft l\u1eadp, ch\u1ecdn <strong>Size and Properties<\/strong>. Khi ch\u1ecdn n\u1ed9i dung n\u00e0y s\u1ebd xu\u1ea5t hi\u1ec7n c\u1eeda s\u1ed5 Format Shape ph\u00eda b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh\u00a0Excel<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25462\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/shapes-size-and-properties-setting.png\" width=\"289\" height=\"500\" title=\"shapes-size-and-properties-setting\"><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: Trong c\u1eeda s\u1ed5 Format Shape ch\u1ecdn Properties &gt;\u00a0\u0110\u00e1nh d\u1ea5u v\u00e0o m\u1ee5c <strong>Don\u2019t move\u00a0or size\u00a0with cells<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25463\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/shapes-size-and-properties-dont-move-or-size-with-cells.png\" width=\"342\" height=\"607\" title=\"shapes-size-and-properties-dont-move-or-size-with-cells\"><\/p>\n<p>Trong thu\u1ed9c t\u00ednh Properties c\u1ee7a Shape, ta c\u00f3 3 l\u1ef1a ch\u1ecdn:<\/p>\n<ul>\n<li><strong>Move and size\u00a0with cells<\/strong>: di chuy\u1ec3n v\u00e0 thay\u00a0\u0111\u1ed5i k\u00edch th\u01b0\u1edbc (co d\u00e3n) theo\u00a0\u00f4 t\u1ea1i n\u01a1i\u00a0\u0111\u1eb7t Shape<\/li>\n<li><strong>Move but don\u2019t size\u00a0with cells<\/strong>: c\u00f3 di chuy\u1ec3n\u00a0nh\u01b0ng kh\u00f4ng l\u00e0m\u00a0thay\u00a0\u0111\u1ed5i k\u00edch th\u01b0\u1edbc (co d\u00e3n) theo\u00a0\u00f4 t\u1ea1i n\u01a1i\u00a0\u0111\u1eb7t Shape<\/li>\n<li><strong>Don\u2019t move and size\u00a0with cells<\/strong>: kh\u00f4ng di chuy\u1ec3n v\u00e0 thay\u00a0\u0111\u1ed5i k\u00edch th\u01b0\u1edbc (co d\u00e3n) theo\u00a0\u00f4 t\u1ea1i n\u01a1i\u00a0\u0111\u1eb7t Shape<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady v\u1edbi 2 l\u1ef1a ch\u1ecdn Don\u2019t size v\u00e0 Don\u2019t move, ch\u00fang ta\u00a0\u0111\u1ec1u th\u1ea5y Shape s\u1ebd kh\u00f4ng thay\u00a0\u0111\u1ed5i k\u00edch th\u01b0\u1edbc theo\u00a0\u00f4 t\u1ea1i v\u1ecb tr\u00ed n\u00f3<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau\u00a0\u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-cac-doi-tuong-hoa.html\">H\u01b0\u1edbng d\u1eabn thao t\u00e1c v\u1edbi c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u1ed3 h\u1ecda trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-gan-macro-vao-bieu-tuong-nut-dieu-khien-tao-boi-shapes-trong-excel.html\">C\u00e1ch g\u00e1n macro v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n t\u1ea1o b\u1edfi Shapes trong Excel<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-268.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3478,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3477","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3477","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=3477"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3477\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3478"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}