1{"id":765,"date":"2021-02-12T09:33:02","date_gmt":"2021-02-12T08:33:02","guid":{"rendered":"https:\/\/www.blitzhandel24.com\/blog\/2021\/02\/12\/word-und-excel-verknuepfen-2\/"},"modified":"2023-05-18T11:57:50","modified_gmt":"2023-05-18T09:57:50","slug":"word-and-excel-knot-2","status":"publish","type":"post","link":"https:\/\/www.blitzhandel24.com\/blog\/2021\/02\/12\/word-and-excel-knot-2\/","title":{"rendered":"Linking Word and Excel &#8211; Tips and Tricks"},"content":{"rendered":"<p>[vc_row][vc_column][vc_custom_heading heading_semantic=&#8220;h1&#8243;]Linking Word and Excel &#8211; tips and tricks[\/vc_custom_heading][vc_column_text]If you want to write and format texts on your PC, Word is definitely the programme of choice. And if you want to create diagrams and carry out calculations, Microsoft Excel is just right. Both together are available in various packages from <a href=\"https:\/\/www.blitzhandel24.com\/office\/office-suiten\/microsoft-office-2019\/\"><span style=\"font-weight: 400\">Microsoft Office<\/span><\/a><span style=\"font-weight: 400\">. But if you want to insert tables or diagrams from Excel into Word, it can be tedious &#8211; an error can quickly creep into the Microsoft Excel source file due to an unclean adjustment. Here we show how this can be prevented. <\/span>[\/vc_column_text][vc_custom_heading]<\/p>\n<h2><span style=\"font-weight: 400\">What Microsoft Excel can do<\/span><\/h2>\n<p>[\/vc_custom_heading][vc_column_text]Basically, Microsoft Excel is a programme specialised in spreadsheets that can be installed on all major devices and operating systems. <b>Its functions in detail:<\/b>[\/vc_column_text][uncode_list]<\/p>\n<ul>\n<li><b>Calculations<\/b> <span style=\"font-weight: 400\">The most important types of calculations can be performed between several cells and supplemented with known variables.<\/span><\/li>\n<li><b>Diagrams and graphics<\/b> <span style=\"font-weight: 400\">Numerical tables can be converted into visual data, for example to show results more clearly in a presentation.<\/span><\/li>\n<li><b>Calendar<\/b> <span style=\"font-weight: 400\">Among other things, schedules and recurring events can be managed.<\/span><\/li>\n<li><b>Inventory management<\/b> <span style=\"font-weight: 400\">Lists of inventory and staging points can be used for automatic calculation.<\/span><\/li>\n<li><b>Time recording<\/b> <span style=\"font-weight: 400\">Project hours, employee times etc. are recorded in tabular form and added up in the result.<\/span><\/li>\n<li><b>Forms<\/b> <span style=\"font-weight: 400\">In addition to ready-made selection options, standardised formulas can be easily created for numerous areas of application.<\/span><\/li>\n<li><b>E-mail lists<\/b> <span style=\"font-weight: 400\">Structured lists with all relevant data are suitable for maintaining an overview, for example of newsletter recipients.<\/span><\/li>\n<li><b>Data analysis<\/b> <span style=\"font-weight: 400\">Detailed data records can be downloaded and saved in csv format, among other things.<\/span><\/li>\n<li><b>Accounting<\/b> <span style=\"font-weight: 400\">Expenditure and budget planning, records and forecasts are automatically calculated and updated.<\/span><\/li>\n<li style=\"list-style-type: none\">\n<ul>\n<li style=\"list-style-type: none\"><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>[\/uncode_list][vc_single_image media=&#8220;1045&#8243; caption=&#8220;yes&#8220; media_width_percent=&#8220;100&#8243;][\/vc_column][\/vc_row][vc_row row_height_percent=&#8220;0&#8243; back_color=&#8220;color-208649&#8243; overlay_alpha=&#8220;50&#8243; gutter_size=&#8220;3&#8243; column_width_percent=&#8220;100&#8243; shift_y=&#8220;0&#8243; z_index=&#8220;0&#8243;][vc_column][vc_custom_heading]<\/p>\n<h2><span style=\"font-weight: 400\">Integrating Microsoft Excel into Word &#8211; this is how it works<\/span><\/h2>\n<p>[\/vc_custom_heading][vc_column_text]To functionally link, for example, Microsoft Excel tables with a Word document, several steps are necessary:[\/vc_column_text][uncode_list]<\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">In the Microsoft Excel document, the relevant table area is first marked and copied to the clipboard.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Then it is pasted into the Word document at the point where the table is to appear. If the table has already been created in the correct format, &#8222;Link and keep original formatting&#8220; must be selected in the insert options. If the table is still to be freely designed, the option &#8222;Link and use target format templates&#8220; is correct <\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">The &#8222;Table design&#8220; and &#8222;Layout&#8220; tabs can be used to adjust the table design.<\/span><\/li>\n<\/ul>\n<p>[\/uncode_list][\/vc_column][\/vc_row][vc_row row_height_percent=&#8220;0&#8243; overlay_alpha=&#8220;50&#8243; gutter_size=&#8220;3&#8243; column_width_percent=&#8220;100&#8243; shift_y=&#8220;0&#8243; z_index=&#8220;0&#8243;][vc_column][vc_custom_heading]<\/p>\n<h3><span style=\"font-weight: 400\">Microsoft 365<\/span><\/h3>\n<p>[\/vc_custom_heading][vc_column_text]With the subscription service <a href=\"https:\/\/www.blitzhandel24.com\/office\/office-suiten\/microsoft-office-365\/\"><span style=\"font-weight: 400\">Microsoft 365<\/span><\/a><span style=\"font-weight: 400\"> ensures that the latest tools from Microsoft are always available <\/span> <span style=\"font-weight: 400\">A distinction is made between Microsoft 365 plans for private use and for businesses, educational institutions and non-profit organisations. The plans include the most important Office desktop apps as well as additional online storage and cloud-connected features for real-time file collaboration. <\/span> <span style=\"font-weight: 400\">The most common for personal use are: <\/span>[\/vc_column_text][uncode_list]<\/p>\n<ul>\n<li style=\"font-weight: 400\"><b>Microsoft 365 Family<\/b><span style=\"font-weight: 400\"> for up to 6 people. Includes AI-powered apps, 1TB of cloud storage per person and advanced security for all your devices.<\/span><\/li>\n<li><b>Microsoft 365 Single<\/b><span style=\"font-weight: 400\"> with the same features as Family, but only for one device.<\/span><\/li>\n<\/ul>\n<p>[\/uncode_list][vc_column_text]<span style=\"font-weight: 400\">Included in<\/span><span style=\"font-weight: 400\">all versions are Word<\/span><span style=\"font-weight: 400\">, Microsoft <\/span><span style=\"font-weight: 400\">Excel<\/span><span style=\"font-weight: 400\">, <\/span><span style=\"font-weight: 400\">PowerPoint<\/span>,<span style=\"font-weight: 400\">OneNote<\/span><span style=\"font-weight: 400\">, <\/span><span style=\"font-weight: 400\">Outlook<\/span><span style=\"font-weight: 400\">, <\/span><span style=\"font-weight: 400\">Access and Publisher.<\/span>[\/vc_column_text][vc_custom_heading]<\/p>\n<h3><span style=\"font-weight: 400\">Microsoft 365 Mac<\/span><\/h3>\n<p>[\/vc_custom_heading][vc_column_text]For Apple users, Microsoft 365 Mac isavailable.<span style=\"font-weight: 400\">Here, too, it is easy to work with Word, Outlook, Microsoft Excel, PowerPoint or OneNote. <\/span> <a href=\"https:\/\/www.blitzhandel24.de\/office\/office-suiten-fuer-mac\/microsoft-office-365-mac\/\"><span style=\"font-weight: 400\">Microsoft 365 Mac<\/span><\/a><span style=\"font-weight: 400\"> was specially developed to support typical Mac functions such as dark mode, camera transfer in macOS or Touch Bar.<\/span>[\/vc_column_text][vc_single_image media=&#8220;1572&#8243; caption=&#8220;yes&#8220; media_width_percent=&#8220;100&#8243;][\/vc_column][\/vc_row][vc_row row_height_percent=&#8220;0&#8243; back_color=&#8220;color-208649&#8243; overlay_alpha=&#8220;50&#8243; gutter_size=&#8220;3&#8243; column_width_percent=&#8220;100&#8243; shift_y=&#8220;0&#8243; z_index=&#8220;0&#8243;][vc_column][vc_custom_heading]<\/p>\n<h2><span style=\"font-weight: 400\">Microsoft Office 2019 &#8211; the better choice?<\/span><\/h2>\n<p>[\/vc_custom_heading][vc_column_text]Buy Microsoft Office instead of subscribing? No problem! This is what <a href=\"https:\/\/www.blitzhandel24.com\/office\/office-suiten\/microsoft-office-2019\/459\/microsoft-office-2019-home-and-student-vollversion-multilanguage-windows\/mac\"><span style=\"font-weight: 400\">Microsoft Office 2019<\/span><\/a><span style=\"font-weight: 400\"> developed. The Office apps such as Word, Outlook or Microsoft Excel for both PC and Mac are only paid for once. After the purchase, the software can either be installed or the Microsoft Office download function can be used. <\/span> <span style=\"font-weight: 400\">Disadvantage: Upgrades are not included in the purchase. If these are desired later, a new main version of Microsoft Office must be purchased at full price. <\/span>[\/vc_column_text][vc_column_text]<\/p>\n<p style=\"text-align: left\">Header image: \u00a9 dennizn, stock.adobe.com<\/p>\n<p>[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column][vc_custom_heading heading_semantic=&#8220;h1&#8243;]Linking Word and Excel &#8211; tips and tricks[\/vc_custom_heading][vc_column_text]If you want to write and format texts on your PC, Word [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":299,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[19],"tags":[197,139,177],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Link Word &amp; Excel - Tips &amp; Tricks - Blitzhandel24 Blog EN<\/title>\n<meta name=\"description\" content=\"You want to insert a chart from Excel into Word but don&#039;t know how? Read our tips &amp; tricks for a link here.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.blitzhandel24.com\/blog\/2021\/02\/12\/word-and-excel-knot-2\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Link Word &amp; Excel - Tips &amp; Tricks - Blitzhandel24 Blog EN\" \/>\n<meta property=\"og:description\" content=\"You want to insert a chart from Excel into Word but don&#039;t know how? Read our tips &amp; tricks for a link here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.blitzhandel24.com\/blog\/2021\/02\/12\/word-and-excel-knot-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blitzhandel24 Blog EN\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-12T08:33:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-18T09:57:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.blitzhandel24.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/02\/AdobeStock_294455803_Editorial_Use_Only-e1613743791937.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"731\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"Blitzhandel24\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"3 Minuten\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.blitzhandel24.com\/blog\/#website\",\"url\":\"https:\/\/www.blitzhandel24.com\/blog\/\",\"name\":\"Blitzhandel24 Blog EN\",\"description\":\"Tips, news and test versions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.blitzhandel24.com\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de-DE\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.blitzhandel24.com\/blog\/2021\/02\/12\/word-and-excel-knot-2\/#primaryimage\",\"inLanguage\":\"de-DE\",\"url\":\"https:\/\/www.blitzhandel24.com\/blog\/wp-content\/uploads\/sites\/2\/2021\/02\/AdobeStock_294455803_Editorial_Use_Only-e1613743791937.jpeg\",\"width\":1200,\"height\":731,\"caption\":\"\\u00a9 dennizn, stock.adobe.com\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.blitzhandel24.com\/blog\/2021\/02\/12\/word-and-excel-knot-2\/#webpage\",\"url\":\"https:\/\/www.blitzhandel24.com\/blog\/2021\/02\/12\/word-and-excel-knot-2\/\",\"name\":\"Link Word & Excel - Tips & Tricks - Blitzhandel24 Blog EN\",\"isPartOf\":{\"@id\":\"https:\/\/www.blitzhandel24.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.blitzhandel24.com\/blog\/2021\/02\/12\/word-and-excel-knot-2\/#primaryimage\"},\"datePublished\":\"2021-02-12T08:33:02+00:00\",\"dateModified\":\"2023-05-18T09:57:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.blitzhandel24.com\/blog\/#\/schema\/person\/6257c55abd7e1513113672741118c959\"},\"description\":\"You want to insert a chart from Excel into Word but don't know how? Read our tips & tricks for a link here.\",\"inLanguage\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.blitzhandel24.com\/blog\/2021\/02\/12\/word-and-excel-knot-2\/\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.blitzhandel24.com\/blog\/#\/schema\/person\/6257c55abd7e1513113672741118c959\",\"name\":\"Blitzhandel24\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.blitzhandel24.com\/blog\/#personlogo\",\"inLanguage\":\"de-DE\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3e61fb26eda3448b136feb36962b7134?s=96&d=mm&r=g\",\"caption\":\"Blitzhandel24\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/posts\/765"}],"collection":[{"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/comments?post=765"}],"version-history":[{"count":3,"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/posts\/765\/revisions"}],"predecessor-version":[{"id":1437,"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/posts\/765\/revisions\/1437"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/media\/299"}],"wp:attachment":[{"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/media?parent=765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/categories?post=765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blitzhandel24.com\/blog\/wp-json\/wp\/v2\/tags?post=765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}