{"id":187,"date":"2015-06-14T19:46:23","date_gmt":"2015-06-14T18:46:23","guid":{"rendered":"http:\/\/www.mathsfiles.com\/blog\/?p=187"},"modified":"2015-06-14T19:55:27","modified_gmt":"2015-06-14T18:55:27","slug":"setting-up-excel-for-advanced-work","status":"publish","type":"post","link":"https:\/\/www.mathsfiles.com\/blog\/2015\/06\/14\/setting-up-excel-for-advanced-work\/","title":{"rendered":"Setting Up Excel for Advanced Work"},"content":{"rendered":"<p><strong>This covers <\/strong><strong>Customizing the Quick Access Toolbar and enabling the Developer Tab f<\/strong><strong>or Excel 2007 onwards:<\/strong><\/p>\n<p>If you want to work with Macros and other Advanced features in Excel you need to show the Developer Tab and it&#8217;s also a good idea to customize the Quick Access Toolbar to give you easy access to the key tools.<\/p>\n<figure id=\"attachment_188\" aria-describedby=\"caption-attachment-188\" style=\"width: 899px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/www.mathsfiles.com\/blog\/wp-content\/uploads\/2015\/06\/Customized-Excel.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-188 size-full\" src=\"https:\/\/i0.wp.com\/www.mathsfiles.com\/blog\/wp-content\/uploads\/2015\/06\/Customized-Excel.png?resize=604%2C42&#038;ssl=1\" alt=\"Excel after customization\" width=\"604\" height=\"42\" srcset=\"https:\/\/i0.wp.com\/www.mathsfiles.com\/blog\/wp-content\/uploads\/2015\/06\/Customized-Excel.png?w=899&amp;ssl=1 899w, https:\/\/i0.wp.com\/www.mathsfiles.com\/blog\/wp-content\/uploads\/2015\/06\/Customized-Excel.png?resize=300%2C21&amp;ssl=1 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/a><figcaption id=\"caption-attachment-188\" class=\"wp-caption-text\">Excel after customization<\/figcaption><\/figure>\n<p>There are two files on <a href=\"http:\/\/www.mathsfiles.com\/Excel.html\" target=\"_blank\">www.mathsfiles.com\/Excel_Files<\/a> in the techniques section that show how to do this.<\/p>\n<p>Direct links:<br \/>\n<a href=\"http:\/\/www.mathsfiles.com\/Demos\/Customizing%20Excel%202007.demo\/Setting%20up%20and%20Customizing%20the%20Interface.pdf\" target=\"_blank\">Instructions pdf file<\/a><\/p>\n<p><a href=\"http:\/\/www.mathsfiles.com\/Demos\/Customizing%20Excel%202007.demo\/Customizing%20Excel%202007.html\" target=\"_blank\">Watch a Demo<\/a> (based on Excel 2007)<br \/>\nNote: The process is much the same for later versions of Excel but the way to show the Developer Tab is found by going to Excel Options and then the section for Customizing the Ribbon. Just\u00a0 check the box for the Developer Tab.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This covers Customizing the Quick Access Toolbar and enabling the Developer Tab for Excel 2007 onwards: If you want to work with Macros and other Advanced features in Excel you need to show the Developer Tab and it&#8217;s also a good idea to customize the Quick Access Toolbar to give you easy access to the &hellip; <a href=\"https:\/\/www.mathsfiles.com\/blog\/2015\/06\/14\/setting-up-excel-for-advanced-work\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Setting Up Excel for Advanced Work<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[18,19,20,17],"tags":[27,3,5,28],"class_list":["post-187","post","type-post","status-publish","format-standard","hentry","category-excel-files","category-excel-macros","category-excel-techniques","category-mathsfiles-com-resources","tag-developer-tab","tag-excel","tag-macros","tag-quick-access-toolbar"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6flNW-31","_links":{"self":[{"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/posts\/187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/comments?post=187"}],"version-history":[{"count":3,"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/posts\/187\/revisions"}],"predecessor-version":[{"id":191,"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/posts\/187\/revisions\/191"}],"wp:attachment":[{"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/media?parent=187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/categories?post=187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mathsfiles.com\/blog\/wp-json\/wp\/v2\/tags?post=187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}