Introduction of Microsoft Excel Ribbon

What is MS-Excel ribbon and its uses?

We no longer need to find on which pull-down menu or toolbar the command resides.  The ribbon shows us the most commonly used commands and options to perform a particular task, which is very user-friendly.

 The ribbon consists of the tabs at the top, and the tab is split into groups which categorize related command buttons into sub tasks. Each group has its respective command buttons, the dialog box launchers, which are present in the lower right corner in some of the groups. This opens a dialog box containing a bunch of additional options we can choose from.

 

image 1.1

 

The ribbon is at the top of the Excel window.  As per Excel’s default settings, we have 8 tabs:-

image 1

 

Why and how to add developer tab in Excel?

In Microsoft Excel, we can customize the ribbon and can add Developer tab. This tab we use to write the macro coding on VBE page.

To add the developer tab, Follow the steps below:-

  • Click on File > Options > Customize ribbon > Main tabs (Check to Developer tab) > Click OK.

image 2

 

  • Now Developer tab will appear in the ribbon

image 3
next

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube