Microsoft Excel Ribbon and Options (Excel 2016)

by Ali August 12, 2017 at 10:44 am

In this article, I am going to teach you all the things or tips about the Microsoft Excel ribbon. Today I will show you all the options in the ribbon of Microsoft excel 2016. As you all know that the ribbon is an important thing in every Microsoft Office programs. Also, there are several options for making our work easy. For example, we can add text box tool in the customize quick access toolbar which can be a very useful thing. Instead of going to a specific place, again and again, it will be cleverer to use customize quick access toolbar. You may add many tools in the customize quick access toolbar.

The name of Customize quick access toolbar defines its work or function also. It is customizable, we can add and delete the tools that we need or don’t need. So, later on, I will explain more about the customize quick access toolbar. It is not the customize quick access toolbar in the Microsoft Excel ribbon to talk about. There is sharing and sing in options that you may use it. Also, there are three options to view the Microsoft Excel Ribbon. So before moving to the explanation of the options, I would recommend you to read the following paragraph.

Note: The things that I am going to mention here today for Excel Ribbon will also work in Microsoft Word, Microsoft PowerPoint and MORE.

Three Views of Ribbon (Microsoft Excel)

Many time the Microsoft Excel beginner users click on the ribbon display option and change the default view of the ribbon and they will panic. They panic because they don’t know that from where I did this. There is no need to worry about just you have to learn the three option usage that is written below each option. The option is beside the Minimize button on the top right side of the window. I will show the screenshot of each in this article.

Starting from the first option it is (Auto Hide Ribbon). It will hide the ribbon and when you need it you will see a green color on the top of the window just click on that and you will see the ribbon. You may use this option whenever your screen is small and you want to select the more cells at once. As my recommendation, you have not to use this kind of ribbon view because it will waste your time especially when you need lots of commands, tool, and options to use. The Picture is at the end of the fourth paragraph.

It is time for the second view option it is (Show tab). Whenever you click on this option you will see only the tabs, not the commands. When you put the cursor on the excel book or in any cell you will not see the command, you can just see the tab. After clicking on any of tabs the commands will appear.

So moving to the last option for seeing the ribbon. It is (Show Tabs and Command). It is the default view of the ribbon. You can see the tabs and the commands at once at the same time. The majority of the people use this option but some people that have the work of adding records may use the auto hide ribbon option or the second option. If you are a student or a busy worker than I would recommend you to use the third option. For those Excel users that have a small computer screen they may zoom out the Excel spreadsheet then they may continue to their work.

The Picture of all the three options for viewing the Microsoft Excel ribbon.

Microsoft Excel ribbon
Three views of the ribbon

Customize Quick Access Toolbar and Saving

I have told you much about the customize quick access toolbar in the first and second paragraphs now I will just show you how to add tools. Whenever you want to add a tool in the customize quick access toolbar then first right click on the option. A list of option will appear then select the first option to add it to the customize quick access toolbar.

Now for deleting an option or tool from the customize quick access toolbar right click on that. Then click on the first option for removing it. That is how simple you could do this. You can add many tools to the ribbon. I have tried adding 16 tools in the customize quick access toolbar.

One last important thing that is should have to mention is that we can change the quick access toolbar position to below the ribbon. Just above the formula bar. Click on the options list of the Customize quick access toolbar and then click on the last option. the option is Show below the ribbon.

Microsoft Excel ribbon
Quick Access toolbar


The saving tool is also a part of Microsft Excel ribbon but Mostly people use ctrl+s to save the excel bool but you may also use the option in the quick access toolbar. Both are one thing click on the option to save or just press controls plus s to save.

Conclusion (Microsoft Excel ribbon)

By writing this article(Microsoft Excel ribbon) I hope that I could help you a little. I think that most of the people didn’t know about these options and tricks. So put a comment below the post and subscribe us with your email address and we will inform you. Also, mention your questions and suggestions in the comment below.  Click here if you are interested in more article about Microsoft Office programs like Excel, Access, and PowerPoint.

Don’t forget to check out our YouTube channel for video tutorials.s



  1. The care about this fundamental standard of knowledge further than the strategy that most experts provide. Your article informed me to thinking that I had previous skipped. In the event you keep this up blogging I think you may be a force in this industry.

  2. A lot of thanks for all your efforts on this web page. Kate enjoys working on investigations and it’s easy to understand why. My spouse and i hear all regarding the lively means you offer effective techniques through this web blog and as well foster participation from some others on the subject so our own girl is undoubtedly studying a lot of things. Enjoy the remaining portion of the year. You have been conducting a wonderful job.

Add Comment