Session143 - How to Enable the Developer Tab in Excel for Windows
In this video I explain how to enable the Developer tab in Excel for Windows.
The Developer tab in the Excel Ribbon contains buttons for Macros & VBA. This includes buttons to open:
The Visual Basic Editor (Alt+F11)
The Macros Window (Alt+F8)
The Macro Recorder (Alt,L,R)
Macro Security
Add-ins Menus
Insert Form and ActiveX Worksheet Controls
The Developer tab is used frequently when creating & modifying VBA macros, and when adding interactive controls to the spreadsheet.
The Developer tab can be enabled in the Excel Options window. The easiest way to open Excel Options is to:
1. Right-click any ribbon tab and select "Customize the Ribbon..."
2. The Excel Options menu will open and the Customize Ribbon tab will automatically be selected in the left-side bar.
3. Click the Developer checkbox on the right listbox where all Ribbon Tabs are listed.
4. Press the OK button.
The Developer tab will be enabled and appear in the ribbon every time you open Excel. You only have to enable the Developer tab once time.
★ My Online Excel Courses ► • Playlist
⯆ DOWNLOAD the 103 Exercise workbook here: https://docs.google.com/spreadsheets/d/10f...
⯆ DOWNLOAD the 102 Exercise workbook here: https://docs.google.com/spreadsheets/d/1i3...
⯆ DOWNLOAD the 102 NorthWind Database File here: https://drive.google.com/file/d/1i5OEBaIzY...
⯆ DOWNLOAD the 102 Sales Data Text File here: https://drive.google.com/file/d/1i59jHvsKX...
⯆ DOWNLOAD the 102 Extra Practice workbook here: https://docs.google.com/spreadsheets/d/10c...
⯆ DOWNLOAD the Completed 102 Extra Practice workbook here: https://docs.google.com/spreadsheets/d/10e...
★ My Online Complete Excel Course Playlist ► • Session107 - How to Print Large Data in Ex...
#msexcel