Regarding software, Microsoft Excel is in a league of its own. The possibilities for manipulating a dataset are practically limitless because of Excel’s many features and tools. We 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.
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.
3 Suitable Ways to Display Excel Options Dialog Box
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
Excel’s Options pop-up window gives you quick access to various configuration options, including General, Formula, Data, and many more. 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.
- First, open the desired workbook and navigate to the File tab.
- Secondly, click on,
More → Options
- Subsequently, the Excel Options window will pop up.
- For 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.
- Presently, select a cell that contains content, in this case, C6.
- As a result, we will get the intended output like the below one.
Read More: How to Work with Dialog Box in Excel (Types and Operations)
2. Utilize Keyboard Shortcuts to Launch Excel Options Dialog Box
Keyboard Shortcuts can perform a tricky procedure to access the Options Dialog box. This article 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.
- First, open the workbook you want to use.
- Then 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.
- Then, make the Buxton Sketch font your default.
- Then, press OK.
- So, 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.
- Ultimately, 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
Microsoft developed its programming language called Visual Basic for Applications. Users must learn the VBA programming language to use features that are not available in Excel. Please use the steps below to launch the Excel Options Dialog Box using the VBA code.
- Firstly, open the desired workbook.
- Secondly, navigate to the Developer tab.
- After that, choose the Visual Basic icon.
- Later, from your Insert tab, go to,
Insert → Module
- Due to this, a Module box will appear in front of you.
- Currently, input the following formula into the box.
Sub DisplayExcelOptionsWindow() Application.CommandBars.ExecuteMso ("ApplicationOptionsDialog") End Sub
- Then, press Ctrl + S and hit the Run button.
- 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 (3 Useful Applications)
Using our discussed procedures, you can now bring up the Excel Options Dialog Box. The ExcelDemy Website likely has numerous other articles similar to this one. Keep using them, and let us know if you have other suggestions for completing the task. Use this space to ask questions, offer feedback, or make recommendations.