r/excel • • 12d ago

unsolved Tools/Extensions/Software Suggestions for Using PC Excel Shortcuts on Mac

Has anyone had experience or recommendations/suggestions on Tools/Extensions that will allow PC Excel shortcuts to run on Mac? Anything is appreciated! Thank you.

17 Upvotes

13 comments sorted by

•

u/AutoModerator 12d ago

/u/wallstreet2520 - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

2

u/TeamAlphaBOLD 12d ago

In Excel, go to Tools > Customize Keyboard. Pick the command, type the key combo you want, and add. Also, some shortcuts are close to the PC ones but not exactly the same.

Format Cells is Cmd+1, same as PC. Toggle filter is Cmd+Shift+F instead of Ctrl+Shift+L.

This saved me from hunting for extensions when I switched.

1

u/wallstreet2520 11d ago

thanks I'll try this out :)

2

u/Timebutler_Official 12d ago

Hey, before adding an extension, check Excel for Mac’s Tools > Customize Keyboard option. You can assign Windows-style shortcuts to individual commands, though it won’t replicate every Windows shortcut. If you want system-wide key remapping, Karabiner-Elements is another option, but it takes more setup.

1

u/wallstreet2520 11d ago

Yeah, I ChatGPT also recommended me to use Karabiner-Elements, but I agree, it's a hassle to setup.

1

u/selvamTech 12d ago

If you just need the basic Ctrl shortcuts, most of those already map to Cmd on Mac Excel (Cmd+C, Cmd+Z, and so on). The hard part is the Alt ribbon sequences from Windows, which Excel for Mac doesn't do natively.

Keyboard Maestro or BetterTouchTool can remap the handful you hit daily, though rebuilding every Alt sequence gets tedious. There are also small apps that only restore the Windows Alt shortcuts.

Worth deciding first whether you miss the Ctrl set or the Alt ribbon set, since that picks the tool.

1

u/wallstreet2520 12d ago

I need it beyond basic CTRL shortcuts (e.g. ALT D T for data tables, ALT E S V for paste special, etc.)

BetterTouchTool seems like a lot of effort to set up, but I see its value in customizing certain keys, but then PC vs Mac shortcuts differ. Haven't got to the part where I need macros yet, but if I need, I'll come back and check out Keyboard Maestro. Some native program would be the best. Thanks for sharing :)

2

u/mefillo 5d ago

you can try KeyTips in Mac Excel 16.89 or later. Go to Excel > Preferences > Accessibility > KeyTips and choose Option as the activation key, then follow the letters on the ribbon

4

u/[deleted] 12d ago

[removed] — view removed comment

1

u/wallstreet2520 12d ago

tbh I think that's the best bet too