{"id":1897,"date":"2015-03-01T14:10:21","date_gmt":"2015-03-01T03:10:21","guid":{"rendered":"http:\/\/excelatfinance.com\/online\/?page_id=1897"},"modified":"2015-03-27T18:58:29","modified_gmt":"2015-03-27T07:58:29","slug":"dialog-launcher","status":"publish","type":"page","link":"https:\/\/excelatfinance.com\/online\/dialog-launcher\/","title":{"rendered":"Dialog box launcher"},"content":{"rendered":"<p><?php include \"..\/includes\/access.php\"; ?><\/p>\n<h2>Launcher<\/h2>\n<p>Since the replacement of the Excel 2003 style menu with the Excel 2007 ribbon, many items from the previous menu system were not included in the ribbon. Instead a <strong>Dialog Box<\/strong> launcher control was included in certain <strong>Groups<\/strong> on the ribbon providing access to off ribbon controls. The <strong>Clipboard<\/strong> group, <strong>Dialog Box<\/strong> launcher is shown in figure 1.<\/p>\n<figure><a href=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png\"><img data-attachment-id=\"1896\" data-permalink=\"https:\/\/excelatfinance.com\/online\/dialog-launcher\/xlf-ribbon-launcher-group\/\" data-orig-file=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?fit=1305%2C244&amp;ssl=1\" data-orig-size=\"1305,244\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"xlf-ribbon-launcher-group\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?fit=300%2C56&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?fit=625%2C117&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?resize=625%2C117\" alt=\"xlf-ribbon-launcher-group\" width=\"625\" height=\"117\" class=\"alignnone size-large wp-image-1896\" srcset=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?resize=1024%2C191&amp;ssl=1 1024w, https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?resize=150%2C28&amp;ssl=1 150w, https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?resize=300%2C56&amp;ssl=1 300w, https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?resize=624%2C117&amp;ssl=1 624w, https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?w=1305&amp;ssl=1 1305w, https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-ribbon-launcher-group.png?w=1250 1250w\" sizes=\"(max-width: 625px) 100vw, 625px\" data-recalc-dims=\"1\" \/><\/a><figcaption><strong>Fig 1. Excel 2013 Dialog Launcher<\/strong> &#8211; showing the Dialog Box launcher &#8211; in the bottom right corner of the Clipboard group<\/figcaption><\/figure>\n<h2>The Font, Alignment, and Number &#8211; Dialog box launchers<\/h2>\n<p>Looking at the <strong>Font<\/strong> group in figure 1, the <strong>Dialog Box<\/strong> launcher opens the Format Cells dialog box with the Font tab active, see figure 2. Similarly, the Alignment <strong>Dialog Box<\/strong> launcher opens the same box with the Alignment tab active, and the same logic applies to the Number group &#8211; Number tab combination.<\/p>\n<figure><a href=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-format-cells-dialog-font-tab.png\"><img data-attachment-id=\"1916\" data-permalink=\"https:\/\/excelatfinance.com\/online\/dialog-launcher\/xlf-format-cells-dialog-font-tab\/\" data-orig-file=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-format-cells-dialog-font-tab.png?fit=531%2C461&amp;ssl=1\" data-orig-size=\"531,461\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"xlf-format-cells-dialog-font-tab\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-format-cells-dialog-font-tab.png?fit=300%2C260&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-format-cells-dialog-font-tab.png?fit=531%2C461&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-format-cells-dialog-font-tab.png?resize=531%2C461\" alt=\"xlf-format-cells-dialog-font-tab\" width=\"531\" height=\"461\" class=\"alignnone size-full wp-image-1916\" srcset=\"https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-format-cells-dialog-font-tab.png?w=531&amp;ssl=1 531w, https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-format-cells-dialog-font-tab.png?resize=150%2C130&amp;ssl=1 150w, https:\/\/i0.wp.com\/excelatfinance.com\/online\/wp-content\/uploads\/2015\/03\/xlf-format-cells-dialog-font-tab.png?resize=300%2C260&amp;ssl=1 300w\" sizes=\"(max-width: 531px) 100vw, 531px\" data-recalc-dims=\"1\" \/><\/a><figcaption><strong>Fig 2. Excel 2013 ribbon <\/strong> &#8211; &#8211; for the Font group, showing the Font tab active<\/figcaption><\/figure>\n<p><\/p>\n<p>In Excel 2013, the default ribbon includes the following <strong>Dialog Box<\/strong> launcher items.<\/p>\n<ul>\n<li>Home\n<ul style=\"list-style-type: none;\">\n<li>Clipboard<\/li>\n<li>Font<\/li>\n<li>Alignment<\/li>\n<li>Number<\/li>\n<\/li>\n<\/ul>\n<\/ul>\n<ul>\n<li>Insert\n<ul style=\"list-style-type: none;\">\n<li>Charts<\/li>\n<\/ul>\n<\/ul>\n<ul>\n<li>Page Layout\n<ul style=\"list-style-type: none;\">\n<li>Page Setups<\/li>\n<li>Sheet Options<\/li>\n<\/li>\n<\/ul>\n<\/ul>\n<ul>\n<li>Data\n<ul style=\"list-style-type: none;\">\n<li>Outline<\/li>\n<\/ul>\n<\/ul>\n<p>Other <strong>Dialog Box<\/strong> launcher items are on Contextual tabs, such as the Chart Tools contextual tab. <\/p>\n<p><?php include '..\/includes\/next-prev.php'; ?><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Launcher Since the replacement of the Excel 2003 style menu with the Excel 2007 ribbon, many items from the previous menu system were not included in the ribbon. Instead a Dialog Box launcher control was included in certain Groups on the ribbon providing access to off ribbon controls. The Clipboard group, Dialog Box launcher is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false},"jetpack_shortlink":"https:\/\/wp.me\/P59BC0-uB","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/pages\/1897"}],"collection":[{"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/comments?post=1897"}],"version-history":[{"count":2,"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/pages\/1897\/revisions"}],"predecessor-version":[{"id":2328,"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/pages\/1897\/revisions\/2328"}],"wp:attachment":[{"href":"https:\/\/excelatfinance.com\/online\/wp-json\/wp\/v2\/media?parent=1897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}