How to Work with Dialog Box in Excel (Types and Operations)

Some groups of commands may have more commands than they are showing in the Ribbon. For example, the PAGE LAYOUT tab’s Page Setup group of commands has more commands than is shown in the ribbon. How did we understand this? As there is a small arrow located in the lower-right corner of the Page Setup group. Click on this small arrow, and the dialog box will appear on the Excel screen with more commands.

Like a dialog box for a group of commands, a command may also pop up a dialog box with more options when the command is clicked. These types of commands can’t work until you provide further information through the dialog box. For example, if you choose Review Changes Protect Workbook. Excel can’t carry out the command until you provide the password in the ‘Protect Structure and Windows dialog box.


2 Basic Types of Dialog Boxes in Excel

Excel dialog boxes are of two types. One is the typical dialog box, and the other is the modeless dialog box.

1. Typical Dialog Box

When a modal dialog box is displayed on the screen, you can’t do anything in the worksheet until you dismiss the dialog box. Clicking OK will perform your job and clicking Cancel (or press Esc) will close the dialog boxes without taking any action. Most Excel dialog boxes are of this type. You will find this Typical Dialog box when you will work with VBA Macro in Excel.

2. Mode-less Dialog Box

When a mode-less dialog box is displayed, you can continue your work in Excel, and the dialog box remains open. Changes made in a modeless dialog box take effect immediately. An example of a modeless dialog box is the Find and Replace dialog box. You can get these two controls with the following command: Home Editing Find & Select Find or Home Editing Find & Select Replace. A modeless dialog box has no OK button, it has a Close button.

  • Firstly, go to the Home tab.
  • Secondly, choose the Find & Select command.
  • Finally, click on the Find option.

  • Then, the below dialog box will appear to you.

Mode-less Dialog Box

  • Firstly, go to the Home tab.
  • Secondly, choose the Find & Select command.
  • Finally, click on the Replace option.

  • As a result, you will see the following dialog box here.

Mode-less Dialog Box

If you’ve used other programs, you’re used to dialog boxes. You can manipulate the commands of the dialog box either with your mouse or directly from your keyboard.

Read More: How to Use the keyboard to work with the ribbon


Navigating Dialog Boxes

Navigating dialog boxes is very easy — just click the commands you want to use.

Although dialog boxes were designed for mouse users, you can also use the keyboard. Every dialog box button has also a text name on the button. For example, if you click the dialog box launcher of the Font group of commands of the Home tab, the Format Cells dialog box will be displayed. Format Cells dialog box has Number, Alignment, Font, Border, Fill, Protection-these six tabs. If you press ‘P’ then the Protection tab will be activated. If you press ‘F’, the first text starting with ‘F’ will be selected (here the first one is ‘Font’). These letters (N, A, F, B, F, P) are called hotkeys or accelerator keys.

You can also press ‘Tab’ from your keyboard to cycle through all the buttons on a dialog box. Pressing Shift + Tab cycles through the buttons in reverse order.

  • Firstly, select the Home tab.
  • And, choose the Format command.
  • Similarly, click on the Format Cells option.

  • Consequently, you will see the Format Cells dialog box in the below image.

Navigating Dialog Boxes in Excel

 💡 Tips: When a button in a dialog box is selected, the button appears with a dotted outline. You can use the space bar from your keyboard to activate a selected button.

Using Tabbed Dialog Boxes

Several Excel dialog boxes are tabbed dialog boxes. In our previous example Format Cells is also a tabbed dialog box. Format Cells dialog box has six tabs: Number, Alignment, Font, Border, Fill, Protection. When you select a tab, a panel with relevant commands becomes visible. In this way, this Format Cells dialog box is basically a packet of six dialog boxes.

Tabbed dialog boxes are highly convenient because you can make several changes in a single dialog box. After you have made all your settings changes, click OK or press Enter to quit the dialog box.

Using Tabbed Dialog Boxes in Excel

 💡 Tips: If you want to select a tab of a displayed dialog box by using the keyboard, press Ctrl + PgUp or Ctrl + PgDn, or simply press the first letter of the tab that you want to activate.

Conclusion

In this article, we’ve discussed some types of dialog boxes and how to navigate dialog boxes and use tabbed dialog boxes in Excel. We sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.

Happy Excelling ☕

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo