{"id":513,"date":"2018-06-28T11:38:57","date_gmt":"2018-06-28T11:38:57","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=513"},"modified":"2024-03-30T11:00:58","modified_gmt":"2024-03-30T11:00:58","slug":"quick-access-toolbar","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/","title":{"rendered":"Quick Access Toolbar in Excel"},"content":{"rendered":"\n<p><strong>Quick Access Toolbar<\/strong> was created to give users easy access to frequently used options and features. It is located above the ribbon, and like the ribbon, it can also be adjusted to your preferences.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"164\" height=\"25\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png\" alt=\"\" class=\"wp-image-514\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading format\">Changing the position of the Quick Access Toolbar<\/h2>\n\n\n\n<p>By default, the toolbar is located above the ribbon. If you want to change its position and move it below, click the&nbsp;<strong>Customize Quick Access Toolbar<\/strong>&nbsp;button (it is located to the right of the toolbar) and choose&nbsp;<strong>Show Below the Ribbon<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"213\" height=\"65\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbat-below-the-ribbon.png\" alt=\"\" class=\"wp-image-515\"\/><\/figure>\n\n\n\n<p>If you want to restore the Quick Access Toolbar to its original position, select&nbsp;<strong>Show<\/strong><strong> Above the <a href=\"https:\/\/officetuts.net\/excel\/training\/ribbon\/\">Ribbon<\/a><\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading format\">Selecting additional options<\/h2>\n\n\n\n<p>After you click the&nbsp;<strong>Customize Quick Access Toolbar<\/strong>&nbsp;button, the menu with the list of several different items will appear. Some of them are selected by default (you can unselect them). These are&nbsp;<strong>Save, Undo,<\/strong>&nbsp;and&nbsp;<strong>Redo.&nbsp;<\/strong>If you want to add additional options, just click one of them, and the new icon will appear in the Quick Access Toolbar.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"189\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/additional-options.png\" alt=\"\" class=\"wp-image-516\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/additional-options.png 473w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/additional-options-300x120.png 300w\" sizes=\"(max-width: 473px) 100vw, 473px\" \/><\/figure>\n\n\n\n<p>If you want to add some additional options that are not present on the list, click the&nbsp;<strong>More Commands&nbsp;<\/strong>position, which is located at the bottom of the menu.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"855\" height=\"422\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar-additional-buttons.png\" alt=\"\" class=\"wp-image-517\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar-additional-buttons.png 855w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar-additional-buttons-300x148.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar-additional-buttons-768x379.png 768w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/figure>\n\n\n\n<p>From the menu to the left, click one of the buttons, then click&nbsp;<strong>Add.<\/strong>&nbsp;When you click&nbsp;<strong>OK,<\/strong>&nbsp;the new items will appear in the toolbar.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"239\" height=\"23\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/toolbar-additional-icons.png\" alt=\"\" class=\"wp-image-518\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading format\">Removing unnecessary icons<\/h2>\n\n\n\n<p>To get rid of the icon from the toolbar, right-click it and from the drop-down menu, select&nbsp;<strong>Remove from Quick Access Toolbar<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel 365 Update<\/h2>\n\n\n\n<ul>\n<li><strong>Visible by Default:<\/strong>&nbsp;Unlike Excel 2016, Excel 365 shows the Quick Access Toolbar (QAT) by default, providing immediate access to commonly used functions.<\/li>\n\n\n\n<li><strong>Customization Carries Over:<\/strong>&nbsp;Users familiar with customizing the QAT in Excel 2016 can continue to do so in Excel 365. Add frequently used commands for a personalized experience.<\/li>\n\n\n\n<li><strong>Core Functionality Remains:<\/strong>\u00a0The core functionality of adding, removing, and rearranging commands on the QAT remains unchanged from Excel 2016.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Quick Access Toolbar was created to give users easy access to frequently used options and features. It is located above the ribbon, and&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[188,190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Quick Access Toolbar in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to customize the Quick Access Toolbar in Excel - change its position, add or remove options, and create your own shortcuts for frequently used features.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Quick Access Toolbar in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to customize the Quick Access Toolbar in Excel - change its position, add or remove options, and create your own shortcuts for frequently used features.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-28T11:38:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-30T11:00:58+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Quick Access Toolbar in Excel\",\"datePublished\":\"2018-06-28T11:38:57+00:00\",\"dateModified\":\"2024-03-30T11:00:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/\"},\"wordCount\":337,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png\",\"keywords\":[\"added\",\"pinterest\"],\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/\",\"name\":\"Quick Access Toolbar in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png\",\"datePublished\":\"2018-06-28T11:38:57+00:00\",\"dateModified\":\"2024-03-30T11:00:58+00:00\",\"description\":\"Learn how to customize the Quick Access Toolbar in Excel - change its position, add or remove options, and create your own shortcuts for frequently used features.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Quick Access Toolbar in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Quick Access Toolbar in Excel","description":"Learn how to customize the Quick Access Toolbar in Excel - change its position, add or remove options, and create your own shortcuts for frequently used features.","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:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/","og_locale":"en_US","og_type":"article","og_title":"Quick Access Toolbar in Excel","og_description":"Learn how to customize the Quick Access Toolbar in Excel - change its position, add or remove options, and create your own shortcuts for frequently used features.","og_url":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/","article_published_time":"2018-06-28T11:38:57+00:00","article_modified_time":"2024-03-30T11:00:58+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Quick Access Toolbar in Excel","datePublished":"2018-06-28T11:38:57+00:00","dateModified":"2024-03-30T11:00:58+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/"},"wordCount":337,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png","keywords":["added","pinterest"],"articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/","url":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/","name":"Quick Access Toolbar in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png","datePublished":"2018-06-28T11:38:57+00:00","dateModified":"2024-03-30T11:00:58+00:00","description":"Learn how to customize the Quick Access Toolbar in Excel - change its position, add or remove options, and create your own shortcuts for frequently used features.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/quick-access-toolbar.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/quick-access-toolbar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Quick Access Toolbar in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/513"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=513"}],"version-history":[{"count":7,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/513\/revisions"}],"predecessor-version":[{"id":17416,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/513\/revisions\/17416"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}