How to Use Quick Access Toolbar + Keyboard Shortcuts in Excel (Video in Khmer)

Hello everyone! Today I show you how to use Quick Access Toolbar in Excel step by step. This is very useful for anyone who work with Excel every day and want to work faster!

You know those button at the very top left of Excel — Save, Undo, Redo? That is the Quick Access Toolbar (QAT)! And the best part — you can add any button you want there. So your most used command is always one click away. No more go through many menu to find it!

1. What is Quick Access Toolbar in Excel?

Quick Access Toolbar (QAT) is a small toolbar that sit at the top left corner of Excel, above or below the ribbon. It always visible no matter which tab you are on.

By default, QAT have only 3 button:

• 💾 Save (Ctrl + S)
• ↩️ Undo (Ctrl + Z)
• ↪️ Redo (Ctrl + Y)

But you can add any command you use often — like Print, Filter, Format Cell, Freeze Pane, Paste Special, or even your favorite formula!

Why Quick Access Toolbar is useful:

1. Save time — Your favorite command always one click away
2. Work faster — No need navigate through ribbon tab every time
3. Custom for you — Add what YOU use most, remove what you never use
4. Use keyboard shortcut — Every QAT button get a shortcut key Alt + 1, Alt + 2, Alt + 3... Very fast!

2. How to Add Command to Quick Access Toolbar

Easy way — Right click method:

1. Find the command you want to add (anywhere in the ribbon)
2. Right click on it
3. Click "Add to Quick Access Toolbar"
4. Done! It appear in your QAT right away

Full control way — Customize QAT:

1. Click the small arrow at the end of Quick Access Toolbar (dropdown arrow)
2. Click "More Commands..."
3. In the window, search for command you want on the left side
4. Click it, then click "Add >>" button
5. Click OK

Now your command is in QAT!

💡 Tip: You can also drag to reorder your QAT button. Go to "More Commands..." → use the up/down arrow on the right side to arrange button in the order you want. Put most used command at position 1, 2, 3 so you can use Alt+1, Alt+2, Alt+3 shortcut.

3. How to Use Keyboard Shortcut with Quick Access Toolbar

This is the most powerful feature! Every button in QAT have a shortcut automatically:

• Press Alt key → small number appear on each QAT button
• Then press the number to click that button

Example:

• Alt + 1 = click first button in QAT
• Alt + 2 = click second button in QAT
• Alt + 3 = click third button in QAT

So if you add Paste Special as your 4th button, you can do Alt + 4 to open Paste Special. No mouse need!

💡 Tip: Most power user arrange QAT with their top 5-9 most used command so they can use Alt + 1 through Alt + 9 for super fast access. Think about which command you click most every day and put them there!

4. Best Commands to Add to Quick Access Toolbar

Here are popular command that many Excel user add to their QAT:

💡 Tip: If you work on different computer sometimes, you can export your QAT setting and import on other computer. Go to "More Commands..." → click "Import/Export" button at bottom → "Export all customizations". Save the file and import on other computer — your QAT is same everywhere!

5. Video Tutorial in Khmer — Quick Access Toolbar + Shortcut Keys

📚 Useful Resources

• Essential Excel Keyboard Shortcuts Every User Should Know
• Top Microsoft Excel Tips and Tricks Every Spreadsheet User Should Know
• How to Turn Row to Column and Back in Excel
• TAKE vs FILTER Function in Excel Explained
• VSTACK vs HSTACK Function in Excel Explained
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)