Recommended: Update Every Outdated Driver on Your PC in One Scan - Free →Recommended: PC Feels Slow? A Free Scan Shows What's Dragging Windows Down →
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
In Excel for Mac, press Option+F11 to open Visual Basic—the Mac equivalent of Excel for Windows’ Alt+F11. If that key combination does not work, try Fn+Option+F11 or open Visual Basic from Excel’s Developer tab.
Open Visual Basic with the Mac shortcut
Press Option+F11 in Excel for Mac. Microsoft lists this as the shortcut for opening Visual Basic. The Windows Excel shortcut for the same action is Alt+F11. This is an Excel shortcut, not a universal macOS command.
As an Amazon Associate I earn from qualifying purchases.
Microsoft’s custom-functions instructions show Fn+Alt+F11 for Mac. On an Apple keyboard, try Fn+Option+F11 if Option+F11 alone does not open the editor. Function-key behavior can depend on your Mac’s settings.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesSpecial offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
If Option+F11 does not work
- Add Fn: Press Fn along with Option+F11 so the function key is passed to Excel. Microsoft advises adding Fn when a function key does not behave as expected.
- Check function-key settings: macOS settings can change how the function keys behave. Adjusting them may affect function-key use beyond Excel.
- Consider shortcut conflicts: macOS versions or keyboard utility apps can interfere with shortcuts or function-key operations. The available guidance does not identify one cause that applies to every Mac.
- Account for keyboard layout: Microsoft’s shortcut reference is based on a US keyboard layout, so another layout may not match exactly.
Open Visual Basic from the Developer tab
- In Excel preferences, enable the Developer tab if it is not already visible.
- Select the Developer tab, then choose Visual Basic.
This menu route avoids relying on the F11 key and is a practical alternative if the shortcut is intercepted or inconvenient.
#1 Best Overall
Sale
Apple Magic Keyboard - US English , Bluetooth
- Magic Keyboard delivers a remarkably comfortable and precise typing experience.
- It’s also wireless and rechargeable, with an incredibly long-lasting internal battery that’ll power your keyboard for about a month or more between charges.
- It pairs automatically with your Mac, so you can get to work straightaway.
- It features a USB-C port and includes a woven USB-C Charge Cable that lets you pair and charge by connecting to a USB-C port on your Mac.
Which method should you use?
| Method | What to do | Best when |
|---|---|---|
| Keyboard shortcut | Press Option+F11; if needed, try Fn+Option+F11. | You want the quickest route and the function key is working as expected. |
| Developer tab | Enable the tab in Excel preferences, then choose Visual Basic. | Function-key settings or shortcut conflicts make the keyboard route unreliable. |
These instructions are specific to Excel for Mac. Microsoft notes that shortcut descriptions may differ on non-US keyboard layouts, and function-key behavior can vary with macOS settings and utility apps.
Sources: Microsoft’s Excel keyboard shortcuts, Create custom functions in Excel, Use the Developer tab in Excel for Mac, and Common Office for Mac keyboard shortcuts.
Quick Recap
Bestseller No. 4
Best Value
Sale
seenda SKM64-2 Bluetooth Keyboard and Mouse Combo for Mac, MacBook and iPad
- Wide Compatibility Tips: This Apple-focused combo supports macOS 10.12+, iPadOS 13.0+, and iOS 13.0+. It connects through 3 Bluetooth channels only, with no USB connection or USB receiver included. Note: Bluetooth 4.0 or above is required; Not fully compatible with Windows systems
- Perfect for Apple Ecosystem Users: Designed specifically for Mac users with a standard Apple layout, this Bluetooth keyboard and mouse supports BT1/BT2/BT3 channels to seamlessly switch between three devices like Mac, MacBook Pro/Air, and iPad. Ideal for multi-device professionals, students, and creatives working across Apple products
- Type-C Rechargeable for Eco-Friendly Convenience: No more battery waste! This combo features Type-C rechargeability with up to 200 hours standby. Auto-sleep and on/off switch minimize power consumption - perfect for travelers, eco-conscious users, and anyone tired of frequent battery changes
- Whisper-Quiet for Focused Environments: Enjoy a satisfying tactile click without the noise. Enhanced key stability reduces sound while keeping responsiveness high. Ideal for shared offices, libraries, study sessions, or late-night work where quiet is essential
- Slim & Stylish Metal Design for Portability: At just 0.12” (keyboard) and 0.9” (mouse), this ultra-thin combo slips easily into any bag. Made from stainless steel and premium ABS, it’s both durable and elegant—a sleek addition to any modern desk, coffee shop, or coworking space
Rank #4
Magic Keyboard with Touch ID and Numeric Keypad for Mac Models with Apple Silicon - US English - Black Keys
- Magic Keyboard is available with Touch ID, providing fast, easy and secure authentication for logins and to unlock your Mac.
- Magic Keyboard with Touch ID and Numeric Keypad delivers a remarkably comfortable and precise typing experience.
- It features an extended layout, with document navigation controls for quick scrolling and full-size arrow keys, which are great for gaming.
- The numeric keypad is also ideal for spreadsheets and finance applications.
- It’s wireless and features a rechargeable battery that will power your keyboard for about a month or more between charges.
Rank #3
Sale
Apple Magic Keyboard with Numeric Keypad - White
- WIRELESS, RECHARGEABLE CONVENIENCE — Magic Keyboard with Numeric Keypad connects wirelessly to your Mac, iPad, or iPhone via Bluetooth. And the rechargeable internal battery means no loose batteries to replace.
- WORKS WITH MAC, IPAD, OR IPHONE — It pairs quickly with your device so you can get to work right away.
- ENHANCED TYPING EXPERIENCE — Magic Keyboard delivers a remarkably comfortable and precise typing experience. Its extended layout features document navigation controls for quick scrolling and full-size arrow keys. The numeric keypad is ideal for spreadsheets and finance applications.
- GO WEEKS WITHOUT CHARGING — The incredibly long-lasting internal battery will power your keyboard for about a month or more between charges. (Battery life varies by use.) Comes with a Lightning to USB Cable that lets you pair and charge by connecting to a USB port on your Mac.
- SYSTEM REQUIREMENTS — Requires a Bluetooth-enabled Mac with macOS 10.12.4 or later, an iPad with iPadOS 13.4 or later, or an iPhone or iPod touch with iOS 10.3 or later.
Rank #2
Sale
Macally Wireless Bluetooth Keyboard for Mac - Compatible Apple Keyboard or MacBook Pro/Air, iMac - Multi-Device, Up to 3 Devices with 110 Keys, 20 Shortcuts, Numeric Keypad, and Rechargeable
- 𝗧𝗵𝗲 𝗞𝗲𝘆𝗯𝗼𝗮𝗿𝗱 𝗧𝗵𝗮𝘁 𝗖𝗮𝗻 𝗗𝗼 𝗜𝘁 𝗔𝗹𝗹: With a rechargeable battery, sophisticated design, and multi-synch tech, our bluetooth mac keyboard offers everything you need conquer your workload. Works with Mac|PC|iOS|Android.
- 𝗦𝗶𝗺𝘂𝗹𝘁𝗮𝗻𝗲𝗼𝘂𝘀𝗹𝘆 𝗣𝗮𝗶𝗿 𝗨𝗽 𝘁𝗼 𝟯 𝗗𝗲𝘃𝗶𝗰𝗲𝘀: Easily switch between your smart tv, laptop, and tablet on the fly with our wireless mac keyboards. Multisync can pair up to 3 bluetooth devices such as (Mac/PC/iOS/Android/TVs).
- 𝗦𝗼𝗽𝗵𝗶𝘀𝘁𝗶𝗰𝗮𝘁𝗲𝗱 𝗔𝗽𝗽𝗹𝗲 𝗔𝗲𝘀𝘁𝗵𝗲𝘁𝗶𝗰𝘀: Finding a mac keyboard wireless that matches can be difficult, so we designed ours to fit the look. An aluminum body with thin black keys makes it the perfect wireless keyboard for macbook pro.
- 𝗤𝘂𝗶𝗲𝘁, 𝗥𝗲𝗳𝗶𝗻𝗲𝗱, 𝗮𝗻𝗱 𝗦𝗮𝘁𝗶𝘀𝗳𝘆𝗶𝗻𝗴: The mac wireless keyboard is equipped with 110 scissor flex keys that include 20 MacOSX shortcuts and a numeric keypad. Each keystroke will be quiet and smooth.
- 𝗘𝗻𝗷𝗼𝘆 𝟯 𝗠𝗼𝗻𝘁𝗵𝘀 𝗕𝗲𝘁𝘄𝗲𝗲𝗻 𝗖𝗵𝗮𝗿𝗴𝗲𝘀: Our rechargeable bluetooth keyboard is capable of 3 months between charge time with an average use of 3 hours per day and only requires 1 hour of charge time.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Recommended Free Tools
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone. 
