How to Display Excel Options Dialog Box (3 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

excel options dialog box


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.

Use File Tab to Show Excel Options Dialog Box Window

  • Next, click on,

More → Options

Use File Tab to Show Excel Options Dialog Box Window

  • Then, the Excel Options window will pop up.

Use File Tab to Show Excel Options Dialog Box Window

  • 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.

Use File Tab to Show Excel Options Dialog Box Window

  • 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.

Utilize Keyboard Shortcuts to Display Excel Options Dialog Box

  • 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.

Utilize Keyboard Shortcuts to Display Excel Options Dialog Box

  • 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.

Run VBA Code to View Excel Options Dialog Box

  • 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.

Run VBA Code to View Excel Options Dialog Box

  • Next, the Excel Options window will subsequently appear.

Run VBA Code to View Excel Options Dialog Box

  • 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.


Related Articles

Lutfor Rahman Shimanto
Lutfor Rahman Shimanto

Hi there! I am Lutfor Rahman Shimanto. I have completed my graduation in Information Technology from Jahangirnagar University. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of work, I enjoy Chess a lot. I am a founding member of the Jahangirnagar University Chess Club and an internationally rated chess player.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo