Thursday, August 27, 2015

How to customize the Ribbon

You customize the Ribbon in the Customize Ribbon tab of the Excel Options dialog box (see Figure 3-1). The quickest way to display this dialog box is to right-click anywhere in the Ribbon and choose
Customize the Ribbon


Figure 3-1: The Customize Ribbon tab of the Excel Options dialog box. 

Customizing the Ribbon is very similar to customizing the Quick Access toolbar, which is described in Tip 2. The only difference is that you need to decide where to put the command within the Ribbon. Here’s the general procedure: 
1.  Right-click any part of the Ribbon, and choose Customize the Ribbon. Excel displays the 
Customize Ribbon tab of the Excel Options dialog box. 
2.  Use the drop-down list on the left (labeled Choose Command From) to display various 
groups of commands. 
3.  Locate the command you want in the list box on the left and select it. 
4.  Use the drop-down list on the right (labeled Customize the Ribbon) to choose a group of tabs. 
Main Tabs refers to the tabs that are always visible; Tool Tabs refers to the context tabs that appear when a particular object is selected. 
5.  In the list box on the right, select the tab and the group where you want to put the command. 
You must click the “plus sign” controls to expand the hierarchical lists. Remember that you cannot add commands to built-in groups, so you may need to use the New Tab or New Group buttons to add a tab or group. 
6.  Click the Add button to add the selected command from the left to the group on the right. 
When you are finished making your Ribbon changes, click OK to close the Excel Options dialog box

New tabs and groups are given generic names, so you’ll probably want to give them more meaning-
ful names. Use the Rename button to rename the selected tab or group. You can also rename built-in 
tabs and groups. 
Although you cannot remove a built-in tab, you can hide the tab by unchecking the check box next 
to its name. 
Figure 3-2 shows a part of a customized Ribbon. In this case, I added a group to the View tab. The 
new Text To Speech group has five commands. I inserted this new group between the Zoom and the Window groups. 



Customizing the Ribbon

Tip 2 describes how to customize the Quick Access toolbar by adding Ribbon commands, but some users prefer to make some changes to the Ribbon itself.
You can customize the Ribbon in these ways:
      
Add a new tab.
Add a new group to tab.
Add commands to a group.
Remove groups from a tab.
Remove commands from custom groups. Change the order of the tabs.
Change the order of the groups within a tab. Change the name of a tab.
Change the name of a group.
Reset the Ribbon to remove all customization's.
That’s a fairly comprehensive list of customization options, but you cannot do some actions:
      
You cannot remove built-in tabs — but you can hide them.
You cannot add commands to built-in groups.
You cannot remove commands from built-in groups.

You cannot change the order of commands in a built-in group. 

Note :

Unfortunately, you can’t customize the Ribbon (or Quick Access toolbar) by using VBA 
macros. However, developers can write Ribbon X code and store it in workbook files. 
When the file is open, the Ribbon is modified to display new commands. Writing 

Ribbon X is relatively complicated and is the subject of several complete books. 

Performing other Quick Access toolbar actions

Performing other Quick Access toolbar actions
Here are some other things you can do with your Quick Access toolbar:

 Rearrange the Quick Access toolbar icons. If you want to change the order of your Quick
     Access toolbar icons, you can do so on the Customization tab of the Excel Options dialog
    
box. Select the command and then use the up- and down-arrow buttons on the right to
     move the icon.
Display the Quick Access toolbar below the ribbon. To change the position of the Quick
     Access toolbar, choose the down-pointing arrow control and select Show below the Ribbon.
 Remove Quick Access toolbar icons. The easiest way to remove an icon from your Quick
     Access toolbar is to right-click the icon and choose Remove from Quick Access Toolbar. You
     can also use the Quick Access Toolbar tab of the Excel Options dialog box. Just select the
     command in the list on the right and click the Remove button.
 Share your Quick Access toolbar. Use the Import/Export button to save a file that contains
    
your Quick Access toolbar customization. You can then share this file with others.
    
Unfortunately, this file also contains any Ribbon customization's that you might have made
     (see Tip 3). In other words, you can’t share your Quick Access toolbar without also sharing
    
your Ribbon customization's.

 Reset the Quick Access toolbar. If you want to return the Quick Access toolbar to its default
     state, display the Quick Access Toolbar tab in the Excel Options dialog box and click the
    
Reset button and choose Reset Only Quick Access Toolbar. All your customization's disap-
     pear, and the Quick Access toolbar then displays its three default commands.