To Enable Developer tab in Excel go to File->Options->Customize Ribbon->Check the box beside the Developer tab->Click ok. Another way is by