How to Open Excel Options, the Visual Basic Editor, or Windows Control Panel
Question details
Find the appropriate location for Excel settings, the Visual Basic Editor, or Windows Control Panel.

- Product
- Microsoft Excel and Windows Control Panel
- Device & OS
- Windows
- Scenario
- The user wants to change Excel settings, work with Visual Basic, or access Windows system settings.
- Observed behavior
- Excel Options, the Visual Basic Editor, and Windows Control Panel are separate tools with different entry points.
Decide whether you need Excel application settings, the Visual Basic Editor, or Windows system settings. Open Excel if you need either of the first two.
Open Excel Options
Use Excel Options to change application settings.
Launch Microsoft Excel and open a workbook.
Select File, then select Options to open the Excel Options dialog.
Select a category in the Excel Options dialog, such as General or Formulas, and make the changes you need.

Open the Visual Basic Editor in Excel
Use the Visual Basic Editor when you need to view or edit VBA code.
Open Windows Control Panel
Use Control Panel for Windows settings rather than Excel application settings.
Manage spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility, making it easy to move existing spreadsheets into WPS. Excel Options, the Visual Basic Editor, and Windows Control Panel remain separate tools.

Frequently Asked Questions
Where are Excel's application settings?
Open a workbook in Excel and select File > Options. Choose a category in the dialog to find the setting you want.
How do I open the Visual Basic Editor in Excel?
With Excel open, press Alt+F11 to launch the Visual Basic Editor.
Is Windows Control Panel part of Excel?
No. Control Panel is a Windows feature. Open the Start menu, search for Control Panel, and select it from the results.
Which tool should I use to edit VBA code?
Use the Visual Basic Editor in Excel. Press Alt+F11 to open it; Excel Options and Windows Control Panel are not VBA editors.




