Use Dialog Launchers For More Choices

July 22, 2021 - by Bill Jelen

Use Dialog Launchers For More Choices

Problem: It seems like there should be more choices than what is showing on the ribbon. Where is Center Horizontally in the ribbon?

Strategy: Many groups in the ribbon contain a tiny icons called dialog launchers. You can click an icon to open a dialog with more choices. This figure shows an example of a dialog launcher.

Detail of the Page Setup group from the Page Layout tab in the Ribbon is shown. At the bottom right of the group is a diagonal arrow icon called the Dialog Launcher.
Figure 23. Take me back to the old dialog.

Additional Details: It is difficult to describe the dialog launcher icon. If you enlarge the icon, you can see that it looks like the top-left corner of a square with an arrow pointing down and to the right. I am sure there is some artistic rationale why these pixels mean “launch the full dialog ,” but I can’t figure it out.

Bill Jelen is the author / co-author of:
MrExcel 2021 – Unmasking Excel

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.