They will need to enable the tab on their system as well. Also, if you enable the tab and work on a macro or something the tab will not automatically appear when you share the file with another person. These settings will remain after you exit Excel so you don’t need to repeat. The above will enable the developer tab in Excel 2010. In the rightmost panel, find and click the checkbox next to Developer. Click Customize Ribbon in the left navigation. Press the 'Design Mode' button next to the 'Insert button' to turn of Design Mode. Select the control in the list and press OK. On the Developer tab use Insert > ActiveX Controls.More controls. These settings will remain after you exit Excel so you don’t need to repeat this process every time you start Excel. Steps to turn on the developer tab in Excel 2010. Select the control in the list and press OK. Steps to turn on the developer tab in Excel 2010Ĭlick Customize Ribbon in the left navigation. The above will show the developer tab in Excel 2007 for you. Steps to turn on the developer tab in Excel 2007Ĭlick the Office Start button, then click Excel Options.Ĭlick on the Popular section in the left navigation, and then click the checkbox for Show Developer tab in the Ribbon. Microsoft moved the option around a bit between versions. Here are the few simple steps to enable the tab. But, you don’t see it right? You need to turn on the Developer tab in Excel. Facebook 0 Tweet 0 Pin 0 LinkedIn 0 Print 0īy now I’m guessing you’ve read some instructions that have asked you to click the Developer tab in Excel.
0 Comments
Leave a Reply. |