Hey there, let's walk through exactly how to set up a custom keyboard shortcut for inserting the δ (delta) symbol in Excel 2011 for Mac. Since this version of Office has a unique workflow for custom shortcuts (different from newer releases), it's no wonder you couldn't find clear docs via Google—let's fix that.

We’ll cover two reliable methods: one using Excel’s built-in tools (no macros required) and another using a simple macro for consistent, one-click insertion.

Method 1: Use Excel’s Built-in Custom Keyboard Tool (No Macros) #

This method leverages Excel’s ability to repeat your last-used symbol insertion:

• Open Excel 2011 and any worksheet (you don’t need to have a cell selected yet).
• Click the Tools menu at the top of your screen, then select Customize Keyboard... — this opens Office 2011’s dedicated shortcut editor.
• First, manually insert δ once to "prime" the system:
  1. Go to Insert > Symbol from the top menu.
  2. In the Symbol dialog, use the Subset dropdown to select Greek and Coptic.
  3. Scroll to find lowercase δ, click Insert, then close the dialog.
• Back in the Customize Keyboard dialog:
  1. In the left-hand Categories list, scroll down and select Insert.
  2. In the right-hand Commands list, find and select InsertSymbol (it’s near the bottom of the list).
  3. Click inside the Press new shortcut key field, then press your desired key combination (e.g., Option+D or Cmd+Shift+D).
  4. Check the Currently assigned to section below to make sure the shortcut isn’t already used for another command.
  5. Click Assign, then Close. Now pressing your shortcut will instantly insert δ.

Method 2: Create a Macro (More Reliable for Long-Term Use) #

If you want a shortcut that always inserts δ (regardless of your last-used symbol), a simple macro is the way to go:

• Open Excel 2011, then press Option+F11 to open the VBA Editor.
• In the left pane, right-click your workbook name and select Insert > Module.
• Paste this code into the module window (use ChrW(916) instead if you need uppercase Δ):

  Sub InsertDelta()
      ' Inserts lowercase δ at the active cell's cursor position
      ActiveCell.Value = ActiveCell.Value & ChrW(948)
  End Sub
  

• Save your workbook as a Macro-Enabled Workbook (.xlsm) to keep the macro attached.
• Assign a shortcut to the macro:
  1. Return to Excel, click Tools > Customize Keyboard....
  2. In the Categories list, select Macros.
  3. In the Commands list, select InsertDelta (the macro you just created).
  4. Enter your desired shortcut combination, check for conflicts, then click Assign and Close.

Quick Troubleshooting Tips #

• If the Customize Keyboard option is grayed out, make sure your worksheet/workbook isn’t protected.
• If your macro shortcut doesn’t work, double-check that you saved the file as .xlsm and enabled macros when opening it.
• Avoid using shortcut combinations Excel already uses (e.g., Cmd+C for copy)—the editor will flag existing assignments for you.

内容的提问来源于stack exchange，提问作者spencerchad