Forum Discussion
Excel for Mac Problems
- Apr 13, 2023
Hi there. I researched it more detailed and I have learned that the shortcuts I am trying to use with ALT key in Windows are called as "Accelerator keys" and it is not available on Mac. There is a site that allows you to use them on Mac even if it doesn't include all features in that site. https://www.acceleratorkeys.com/
However i found another way that allows Mac users to customize shortcuts as you want in the site below. I tried to use ALT+W+F+F for freeze panes to do it same like on Windows but you can only use 1 key after modifier keys. So i will assign a few shortcuts to solve the problem that slows me to use excel.https://support.microsoft.com/en-us/office/create-a-custom-keyboard-shortcut-for-office-for-mac-6bbeb90e-96d9-4e03-b199-fc026ebdc321
Here are some suggestions that might help:
- On a Mac, you can use the “Option” key instead of the “Alt” key to access some of the same shortcuts. For example, instead of using “Alt + W + F + F” to freeze panels, you can try using “Option + W + F + F”. However, not all shortcuts that work on Windows will work on a Mac.
- To change the grouping side from bottom to top in Excel for Mac, you can right-click on the ribbon and select “Customize the Ribbon”. From there, you can change the order of the groups.
- Unfortunately, it is not possible to import a customization file for the Quick Access Toolbar and ribbon settings from Windows to Mac. You will need to manually customize these settings on your Mac.
I hope these suggestions help!
*I'm not a Mac user, I've researched everything from the internet :).
Thanks for your help.
1. Control, option, command, shift i tried all combinations but on Mac it doesn't show shortcut letters on groups and it doesn't work.
2. When i right click on ribbon or quick access toolbar anywhere, it doesn't show anything. I am right clicking on ribbon doesn't work as well.
3. Probably there is not import option on mac to use it but i wanted to ask it. Even if i arrange it manually again, it still looks i cannot use them effectively because ALT key on Windows doesn't work same as on Mac.
Those restrict me to use excel effectively. I am using excel 2021 on Mac. And even when i want to use get data option, it doesn't let me take data from another excel file. What absurd things these are !