To make your favorite commands easily accessible, you can add your own tab to the Excel ribbon. The instructions are the same for Excel 2019, Excel 2016, Excel 2013 and Excel 2010.

Right-click on the ribbon and select Customize the Ribbon… from the context menu:Įither way, the Excel Options dialog window will open enabling you to do all the customizations described below.Go to File > Options > Customize Ribbon.So, to start customizing the ribbon, do one of the following: Most customizations to the Excel ribbon are done in the Customize the Ribbon window, which is part of Excel Options. You cannot change the color of the ribbon in Excel, but you can change the color scheme of the entire Office.However, you can hide the ribbon completely or collapse it to show only the tab names. You cannot resize the ribbon, nor can you change the size of the text or the default icons.You can neither change nor remove the built-in commands, including their names, icons and order.Though a lot of ribbon customizations are allowed in Excel, certain things cannot be changed: Export or import your personalized ribbon.Add and remove groups on existing tabs.Create a new tab with your own commands.Rearrange tabs, groups and custom commands in the order you want.To save your time and efforts when working on different tasks in Excel, you can personalize the ribbon with things like: Hide command's labels and show only iconsĮxcel ribbon: what can and cannot be customizedīefore you start doing something, it's always good to know what can and what cannot be done.Excel ribbon: what can and cannot be customized.Whatever the reason, this tutorial will teach you how to quickly customize the ribbon to your liking. Or you will want to hide tabs you use less often.

Why would you want to personalize the ribbon? Perhaps you will find it convenient to have your own tab with your favorite and most used commands at your fingertips. In Excel 2010, the ribbon became customizable. Introduced in Excel 2007, the ribbon allows you to access most of the commands and features. See how to customize Excel ribbon with your own tabs and commands, hide and show tabs, rename and rearrange groups, restore the ribbon to the default settings, back up and share your custom ribbon with other users.

Excel 2016 quick access toolbar color