{"id":1717,"date":"2023-11-09T23:32:00","date_gmt":"2023-11-09T23:32:00","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/"},"modified":"2023-12-06T06:19:01","modified_gmt":"2023-12-06T06:19:01","slug":"menyematkan-file","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/","title":{"rendered":"Bagaimana cara menyematkan file di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2201575836\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Secara umum, penyematan berarti memasukkan objek apa pun ke dalam dokumen saat ini. Excel memiliki fungsionalitas bawaan untuk menyematkan file dalam spreadsheet sebagai lampiran.<\/p><p> Dengan fitur ini, Anda dapat menyematkan dokumen baru dan eksternal seperti .xlsx, doc, ppt, pdf, dll. untuk mengembalikannya ke lembar kerja saat ini tanpa mempengaruhi kumpulan data.<\/p><p> Dalam tutorial ini, kami akan menunjukkan cara menyematkan file ke dalam spreadsheet.<\/p><h2 id=\"h-steps-to-embed-a-new-file-in-excel\" class=\"wp-block-heading\"> Langkah-langkah untuk menyematkan file baru di Excel<\/h2><p> Terkadang pengguna perlu menyematkan file kosong baru alih-alih file yang sudah ada di spreadsheet dan untuk itu ikuti langkah-langkah di bawah ini:<\/p><ol><li> Pertama, buka tab \u201cSisipkan\u201d dan klik ikon \u201cTeks\u201d lalu klik opsi \u201cObjek\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"-teks-ikon-opsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dicone-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"text-icon-options\" width=\"639\" height=\"178\"><\/li><li> Setelah itu, pada kotak dialog \u201cObjek\u201d, klik tab \u201cBuat Baru\u201d, lalu pada kolom \u201cJenis Objek\u201d, pilih jenis dokumen yang ingin Anda sematkan.<\/li><li> Setelah dipilih, centang opsi \u201cShow as icon\u201d, lalu klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"-objek dialog\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boite-de-dialogue-2-objets.png\" sizes=\"auto, \" srcset=\"\" alt=\"object-dialog-box\" width=\"501\" height=\"386\"><\/li><\/ol><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Anda hanya dapat memeriksa tipe file baru yang merupakan bagian dari tipe objek tertentu.<\/p><h2 id=\"h-embed-external-files-in-excel\" class=\"wp-block-heading\"> Sematkan file eksternal di Excel<\/h2><ol><li> Pertama, buka tab \u201cSisipkan\u201d dan klik ikon \u201cTeks\u201d lalu klik opsi \u201cObjek\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"-masukkan-tab-dan-teks-ikon\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-inserer-un-onglet-et-une-icone-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"insert-tab-and-text-icon\" width=\"610\" height=\"170\"><\/li><li> Setelah itu, di kotak dialog \u201cObjek\u201d dan klik pada tab \u201cBuat dari File\u201d dan kemudian tombol \u201cJelajahi\u201d untuk memilih file dari sistem lokal Anda. <br><img loading=\"lazy\" decoding=\"async\" title=\"-buat-dari-tab-file\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-creer-a-partir-de-longlet-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-from-file-tab\" width=\"472\" height=\"410\"><\/li><li> Setelah memilih file, centang opsi \u201cShow as icon\u201d agar file tertanam sebagai objek dan klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"-pilih-tampilkan-sebagai-ikon\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-selectionner-laffichage-sous-forme-dicone.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-display-as-icon\" width=\"473\" height=\"365\"><\/li><li> Setelah file yang dipilih tertanam dalam spreadsheet, Anda dapat mengubah ukurannya dengan menempatkan kursor mouse di atas salah satu batas berbentuk bulat, lalu menyeret dan mengecilkannya agar sesuai dengan sel. <br><img loading=\"lazy\" decoding=\"async\" title=\"-mengubah ukuran-file yang disematkan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-redimensionner-le-fichier-integre.png\" sizes=\"auto, \" srcset=\"\" alt=\"resize-the-embedded-file\" width=\"281\" height=\"174\"><\/li><li> Sekarang, untuk mengunci ikon file yang disematkan di dalam sel, klik kanan padanya dan klik opsi &#8220;Format Objek&#8221;. <br><img loading=\"lazy\" decoding=\"async\" title=\"-kunci-file tertanam\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-verrouiller-le-fichier-integre.png\" sizes=\"auto, \" srcset=\"\" alt=\"lock-the-embedded-file\" width=\"306\" height=\"262\"><\/li><li> Terakhir, pada kotak dialog &#8220;Format Objek&#8221;, buka tab &#8220;Properties&#8221;, lalu pilih opsi &#8220;Pindahkan dan ukuran dengan sel&#8221; agar ikon terkunci dan hanya bergerak di dalam sel, lalu klik OK. <img loading=\"lazy\" decoding=\"async\" title=\"-dialog-objek-format\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boite-de-dialogue-dobjet-au-format-8.png\" sizes=\"auto, \" srcset=\"\" alt=\"format-object-dialog-box\" width=\"448\" height=\"429\"><\/li><\/ol><h2 id=\"h-points-to-remember\" class=\"wp-block-heading\"> Kesimpulan<\/h2><ul><li> Saat Anda menyematkan file hanya dengan mencentang opsi &#8220;Tampilkan sebagai ikon&#8221;, file yang disematkan ini akan menjadi bagian dari buku kerja saat ini dan akan dipisahkan dari file sumber. Artinya, jika Anda memperbarui apa pun di file sumber, pembaruan tersebut tidak akan diperbarui di file yang disematkan. Untuk mengedit atau memperbarui apa pun di file yang disematkan, selalu buka file yang disematkan dari spreadsheet tempat file tersebut disematkan dengan mengklik dua kali file tersebut.<\/li><li> Jika Anda juga mencentang opsi &#8220;Tautan ke file&#8221;, file yang disematkan hanya akan ditautkan dan tidak akan menjadi file terpisah dari file sumber. Artinya dalam hal ini jika Anda memperbarui apa pun di file asli, pembaruan tersebut juga akan diperbarui di file yang disematkan dan sebaliknya.<\/li><li> Jika Anda telah menyematkan file dengan mencentang opsi &#8220;Tautan ke File&#8221;, orang lain tidak dapat mengakses file tertaut ini dan akan mendapatkan kesalahan di bawah ini saat mengakses file tertaut ini. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-82901\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-erreur-dacces-au-fichier-lie.png\" sizes=\"auto, \" srcset=\"\" alt=\"kesalahan saat mengakses file tertaut\" width=\"523\" height=\"160\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/alat-kamera\/\">Alat Kamera Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarian-tujuan\/\">Pencari Sasaran di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/\">Jendela tontonan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pemotong-excel\/\">Pemotong Excel (Panduan Lengkap)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/daftar-yang-dipersonalisasi\/\">Daftar Kustom di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pdf-di-excel\/\">Masukkan PDF ke Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/koreksi-otomatis\/\">Koreksi otomatis di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyisipkan-gambar\/\">Sisipkan gambar ke dalam sel di Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1717","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara mengintegrasikan file ke dalam Excel? (Panduan 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menyematkan file ke dalam spreadsheet Excel. Juga, beberapa poin penting yang perlu Anda ketahui.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mengintegrasikan file ke dalam Excel? (Panduan 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menyematkan file ke dalam spreadsheet Excel. Juga, beberapa poin penting yang perlu Anda ketahui.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dicone-de-texte.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/\",\"name\":\"\u25b7 Bagaimana cara mengintegrasikan file ke dalam Excel? (Panduan 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dicone-de-texte.png\",\"datePublished\":\"2023-11-09T23:32:00+00:00\",\"dateModified\":\"2023-12-06T06:19:01+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menyematkan file ke dalam spreadsheet Excel. Juga, beberapa poin penting yang perlu Anda ketahui.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dicone-de-texte.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dicone-de-texte.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menyematkan file di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara mengintegrasikan file ke dalam Excel? (Panduan 2023)","description":"Dalam tutorial ini, Anda akan mempelajari cara menyematkan file ke dalam spreadsheet Excel. Juga, beberapa poin penting yang perlu Anda ketahui.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mengintegrasikan file ke dalam Excel? (Panduan 2023)","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menyematkan file ke dalam spreadsheet Excel. Juga, beberapa poin penting yang perlu Anda ketahui.","og_url":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:01+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dicone-de-texte.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/","url":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/","name":"\u25b7 Bagaimana cara mengintegrasikan file ke dalam Excel? (Panduan 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dicone-de-texte.png","datePublished":"2023-11-09T23:32:00+00:00","dateModified":"2023-12-06T06:19:01+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menyematkan file ke dalam spreadsheet Excel. Juga, beberapa poin penting yang perlu Anda ketahui.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menyematkan-file\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dicone-de-texte.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dicone-de-texte.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menyematkan-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menyematkan file di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1717"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1717\/revisions"}],"predecessor-version":[{"id":2800,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1717\/revisions\/2800"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}