The Dialog Box Launcher
The tiny arrow in the bottom right corner of a ribbon group. It opens the full set of options for that group.
The Hidden Full Menu
The ribbon shows the common options. The little diagonal arrow in a group corner opens the complete dialog box, where every setting for that group lives.
- Find the arrow — Bottom right of a group
- Click it — A dialog box opens
- Everything is there — Far more than the ribbon shows
How to do it
Home ▸ Font group ▸ the small arrow in the bottom right corner
Ctrl + 1 opens the Format Cells dialog directly — the most useful launcher of them all.
| Item | What it does |
|---|---|
| The arrow | Tiny diagonal in the corner |
| Which groups | Font, Alignment, Number and more |
| What opens | The complete options dialog |
| Ctrl + 1 | Shortcut to Format Cells |
Where the Launchers Are
Home ▸ Font ▸ corner arrow or Ctrl + 1
| Group | Launcher opens | Extra you get |
|---|---|---|
| Font | Format Cells — Font | Strikethrough, superscript |
| Alignment | Format Cells — Alignment | Custom text angle |
| Number | Format Cells — Number | Custom number formats |
| Clipboard | Clipboard pane | Last 24 copied items |
Result: Ctrl + 1
Ctrl + 1 is the single most useful shortcut in Excel formatting.
Do this
- Press Ctrl + 1 instead of hunting the ribbon
- Look for the corner arrow when an option is missing
- Explore each tab of the Format Cells dialog once
Avoid
- Assuming the ribbon shows every option
- Missing the arrow because it is very small
- Not knowing Ctrl + 1 exists
📌 Anything you cannot find on the ribbon is probably behind a dialog box launcher.
Practice
- Find the corner arrow on the Font group.
- Press Ctrl + 1 and look at all six tabs.
- Apply strikethrough from the dialog.
Quick quiz: You want to apply superscript to some text but cannot find it on the ribbon. Where is it?
- It does not exist in Excel
- Behind the Font group dialog launcher, or Ctrl + 1
- On the Insert tab
Show answer
Ctrl + 1 ▸ Font tab ▸ tick Superscript — Less common options live in the dialog box, not on the ribbon.
🔒 Want the full interactive course? This is a free preview. The complete 39-module Excel Master Course — with hands-on lessons, quizzes and a certificate — is available inside the app.
Learn Excel the fun way
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →