When it appeared in Office 2007, the Ribbon Bar caused divided opinions among users. Many felt that the old menu system was much more practical because it has been in use for a long time, so it was not difficult to find the appropriate function. Regardless of these remarks, the authors of Office continued to develop the new system, so it is now possible to change the content of individual sections. In this lesson I will show you how to do it.

To begin with, you need to select the File option to open the so-called Backstage View and click on Options. Now from the menu on the left you can choose the option Customize Ribbon and display the corresponding content. But this is not the only way you can get these parameters. That’s why by selecting the Cancel button I will close this frame and place the cursor on any segment of the tape. If I press the right mouse button after that, an auxiliary menu will appear on the screen from which I can easily start the function for customizing the toolbar (Customize the Ribbon). Of course, the exact same frame will appear on the screen, but I got to it in an easier way.

To begin with, I will show you how you can change the position of existing sections. Assuming that you often use the document preview functions, it would not be a bad idea to place the View section at the very beginning of the ribbon. For this, it is enough to click on the appropriate item and use the arrow on the right. If I click on it several times, the selected content will be placed at the top of the list. In order for this change to be visible on the screen, I just need to click the OK button to close this frame. If you prefer to use the mouse for such changes, simply grab the appropriate item and drag it to a new location. As you can see, the result is exactly the same, but you have avoided several clicks and saved a few seconds.

If you come to the conclusion that you no longer need one of these sections, simply click on the square to its left. Although this will not remove it from the list, it will no longer appear on the toolbar. This means that if you change your mind, you can easily reactivate it.

In the continuation of the lesson, I will show you how you can change the content of one of the existing sections. To that end, I will click on the Home item and display the functions that are there. Now I can go to the left side of the frame and select the Tool Tabs option from this list. As you can see, this list contains many different functions, so it won’t be difficult for me to move some of them to the Home section. Since both locations are now available to me, I can click the Add button and complete the operation. In the same way, I can add another function, so I will use this opportunity to place a few more new contents in the Home section. Unfortunately, items within some of these groups cannot be changed. This is confirmed by the gray color in which they are displayed, and this is currently the only limitation in the new Office. Having made all the desired changes in this way, I will close this frame by selecting the OK button and check what I have achieved. As you can see, the Home bar segment is now richer with several new sections. If you are not satisfied with their position, apply the following procedure. To begin, launch the Customize the Ribbon function and display the corresponding parameters in the following frame. Now you can use the mouse and simply drag the selected item to a new location. The same result can be achieved by using this arrow, but for larger movement it is necessary to click several times. In any case, as soon as you close this frame by clicking the OK button, all traffic will be immediately visible on the screen.

In the second part of the lesson, I will show you how you can create a completely new section. To do this, you need to open this frame and look for a button called New Tab. As soon as you click on it, a new item will appear on the right, which in fact represents a new segment of the bar. To change the name, you can click on the Rename button and immediately enter the appropriate content. In order to enter one of the available functions into it, I will select the Tool Tabs item from this list and immediately look for the drawing commands. Since they are in the Drawing Tools section, it won’t be difficult for me to select one of them and click the Add button. In this way, the selected content will be transferred to a new section. You can apply the same procedure for individual functions. I will use this opportunity to place the Height and Width functions in a new group. Since this segment doesn’t have a proper name either, I’ll click on the Rename button and type Dimensions instead of New Group. In order to make the best use of the section I just created, I will insert a few more functions into it and then finally close this frame. Since it was second in the list, the entire content will appear on the left side of the bar. Although I have already shown you how it can be changed, I will repeat this process. To begin with, you need to select the Customize the Ribbon function from the auxiliary menu and then drag this item to a new location with the mouse.

Finally, I want to show you how you can change the name of one of the existing sections. For that, you need to select it and then click on the Rename button. After that, you will be able to enter a name that suits you better. You can use the Remove button to delete redundant content. I will take this opportunity to remove the Languages and Ink items.

Since I have largely changed the appearance of the entire toolbar in this way, it would not be bad to transfer these changes to another computer. To this end, the Export function can be used, so I will click on this arrow and select the option Export all customizations from the menu. In the frame that follows, enter the name of the new file and click on the OK button. Assuming that I have now switched to another computer, I can search for the appropriate data by selecting the Import customization file option and transfer all changes. I will close this frame by selecting the Cancel button because this data is already on my computer.

Surely, after all this, you are wondering if it is possible to cancel these changes in one move and put everything back in its place. Of course, the authors of the new Excel took care of such situations as well. All you have to do is click on the Reset button and select the Reset all customizations option. After that, you need to confirm this operation by selecting the Yes button and finally close this frame. At that moment, all the changes you made will be canceled, which means that the toolbar will return to its original appearance.