Select a Category

How to Enable Developer Tab in Excel 2010?

Description

Excel comes with Visual Basic for Application (VBA) development environment. VBA is very handy to create custom code for Excel. However, standard 2010 Excel installation hides the development tab the ribbon as shown below.

Excel without Developer Tab in Ribbon

Excel without Developer Tab in Ribbon

Steps to show Development Tab in Ribbon

  1.  Go to File -> Option -> Customize Ribbon and click on it.
  2. Check “Developer” box

    Enable Excel Developer Tab in Ribbon

    Enable Excel Developer Tab in Ribbon

  3. Now, you can access Visual Basic editor with easy.

    Excel Developer Tab in Ribbon

    Excel Developer Tab in Ribbon

 

Comments are closed.