Excel Quick Access Toolbar: Customize the QAT for Speed

Buried at the top of your Excel window is the most underused productivity feature in the entire application: a tiny, fully customizable strip that most people never touch. the excel quick access toolbar (QAT). It’s a tiny strip of icons — Save, Undo, Redo by default — that most people never touch. That’s a shame, because once you customize quick access toolbar excel layouts with your own most-used commands, two things happen: your favorite actions become one click away no matter which ribbon tab is active, and every pinned command gets an automatic Alt+number keyboard shortcut. For analysts in the US, UK, India, Canada, and Australia who repeat the same dozen actions all day, a tuned QAT is the closest thing to a personal command center Excel offers.

This excel qat tutorial covers everything: where the toolbar lives, why it beats hunting through the ribbon, the 30-second way to add any command, the 15 commands actually worth pinning, the Alt+number excel toolbar shortcuts that turn it into a keyboard launcher, placement and multi-device sync, and the mistakes that turn a speed tool into clutter. Ten minutes of setup, permanent payoff — let’s build yours.

What the Quick Access Toolbar is and where it lives

The Quick Access Toolbar is a customizable strip of command icons that stays visible regardless of which ribbon tab you’re on. By default it lives in the title bar at the very top-left of the Excel window — a small row holding Save, Undo, and Redo. It’s deliberately minimal out of the box, because Microsoft expects you to decide what belongs there.

You can also move it below the ribbon (click the dropdown arrow at the toolbar’s end → “Show Below the Ribbon”). Below-ribbon placement gives it the full window width, so you can fit far more icons before they collapse into an overflow chevron. Power users almost always move it below the ribbon for this reason — the title-bar slot is cramped, especially on smaller laptop screens.

One more thing to know: the QAT is per-application, not per-workbook. Your Excel QAT is the same across every workbook you open — which is exactly right, because it’s a launcher for your habits, not a property of any single file. (If you need per-workbook customization, that’s what the ribbon’s custom tabs are for.)

Why the QAT beats the ribbon for daily work

The ribbon is a great discovery tool and a mediocre speed tool. Finding “Remove Duplicates” means remembering it’s on the Data tab, in the Data Tools group — then aiming and clicking. If you use it daily, that hunt is pure waste. The QAT fixes it three ways:

1. One click, always visible. Pinned commands sit in the same place no matter which tab is active. Muscle memory forms fast because the target never moves.

2. Automatic keyboard shortcuts. Every QAT icon gets an Alt+number shortcut (more below). Excel offers no other way to assign hotkeys to arbitrary commands — this alone justifies the toolbar.

3. Commands the ribbon hides. Excel has hundreds of commands that aren’t on any ribbon tab by default — the full command list in the customization dialog includes gems like “Camera”, “Speak Cells”, and precise freeze/split variants. The QAT is how you surface them.

Think of it this way: the ribbon is the department store; the QAT is your desk drawer. You don’t keep your stapler in the store — you keep it where your hand expects it. Pair this with the keyboard shortcuts in our productivity guide and your hands will rarely leave home row. The combination is multiplicative: shortcuts for what you can memorize, QAT buttons for everything else, and the Alt+number bridge connecting the two into a single keyboard-driven workflow.

How to customize Quick Access Toolbar in Excel: the basics

There are two ways to add commands. The fast way handles 90% of cases; the full dialog handles the rest.

Method 1 — right-click (10 seconds): find the command on the ribbon, right-click it, and choose “Add to Quick Access Toolbar”. Done. The icon appears immediately. This works for nearly every ribbon button, including dropdown galleries.

Method 2 — the customization dialog (for everything else): go to File → Options → Quick Access Toolbar. The left list shows available commands — change the “Choose commands from” dropdown to “All Commands” to see everything Excel offers (hundreds of entries, alphabetically sorted). Select a command, click Add, and use the up/down arrows on the right to order your icons. Click OK.

To remove an icon, right-click it on the toolbar and choose “Remove from Quick Access Toolbar” — or delete it in the dialog. To reorder, use the dialog’s arrow buttons; order matters because it determines the Alt+number assignments (more on that next).

Excel QAT tutorial: adding any command in 30 seconds

Let’s walk a complete example — pinning Freeze Panes, a command people hunt for constantly:

1. Go to the View tab on the ribbon.
2. Find Freeze Panes in the Window group.
3. Right-click it and choose “Add to Quick Access Toolbar”.
4. The icon appears on your QAT immediately — click it anytime to freeze panes without visiting the View tab.

Now the advanced version — adding a command that isn’t on the ribbon at all, like Paste as Values (a distinct command from the Paste dropdown):

1. Go to File → Options → Quick Access Toolbar.
2. Set “Choose commands from” to “All Commands”.
3. Scroll to “Paste Values”, select it, click Add.
4. Use the arrows to position it early in the list (early = lower Alt+number = faster).
5. Click OK. You now have one-click (or Alt+number) paste-as-values — the single most-used command among data cleaners.

The same dialog lets you add macros: choose “Macros” in the dropdown, add your macro, and it gets a QAT button (you can even assign it a custom icon). A personal macro for “clean and format this CSV import” on Alt+3 is a legitimate superpower — and if your imports start as CSV, run them through the free CSV to Excel converter first so the macro always sees a clean table.

The 15 commands worth pinning (and why)

Don’t pin randomly — pin for your actual workflow. That said, these fifteen are the most universally valuable, grouped by job:

Data cleaning (the big wins): Paste Values — strips formulas when pasting; Text to Columns — splits combined data without formulas; Remove Duplicates — one-click dedupe; Sort A to Z / Z to A — faster than the Sort dialog for simple cases.

Structure: Freeze Panes — lock headers; Filter — toggle AutoFilter; Insert Table — Ctrl+T as a button for mouse days; Group/Ungroup — collapse detail rows in reports.

Formatting: Format Painter — double-click the QAT icon to lock it on, then paint formats across many ranges; Borders dropdown — the full border gallery in one click; Increase/Decrease Decimal — tidy numbers fast.

File & view: Save As (distinct from Save) — because versioning matters; New Window + Arrange All — compare two sheets side by side; Camera tool (from All Commands) — snapshots a range as a live-linked picture for dashboards.

Start with five, not fifteen. Pin the five you use most this week; add more only when you catch yourself hunting. A 30-icon QAT is just a second ribbon — the point is curation, not collection.

Excel toolbar shortcuts: Alt+number magic

Here’s the feature that elevates the QAT from “convenient” to “essential”: press Alt and Excel shows number badges over each QAT icon — Alt+1 fires the first icon, Alt+2 the second, up to Alt+9, then Alt+09, Alt+08 for positions 10+. These are true single-chord shortcuts for any command, including ones with no built-in hotkey.

This means QAT order is strategic: put your most-used commands in positions 1–5 so their shortcuts are Alt+1 through Alt+5 — fast, memorable, and reachable without looking. Reorder in File → Options → Quick Access Toolbar with the arrow buttons. A typical power-user setup: Alt+1 = Paste Values, Alt+2 = Filter, Alt+3 = Freeze Panes, Alt+4 = Text to Columns, Alt+5 = personal macro.

Two caveats. First, Alt+number assignments shift if you add or remove icons before them — so finalize your order before you memorize. Second, on some international keyboard layouts Alt+number combinations can conflict with typing special characters; if Alt+3 types a character instead of firing your macro, that’s the layout, not Excel — the QAT dropdown still works with the mouse.

QAT placement, import/export, and multi-device sync

Placement: below the ribbon wins for most people — more icons visible, larger click targets, and it doesn’t crowd the title bar. The one argument for above-the-ribbon is vertical space on short laptop screens. Try below for a week; most people never go back.

Backup and transfer: your QAT layout lives in Excel’s settings, and it can vanish after an Office repair or profile rebuild. Protect yourself: File → Options → Quick Access Toolbar → Import/Export → Export all customizations, and save the resulting .exportedUI file somewhere safe (OneDrive, ideally). On a new machine: same dialog → Import. Thirty seconds, and your entire setup is restored. Do this today — future-you, mid-laptop-migration, will be grateful.

Sync: Microsoft 365’s roaming settings sync some Office customizations when you sign in, but QAT behavior across devices has been inconsistent over the years — treat the .exportedUI file as the source of truth, not the cloud sync. For teams, a shared .exportedUI with the team’s standard QAT is a genuinely nice onboarding touch: new analysts get the team’s curated toolbar on day one. Our Excel templates guide covers the same “standardize the setup” philosophy for workbooks themselves.

QAT for teams: standardizing the toolbar

Everything so far has been personal — but the QAT gets even more interesting at team scale. When everyone on a team uses the same curated toolbar, three good things happen: new hires inherit the team’s hard-won workflow knowledge on day one, screen-sharing and pair work stop involving “wait, where is that button on your machine,” and team-wide process changes (a new validation step, a new export routine) can be distributed as a single .exportedUI file instead of a training session.

Building a team QAT starts with a workshop, not a mandate. Gather your five heaviest Excel users for thirty minutes and ask each to list their ten most-used commands. The overlap — usually Paste Values, Filter, Text to Columns, Freeze Panes, Remove Duplicates, and a couple of team-specific items — becomes the core. Add your team’s custom macros (the month-end formatter, the report exporter) in the next slots. Keep the total under twelve icons: a team toolbar nobody can memorize is a team toolbar nobody uses.

Distribution is straightforward: export the agreed layout as TeamQAT.exportedUI, store it in the shared templates library next to your standardized workbook templates, and document the two-minute import process in onboarding materials. Version it like any shared asset — TeamQAT_v2.exportedUI — and announce changes in the team channel with a one-line changelog (“v2: added Camera tool at position 8, moved Sort to position 5”).

A few team-specific cautions. First, respect individual overrides: the team QAT is a starting point, not a straitjacket — let people add personal icons after the standard set. Second, watch for macro references: if the team QAT includes macro buttons, everyone needs the macro workbook available (a shared Personal Macro Workbook or an add-in), or the buttons will error on machines missing the code. Third, revisit quarterly: workflows evolve, and a toolbar that still reflects last year’s process becomes a museum exhibit. The same “standardize the setup” philosophy applies to workbook structure — consistent tools plus consistent files is how teams get fast together rather than just individually.

QAT mistakes that slow you down

Pinning everything. A 25-icon QAT is a second ribbon you have to scan. Cap yourself at 10–12 icons; if you need more, you’re pinning rarely-used commands that belong in the dialog, not the toolbar.

Ignoring the order. Random order wastes the Alt+number system. Spend two minutes arranging icons by frequency — most-used leftmost — and the keyboard shortcuts become intuitive.

Duplicating built-in shortcuts. Don’t pin “Copy” (Ctrl+C exists) or “Bold” (Ctrl+B exists). The QAT’s unique value is commands without good shortcuts — Paste Values, Text to Columns, Camera. Every slot spent on Ctrl+C is a slot stolen from something irreplaceable. Before pinning anything, check our keyboard shortcuts guide: if a command already has a comfortable hotkey, it doesn’t need toolbar real estate.

Never pruning. Workflows change; the QAT should too. Once a quarter, remove anything you haven’t clicked in a month. A lean toolbar stays fast; a fossilized one becomes wallpaper.

Forgetting it exists on a new machine. The number of people who meticulously customize Excel on their desktop and then suffer with defaults on their laptop is staggering. Export the .exportedUI file, keep it in OneDrive, import it everywhere.

Pinning commands that fight your QAT order. Remember that Alt+number shortcuts follow position, not the command — if you insert a new icon at position 2, everything after it shifts and your muscle memory breaks. When adding to an established QAT, append new icons at the end (highest numbers) until you’re ready to deliberately re-order and re-learn. Treat the first five positions as sacred: they should change rarely, because Alt+1 through Alt+5 are the shortcuts your fingers know best.

Ten minutes of QAT setup, compounded across every Excel session for years, is one of the highest-ROI customizations in office software — right up there with the spreadsheet best practices that keep your workbooks themselves fast and clean.