{"id":19087,"date":"2019-02-03T08:53:18","date_gmt":"2019-02-03T08:53:18","guid":{"rendered":"https:\/\/www.testingdocs.com\/questions\/?p=19087"},"modified":"2024-08-09T06:59:11","modified_gmt":"2024-08-09T06:59:11","slug":"how-to-enable-developer-tab-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.testingdocs.com\/questions\/how-to-enable-developer-tab-in-microsoft-excel\/","title":{"rendered":"How to enable Developer tab in Microsoft Excel?"},"content":{"rendered":"<h2>How to enable Developer tab in Microsoft Excel?<\/h2>\n<p>Let&#8217;s see how we can enable the Developer tab in Excel application on Windows platform. Developer tab is packed with features like :<\/p>\n<ul>\n<li>Visual Basic Editor<\/li>\n<li>Record Macros<\/li>\n<li>Excel Add-ins, etc<\/li>\n<\/ul>\n<p>Excel version:<\/p>\n<p>Excel Office 2019.<\/p>\n<h3>Enable Develop Tab<\/h3>\n<p>Steps to enable the Developer tab are as follows:<\/p>\n<p>Launch the Excel Application.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19091\" src=\"https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Excel-Options.png\" alt=\"Excel Options\" width=\"1342\" height=\"1004\" title=\"\" srcset=\"https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Excel-Options.png 1342w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Excel-Options-300x224.png 300w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Excel-Options-1024x766.png 1024w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Excel-Options-768x575.png 768w\" sizes=\"auto, (max-width: 1342px) 100vw, 1342px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Choose <strong>File &gt;&gt; More&#8230; &gt;&gt; Options\u00a0<\/strong> tab<\/p>\n<p>In the Excel options window, Click on the &#8216;<strong>Customize Ribbon<\/strong>&#8216; Excel options.<\/p>\n<p>Check on the <strong>Developer<\/strong> check box.<\/p>\n<p>Click on the <strong>OK\u00a0 <\/strong>button.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19090\" src=\"https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Developer-Tab.png\" alt=\"Developer Tab\" width=\"1574\" height=\"1014\" title=\"\" srcset=\"https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Developer-Tab.png 1574w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Developer-Tab-300x193.png 300w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Developer-Tab-1024x660.png 1024w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Developer-Tab-768x495.png 768w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Developer-Tab-1536x990.png 1536w\" sizes=\"auto, (max-width: 1574px) 100vw, 1574px\" \/><\/p>\n<p>We can notice a new tab added to the Excel ribbon.<\/p>\n<h3>Features<\/h3>\n<p>Some of the features and functions that we can perform on this tab:<\/p>\n<p><strong>Visual Basic<\/strong><\/p>\n<ul>\n<li>\u00a0VB Code Editor<\/li>\n<li>\u00a0Design Forms<\/li>\n<li>\u00a0Run VB Code<\/li>\n<\/ul>\n<p><strong>Macros<\/strong><\/p>\n<ul>\n<li>Record macros<\/li>\n<\/ul>\n<p>Import XML data.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-19092\" src=\"https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Visual-Basic-Editor-Excel.png\" alt=\"Visual Basic Editor Excel\" width=\"1413\" height=\"890\" title=\"\" srcset=\"https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Visual-Basic-Editor-Excel.png 1413w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Visual-Basic-Editor-Excel-300x189.png 300w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Visual-Basic-Editor-Excel-1024x645.png 1024w, https:\/\/www.testingdocs.com\/questions\/wp-content\/uploads\/Visual-Basic-Editor-Excel-768x484.png 768w\" sizes=\"auto, (max-width: 1413px) 100vw, 1413px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to enable Developer tab in Microsoft Excel? Let&#8217;s see how we can enable the Developer tab in Excel application on Windows platform. Developer tab is packed with features like : Visual Basic Editor Record Macros Excel Add-ins, etc Excel version: Excel Office 2019. Enable Develop Tab Steps to enable the Developer tab are as [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-19087","post","type-post","status-publish","format-standard","hentry","category-windows","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"_links":{"self":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/19087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/comments?post=19087"}],"version-history":[{"count":7,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/19087\/revisions"}],"predecessor-version":[{"id":23741,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/19087\/revisions\/23741"}],"wp:attachment":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/media?parent=19087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/categories?post=19087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/tags?post=19087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}