Lutfor Rahman Shimanto
You can use the Excel Options dialogue box to tailor the Excel IDE to a particular data collection. This article will examine three simple methods for creating the Excel Options Dialogue Box. Here are the three suitable ways you must follow to display the Excel Options Dialog Box.
Display Excel Options Dialog Box: 3 Suitable Ways
Let’s look into a sample dataset to see how this works in practice. The following data set contains two columns: Sales Rep and Area. The Excel Options Dialog Box will appear after employing one of these three procedures, and we’ll make some changes to the dataset as an example. To add, I’ve been using Microsoft Excel 365, the newest version, to compose this essay. You are free to go with whichever edition better suits your needs.
1. Use File Tab to Show Excel Options Dialog Box Window
This section will show the Options Dialog Box and perform operations on the dataset from the General option. If you want to finish the assignment with the help of the File tab, below are some rules to keep in mind.
STEPS:
- First, open the desired workbook and navigate to the File tab.
- Next, click on,
More → Options
- Then, the Excel Options window will pop up.
- For the demonstration, we will modify the configuration.
- To achieve this, click on the General option.
- After that, choose the Buxton Sketch as the default font.
- Later, hit OK.
- Consequently, the Microsoft Excel warning window will appear and then click the OKÂ button.
- Now, close the workbook and reopen the file.
- Select a cell that contains content, in this case, C6.
- As a result, we will get the intended output like the below one.
2. Utilize Keyboard Shortcuts to Launch Excel Options Dialog Box
Keyboard Shortcuts can perform a tricky procedure to access the Excel Options Dialog box. This method will discuss the Keyboard Shortcut to open the Excel Options window. Follow the directions below to finish the assignment with the help of the Keyboard Shortcut.
STEPS:
- First, open the workbook you want to use.
- Next, press the Alt + F + T key.
- The Excel Options window will show up after that.
- We’ll change the configuration to show how it works.
- Click on the General option to do this.
- Next, make the Buxton Sketch font your default.
- Then, press OK.
- After that, the Microsoft Excel warning window will show up.
- Click the OK button to continue.
- Close the workbook now and open the file again.
- Now, choose a cell that has something in it, like C8 in this case.
- Finally, we will get the output we want, which looks like the one below.
Read More: How to Display References Dialog Box in Excel
3. Run VBA Code to View Excel Options Dialog Box
You can use the steps below to launch the Excel Options Dialog Box using the VBA code.
STEPS:
- First, open the desired workbook.
- Next, navigate to the Developer tab.
- After that, choose the Visual Basic icon.
- Then, from your Insert tab, go to,
Insert → Module
- Due to this, a Module box will appear in front of you.
- Input the following formula into the box.
Sub DisplayExcelOptionsWindow()
Application.CommandBars.ExecuteMso ("ApplicationOptionsDialog")
End Sub- Then, press Ctrl + S and hit the Run button.
- Next, the Excel Options window will subsequently appear.
- For illustration purposes, we’ll alter the setup.
- To accomplish this, select the General option.
- Choose Buxton Sketch as the default font afterward.
- Later, press OK.
- Therefore, the Microsoft Excel caution window will display, and then select the OK button to continue.
- Close the workbook and reopen the file.
- Currently, select a cell that has data, C10, in this instance.
- As a result, the anticipated output will appear as shown below.
Read More: How to Create a Dialog Box in Excel
Download Practice Workbook
You are welcome to get a free copy of the practice workbook we referred to throughout the presentation by clicking on the link immediately below.
Conclusion
Using our discussed procedures, you can now bring up the Excel Options Dialog Box. This article described how to display the Excel Options dialog box using the File tab, keyboard shortcut and VBA code. Let us know if you have other suggestions for completing the task. Use this space to ask questions, offer feedback, or make recommendations.
