{"id":1519,"date":"2015-07-15T14:54:45","date_gmt":"2015-07-15T12:54:45","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1519"},"modified":"2024-06-12T21:59:42","modified_gmt":"2024-06-12T19:59:42","slug":"quick-access-toolbar-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/quick-access-toolbar-in-excel\/","title":{"rendered":"Quick Access Toolbar"},"content":{"rendered":"<p>The <strong>Quick Access Toolbar (QAT)<\/strong> is located at the top left hand corner of the ribbon and has the most commonly used commands, like the Save, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-redo\/\" target=\"_blank\" rel=\"noopener\">Undo and Redo<\/a>.\u00a0 The QAT is unique to each user\u00b4s workbook settings.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Quick Access Toolbar\" class=\"alignnone size-full wp-image-14055\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-01.png\" alt=\"Quick Access Toolbar\" width=\"281\" height=\"129\" \/><\/p>\n<p>Did you know that you can customize this to your needs? I will show you how to do this below!<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/1BtONVoSEYM?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/QAT.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/QAT.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">QAT.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span>\u00a0You can <strong>move the QAT below or above the ribbon<\/strong> by right-clicking on the QAT and making the selection <em><strong>Show Quick Access Toolbar Below the Ribbon.<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Quick Access Toolbar\" class=\"alignnone size-full wp-image-14056\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-02.png\" alt=\"Quick Access Toolbar\" width=\"536\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-02.png 536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-02-300x91.png 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span>\u00a0You can also <strong>add your favorite commands to the QAT<\/strong> by right-clicking on your favorite command in the ribbon and selecting <em>Add to Quick Access Toolbar<\/em>.<\/p>\n<p>For our example, let us right-click on Bold and select <em><strong>Add to Quick Access Toolbar<\/strong><\/em><em>.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Quick Access Toolbar\" class=\"alignnone size-full wp-image-14057\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-03.png\" alt=\"Quick Access Toolbar\" width=\"509\" height=\"226\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-03.png 509w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-03-300x133.png 300w\" sizes=\"(max-width: 509px) 100vw, 509px\" \/><\/p>\n<p>This will now add the Bold command to our QAT.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Quick Access Toolbar\" class=\"alignnone size-full wp-image-14058\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-04.png\" alt=\"Quick Access Toolbar\" width=\"550\" height=\"201\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-04.png 550w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-04-300x110.png 300w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span>\u00a0Finally, you can <strong>call your QAT commands<\/strong> by pressing the <em>ALT<\/em> key on your keyboard and then pressing the number (e.g. 1,2,3 etc) that appears at the bottom of that command.<\/p>\n<p>In our example, you can use <strong>ALT + 4<\/strong> to call the Bold command.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Quick Access Toolbar\" class=\"alignnone size-full wp-image-14059\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-05.png\" alt=\"Quick Access Toolbar\" width=\"717\" height=\"674\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-05.png 717w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Quick-Access-Toolbar-05-300x282.png 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><strong>How to Use the QAT<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-66.html\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13266\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png\" alt=\"101 Macros Book\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book.png 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-1024x536.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/10\/101-Macros-Book-768x402.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Quick Access Toolbar (QAT) is located at the top left hand corner of the ribbon and has the most commonly used commands, like the Save, Undo and Redo.\u00a0 The QAT is unique to each user\u00b4s workbook settings. Did you know that you can customize this to your needs? I will show you how to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17727,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Quick Access Toolbar","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,7,10,41],"tags":[88,84],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1519"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1519"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1519\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17727"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}