Ace My Paper - get your Excel tasks done by experts. - makes your homework shine.


Excel tutorials

The Ribbon and Toolbars in Excel 2013

When starting and opening Excel 2013 spreadsheet program, or at the very top of the window is visible ribbon that contains the toolbar on which in turn are essential elements for specific commands (text, buttons or icons) to work in Excel 2013 This Way displaying icons, buttons, text, etc. is called a Graphical User Interface (GUI). The Ribbon is a set of toolbars that you see at the top of the working window in Excel 2013 in this tutorial I will not describe all the elements of the toolbar on the Internet because you have more details about it (though this is a tutorial for absolute beginners).

Start toolbar in Excel 2013

In the picture below you see the parts I marked in frame colors.

1. At the top is the Quick Access Toolbar, which can add or remove specific icons for specific commands to work in Excel 2013 program.
2. On the ribbon in the framework of a pink color are the names of the ribbon tabs that contain groups of commands and use them according to our needs, depending on what and what actions we are working on a worksheet in Excel 2013
3. On the ribbon in the red box, there are several groups that contain commands specific to that particular group of commands and perform specific tasks.
4. At Ribbons i.e. Tab HOME shows a group of commands 'Font' that contains the commands for working and forming letters, text frames cells and the like. Also notice a group of formatting commands and work with styles
5. Part Ribbon i.e. textual command 'FILE' and its contents are described on the following link: Parts of the File menu (Backstage view)

Also note in the bottom right corner of the group commands a small arrow icon that has a button to activate a dialogue window in which we can change certain settings, as well as show some elements respective groups. Also note that the image shown below can not see properly and in full command on all Tabs. That's because I've reduced the size of the working window working space on this website. Full size image of all toolbars in Excel 2013 with all visible groups of commands is shown in sequels of this tutorial chapter by chapter.

Appearance start Toolbars and Ribbon in Excel 2013

Customizing toolbars and ribbon in Excel 2013

Toolbars that appear when you start Microsoft Excel 2013 can be further customized according to your preference. One of the ways to customize the toolbar or ribbon is right-click in any blank area shown toolbar (that you can click on the displayed button/icon). In the picture below you will see that I clicked the button below 'B' (the mouse cursor in the form of red arrows). After clicking the right mouse button appears you pop-up menu.

customize ribon and quick access toolbar excel 2013

In the picture above you see the pop-up menu the following options:

1. Add to Quick Access Toolbar (add the selected button to the toolbar for quick review)
2. Customize Quick Access Toolbar... (customizing toolbars for quick review)
3. Show Quick Access Toolbar Below the Ribbon (display the toolbar for quick access under Ribbons)
4. Customize the Ribbon... (customizing Ribbons and parts on it)
5. Collapse the Ribbon (if you click on this option then you are running the entire ribbon with field of view of working window, then this option would mean more "to hide the Ribbon in Excel 2013." If you want to display visible Ribbon then click on the icon/button right top corner 'Ribbon display options' from the dropdown menu and click on the 'Show Tabs and Commands' (see image below).

Automatically hide and display the Ribbon in Excel 2013

ribon options on work window in excel 2013


How to Unhide Ribbon in Excel 2013

So the picture above you see three options related to the display and hide ribbon

1. Auto -hide Ribbon => Clicking on this option you can set to automatically hide the Ribbon when you click on a cell in the worksheet. The ribbon in this case will see that is to be displayed. To restore the Ribbon back that is to be visible it is necessary to position the arrow of the mouse pointer to the top of the workspace window and when the title bar change color (green?) Enough to click twice quickly left mouse button on the title bar of the workbook and ribbon will again be visible, i.e. displayed on the top of the Excel window 2013th you can also click on the three dots on the front straps that will be displayed when the Ribbon is not visible. If you click again on a cell Ribbon again will not be shown i.e. visible.
2. Show Tabs => Displaying a text menu with the names of tabs the File menu. Clicking on this option again will display the names of toolbars File Menu, Home, Insert, Page Layout and other tabs
3. Show Tabs and Commands => Clicking on this option again will display all commands (text and graphics) on toolbars.

Customizing the toolbar at the Excel 2013

As I have described in the previous topic to Excel Options arrive via File Menu, which is the first in a series of tabs on the ribbon. At the backstage view window 'Excel Options' is last. Clicking on this option opens a window 'Excel Options' window, i.e. to adjust some options in Excel 2013 (see image below).

How to add or remove Commands to Ribbon Tabs in excel 2013

On the left side of the window is the main menu options, and on it you will see an option to adjust. We are currently interested in options.

1. Customize Ribbon

In the right part of the window 'Excel Options' we have a framework in which there are two columns with the orders. In the left column are all commands that Excel 2013 contains, classified by major group in the right pane are tabs or commands that are already on Ribbon (depending on which tab is shown to us)


So the drop-down menu on the left side (Choose Commands from) we have the following:

1. Popular Commands
2. Commands Not in the Ribbon
3. All Commands
4. Macros
5. File Tab
6. All Tab
7. Main Tabs
8. Tool Tabs
9. Custom Tabs and Groups

While the right side (Customize The Ribbon) we have the following:

1. All Tabs
2. Main Tabs
3. Tool Tabs

Clicking on the plus sign (+) before the name opens us to a hierarchical view of all commands by groups that are on the graphical toolbar, as shown below.

hierarchically view command excel options

In this window, we can still create your own toolbar and a group of commands and add commands to it as desired. Note the 'New Tab' button and click on it create your own tab. Also add group commands via 'New Group' button and if we want to add a command to a toolbar in a group, it is necessary to select the right column name for the Tab and the group name command and then select the left column command you want to add i.e. copied in the right column. When we selected the command to add, click on the "Add >>" button between the two columns. In the same way we remove command with '<< Remove' button. This would be enough in this part of the tutorial for a person who is a novice in working with Excel 2013

Continued tutorials, see the following link; The Ribbon and Toolbars in Excel 2013 - Part 2
Let's go to the next page of this web tutorials by click "PREV" button.