docs / articles / How to Enable Hot Keys in Excel

How to Enable Hot Keys in Excel

Sara Jul 09, 2026 2026-07-09 04:40:45

Streamlining your workflow in Excel often involves utilizing keyboard shortcuts, or hot keys, to perform tasks more efficiently. Enabling hot keys in Excel allows you to navigate, edit, and format your spreadsheets with just a few keystrokes. Here's a step-by-step guide on how to enable and use hot keys in Excel.

Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

Before we dive into the specifics, let's ensure your Excel version supports hot keys. As of now, this feature is available in Excel 2007 and later versions, including Excel for Mac and Excel Online.

Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips
Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips

Enabling Hot Keys in Excel

To enable hot keys in Excel, you'll need to ensure that the Developer tab is visible in your Ribbon. Here's how to do it:

the ultimate guide to advanced excel and keywords tips & tricks for beginners
the ultimate guide to advanced excel and keywords tips & tricks for beginners

1. Right-click on the Ribbon and select 'Customize the Ribbon'.

2. Check the box next to 'Developer'.

How to Fix Arrow Keys Scrolling in Excel
How to Fix Arrow Keys Scrolling in Excel

3. Click 'OK'.

Setting Up Hot Keys

Now that the Developer tab is visible, you can set up custom hot keys for your most frequently used commands. Here's how:

Computer tricks😉
Computer tricks😉

1. Click on the 'Developer' tab.

2. In the 'Controls' group, click on 'Macros'.

3. In the 'Macros' dialog box, click on 'Options...'.

an excel shortcut key is shown in green and white
an excel shortcut key is shown in green and white

4. In the 'Macro Options' dialog box, enter a name for your macro (e.g., 'BoldText'), and click 'OK'.

5. In the 'Macro' dialog box, enter the following code: Selection.Font.Bold = True. This will make the selected text bold.

Microsoft Excel Shortcut key
Microsoft Excel Shortcut key
Excel Shortcut Keys Cheat Sheet
Excel Shortcut Keys Cheat Sheet
a computer screen with the text advanced excel shortcut keys in green and white on it
a computer screen with the text advanced excel shortcut keys in green and white on it
Excel Home Tab Shortcuts for Beginners & Professionals
Excel Home Tab Shortcuts for Beginners & Professionals
173K views | Reel by Harkesh Kumar
173K views | Reel by Harkesh Kumar
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
the microsoft excel shortcut key tricks manual is shown in this image, with instructions to use
the microsoft excel shortcut key tricks manual is shown in this image, with instructions to use
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
⚡ Ultimate Excel Shortcut Keys Guide | Master Excel Faster 🚀
⚡ Ultimate Excel Shortcut Keys Guide | Master Excel Faster 🚀
the top 50 excel shortcut keys for each player in the game, including an additional number
the top 50 excel shortcut keys for each player in the game, including an additional number
Top 20 Advanced Excel Shortcut Keys You Should Know
Top 20 Advanced Excel Shortcut Keys You Should Know
Top 10 excel shortcut keys every fresher should know
Top 10 excel shortcut keys every fresher should know
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Best Excel tutorial on the internet
Best Excel tutorial on the internet
Excel Keyboard Shortcuts - 333 Secrets
Excel Keyboard Shortcuts - 333 Secrets
8 Advanced Microsoft Excel Shortcut Keys Every Professional Should Know | Excel Productivity Tips
8 Advanced Microsoft Excel Shortcut Keys Every Professional Should Know | Excel Productivity Tips
the excel home tab shortcut keys poster is shown in green and white, with instructions for
the excel home tab shortcut keys poster is shown in green and white, with instructions for
Everything You Can Do In Excel (with AI)
Everything You Can Do In Excel (with AI)
Excel Shortcut Keys | Easy Tricks for Beginners
Excel Shortcut Keys | Easy Tricks for Beginners
Checkboxes in Excel‼️ #excel
Checkboxes in Excel‼️ #excel

6. Click 'Assign Button'.

7. In the 'Assign Macro' dialog box, click on 'Button (Form Control)', and then click 'OK'.

8. Click on the cell where you want the button to appear, and then click 'OK'.

Using Hot Keys

Now that you've set up your hot key, you can use it to format text in Excel. Here's how:

1. Select the text you want to format.

2. Click on the button you created.

3. The selected text should now be bold.

Using Built-in Hot Keys in Excel

Excel also has a list of built-in hot keys that you can use to perform common tasks. Here are some of the most useful ones:

Navigation Hot Keys

1. Ctrl + Arrow Keys: Move the active cell in the direction of the arrow.

2. Ctrl + Home: Move to the first cell in the row.

3. Ctrl + End: Move to the last cell in the row.

Editing Hot Keys

1. Ctrl + X: Cut the selected cells.

2. Ctrl + C: Copy the selected cells.

3. Ctrl + V: Paste the copied cells.

4. Ctrl + Z: Undo the last action.

Enabling and using hot keys in Excel can significantly improve your productivity and workflow. By mastering these techniques, you'll be able to navigate, edit, and format your spreadsheets with ease. Happy Excel-ing!