True or false in excel, you can add your most commonly used commands to the quick access toolbar.

{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2016-03-26T21:20:26+00:00","modifiedTime":"2016-03-26T21:20:26+00:00","timestamp":"2022-02-24T16:57:19+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"//dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"//dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"//dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"//dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"How to Customize the Excel 2010 Quick Access Toolbar","strippedTitle":"how to customize the excel 2010 quick access toolbar","slug":"how-to-customize-the-excel-2010-quick-access-toolbar","canonicalUrl":"","seo":{"metaDescription":"","noIndex":0,"noFollow":0},"content":"<p>The Quick Access toolbar in Excel 2010 appears above the Ribbon and includes buttons for commonly used commands. By default, the Quick Access toolbar contains only the Save, Undo, and Redo commands, but you can add more.</p>\n<p class=\"Tip\">To display the Quick Access toolbar beneath the Ribbon, click the Customize Quick Access Toolbar button (on the right end of the toolbar) and choose Show Below the Ribbon on the drop-down menu.</p>\n<h2 id=\"tab1\" >Add buttons to the Quick Access toolbar</h2>\n<p>You can click the Customize Quick Access Toolbar button to easily add other common Excel 2010 commands to this toolbar. The resulting drop-down menu contains more common commands. To add any of these commands to the toolbar, simply click the option on the drop-down menu. Excel adds a button for that command to the end of the Quick Access toolbar (and a check mark to its option on the drop-down menu).</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//sg.cdnki.com/true-or-false-in-excel-you-can-add-your-most-commonly-used-commands-to-the-quick-access-toolbar---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzLzIwMjA4MC5pbWFnZTAuanBn.webp\" width=\"535\" height=\"400\" alt=\"Use this menu to add common commands to the Quick Access toolbar.\"/><div class=\"imageCaption\">Use this menu to add common commands to the Quick Access toolbar.</div></div>\n<p>To add any Ribbon command to the Quick Access toolbar, right-click its command button on the Ribbon and then choose Add to Quick Access Toolbar on the shortcut menu.</p>\n<h2 id=\"tab2\" >Add non-Ribbon commands to the Quick Access toolbar</h2>\n<p>To add a non-Ribbon command to the Quick Access toolbar, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Click the Customize Quick Access Toolbar button and then click the More Commands option near the bottom of the drop-down menu.</p>\n<p class=\"child-para\">Excel displays the Excel Options dialog box with the Quick Access Toolbar tab selected. On the right, Excel shows all the buttons currently on the Quick Access toolbar in the order they appear on the toolbar.</p>\n<div class=\"imageBlock\" style=\"width:499px;\"><img src=\"//sg.cdnki.com/true-or-false-in-excel-you-can-add-your-most-commonly-used-commands-to-the-quick-access-toolbar---aHR0cHM6Ly93d3cuZHVtbWllcy5jb20vd3AtY29udGVudC91cGxvYWRzLzIwMjA4MS5pbWFnZTEuanBn.webp\" width=\"499\" height=\"400\" alt=\"Use the Excel Options dialog box to add any Excel 2010 command to the Quick Access toolbar.\"/><div class=\"imageCaption\">Use the Excel Options dialog box to add any Excel 2010 command to the Quick Access toolbar.</div></div>\n </li>\n <li><p class=\"first-para\">Select the type of command you want to add from the Choose Commands From drop-down list.</p>\n<p class=\"child-para\">For example, if you want to display only the commands that do not appear on the Ribbon, select Commands Not in the Ribbon.</p>\n </li>\n <li><p class=\"first-para\">Click the command you want to add to the Quick Access toolbar in the list on the left and click the Add button.</p>\n<p class=\"child-para\">The command button appears at the bottom of the list on the right.</p>\n </li>\n <li><p class=\"first-para\">Use the Move Up and Move Down buttons to reorder buttons on the Quick Access toolbar.</p>\n </li>\n <li><p class=\"first-para\">Click OK.</p>\n<p class=\"child-para\">The Excel Options dialog box closes and the button appears in the Quick Access toolbar.</p>\n </li>\n</ol>\n<p>To quickly remove a button from the Quick Access toolbar, right-click it and then select Remove from Quick Access Toolbar on the shortcut menu. You can reset the Quick Access toolbar to its original configuration by clicking the Reset button on the Quick Access Toolbar tab of the Excel Options dialog box.</p>","description":"<p>The Quick Access toolbar in Excel 2010 appears above the Ribbon and includes buttons for commonly used commands. By default, the Quick Access toolbar contains only the Save, Undo, and Redo commands, but you can add more.</p>\n<p class=\"Tip\">To display the Quick Access toolbar beneath the Ribbon, click the Customize Quick Access Toolbar button (on the right end of the toolbar) and choose Show Below the Ribbon on the drop-down menu.</p>\n<h2 id=\"tab1\" >Add buttons to the Quick Access toolbar</h2>\n<p>You can click the Customize Quick Access Toolbar button to easily add other common Excel 2010 commands to this toolbar. The resulting drop-down menu contains more common commands. To add any of these commands to the toolbar, simply click the option on the drop-down menu. Excel adds a button for that command to the end of the Quick Access toolbar (and a check mark to its option on the drop-down menu).</p>\n<div class=\"imageBlock\" style=\"width:535px;\"><img src=\"//www.dummies.com/wp-content/uploads/202080.image0.jpg\" width=\"535\" height=\"400\" alt=\"Use this menu to add common commands to the Quick Access toolbar.\"/><div class=\"imageCaption\">Use this menu to add common commands to the Quick Access toolbar.</div></div>\n<p>To add any Ribbon command to the Quick Access toolbar, right-click its command button on the Ribbon and then choose Add to Quick Access Toolbar on the shortcut menu.</p>\n<h2 id=\"tab2\" >Add non-Ribbon commands to the Quick Access toolbar</h2>\n<p>To add a non-Ribbon command to the Quick Access toolbar, follow these steps:</p>\n<ol class=\"level-one\">\n <li><p class=\"first-para\">Click the Customize Quick Access Toolbar button and then click the More Commands option near the bottom of the drop-down menu.</p>\n<p class=\"child-para\">Excel displays the Excel Options dialog box with the Quick Access Toolbar tab selected. On the right, Excel shows all the buttons currently on the Quick Access toolbar in the order they appear on the toolbar.</p>\n<div class=\"imageBlock\" style=\"width:499px;\"><img src=\"//www.dummies.com/wp-content/uploads/202081.image1.jpg\" width=\"499\" height=\"400\" alt=\"Use the Excel Options dialog box to add any Excel 2010 command to the Quick Access toolbar.\"/><div class=\"imageCaption\">Use the Excel Options dialog box to add any Excel 2010 command to the Quick Access toolbar.</div></div>\n </li>\n <li><p class=\"first-para\">Select the type of command you want to add from the Choose Commands From drop-down list.</p>\n<p class=\"child-para\">For example, if you want to display only the commands that do not appear on the Ribbon, select Commands Not in the Ribbon.</p>\n </li>\n <li><p class=\"first-para\">Click the command you want to add to the Quick Access toolbar in the list on the left and click the Add button.</p>\n<p class=\"child-para\">The command button appears at the bottom of the list on the right.</p>\n </li>\n <li><p class=\"first-para\">Use the Move Up and Move Down buttons to reorder buttons on the Quick Access toolbar.</p>\n </li>\n <li><p class=\"first-para\">Click OK.</p>\n<p class=\"child-para\">The Excel Options dialog box closes and the button appears in the Quick Access toolbar.</p>\n </li>\n</ol>\n<p>To quickly remove a button from the Quick Access toolbar, right-click it and then select Remove from Quick Access Toolbar on the shortcut menu. You can reset the Quick Access toolbar to its original configuration by clicking the Reset button on the Quick Access Toolbar tab of the Excel Options dialog box.</p>","blurb":"","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"//dummies-api.dummies.com/v2/authors/9027"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"//dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[{"label":"Add buttons to the Quick Access toolbar","target":"#tab1"},{"label":"Add non-Ribbon commands to the Quick Access toolbar","target":"#tab2"}],"relatedArticles":{"fromBook":[{"articleId":209119,"title":"Excel 2010 For Dummies Cheat Sheet","slug":"excel-2010-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/209119"}},{"articleId":206078,"title":"How to Save an Excel 2010 Workbook as a PDF or XPS File","slug":"how-to-save-an-excel-2010-workbook-as-a-pdf-or-xps-file","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206078"}},{"articleId":206070,"title":"How to Rename an Excel 2010 Worksheet","slug":"how-to-rename-an-excel-2010-worksheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206070"}},{"articleId":206064,"title":"How to Drag and Drop Data in Excel 2010","slug":"how-to-drag-and-drop-data-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206064"}},{"articleId":206061,"title":"Automatically Fix Typos and Add Text with AutoCorrect in Excel 2010","slug":"automatically-fix-typos-and-add-text-with-autocorrect-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/206061"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"//dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281702,"slug":"excel-2010-for-dummies","isbn":"9780470489536","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"//www.amazon.com/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"//www.amazon.ca/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"//www.tkqlhce.com/click-9208661-13710633?url=//www.chapters.indigo.ca/en-ca/books/product/0470489537-item.html&cjsku=978111945484","gb":"//www.amazon.co.uk/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"//www.amazon.de/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"//www.dummies.com/wp-content/uploads/excel-2010-for-dummies-cover-9780470489536-203x255.jpg","width":203,"height":255},"title":"Excel 2010 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"9027\">Greg Harvey, PhD,</b> is president of Mind Over Media, Inc. He is the author of all editions of <i>Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies</i>, and <i>Windows For Dummies Quick Reference</i>. He's also an experienced educator. </p>","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"//dummies-api.dummies.com/v2/authors/9027"}}],"_links":{"self":"//dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489536&quot;]}]\" id=\"du-slot-6217b8ef43e8b\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489536&quot;]}]\" id=\"du-slot-6217b8ef4481b\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":192292},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2022-06-10T12:59:10+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"<!--Optimizely Script-->\r\n<script src=\"//cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"<!-- comScore Tag -->\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"\" ? \"//sb\" : \"//b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"//sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n<!-- / comScore Tag -->","enabled":true},{"pages":["all"],"location":"footer","script":"<!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"//zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>\r\n<!--END WEBSITE FEEDBACK SNIPPET-->","enabled":false},{"pages":["all"],"location":"header","script":"<!-- Hotjar Tracking Code for //www.dummies.com -->\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'//static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":"<!-- //Connect Container: dummies --> <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"<!-- Facebook Pixel Code -->\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"//www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n<!-- End Facebook Pixel Code -->","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":287569,"title":"For the Hopeless Romantic","hasSubCategories":false,"url":"/collection/for-the-hopeless-romantic-287569"},{"collectionId":287567,"title":"For the Unabashed Hippie","hasSubCategories":false,"url":"/collection/for-the-unabashed-hippie-287567"},{"collectionId":292186,"title":"Just DIY It","hasSubCategories":false,"url":"/collection/just-diy-it-292186"},{"collectionId":290164,"title":"Make a Commitment to Better Yourself","hasSubCategories":false,"url":"/collection/make-a-commitment-to-better-yourself-290164"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/excel/how-to-customize-the-excel-2010-quick-access-toolbar-192292/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"how-to-customize-the-excel-2010-quick-access-toolbar-192292"},"fullPath":"/article/technology/software/microsoft-products/excel/how-to-customize-the-excel-2010-quick-access-toolbar-192292/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"sfmcState":{"newsletterSignupStatus":"initial"}}

The Quick Access toolbar in Excel 2010 appears above the Ribbon and includes buttons for commonly used commands. By default, the Quick Access toolbar contains only the Save, Undo, and Redo commands, but you can add more.

To display the Quick Access toolbar beneath the Ribbon, click the Customize Quick Access Toolbar button (on the right end of the toolbar) and choose Show Below the Ribbon on the drop-down menu.

Add buttons to the Quick Access toolbar

You can click the Customize Quick Access Toolbar button to easily add other common Excel 2010 commands to this toolbar. The resulting drop-down menu contains more common commands. To add any of these commands to the toolbar, simply click the option on the drop-down menu. Excel adds a button for that command to the end of the Quick Access toolbar (and a check mark to its option on the drop-down menu).

Use this menu to add common commands to the Quick Access toolbar.

To add any Ribbon command to the Quick Access toolbar, right-click its command button on the Ribbon and then choose Add to Quick Access Toolbar on the shortcut menu.

Add non-Ribbon commands to the Quick Access toolbar

To add a non-Ribbon command to the Quick Access toolbar, follow these steps:

  1. Click the Customize Quick Access Toolbar button and then click the More Commands option near the bottom of the drop-down menu.

    Excel displays the Excel Options dialog box with the Quick Access Toolbar tab selected. On the right, Excel shows all the buttons currently on the Quick Access toolbar in the order they appear on the toolbar.

    Use the Excel Options dialog box to add any Excel 2010 command to the Quick Access toolbar.

  2. Select the type of command you want to add from the Choose Commands From drop-down list.

    For example, if you want to display only the commands that do not appear on the Ribbon, select Commands Not in the Ribbon.

  3. Click the command you want to add to the Quick Access toolbar in the list on the left and click the Add button.

    The command button appears at the bottom of the list on the right.

  4. Use the Move Up and Move Down buttons to reorder buttons on the Quick Access toolbar.

  5. Click OK.

    The Excel Options dialog box closes and the button appears in the Quick Access toolbar.

To quickly remove a button from the Quick Access toolbar, right-click it and then select Remove from Quick Access Toolbar on the shortcut menu. You can reset the Quick Access toolbar to its original configuration by clicking the Reset button on the Quick Access Toolbar tab of the Excel Options dialog box.

Postingan terbaru

LIHAT SEMUA