Forum Discussion
Excel shortcut keys "Frequency" function
Hello!
I'm currently working on an assignment for university which requires me to create a frequency-table. As it specifies the formula, I don't think that using other ways to solve it are wanted...
After entering the necessery information for data and bins I'm supposed to use the shortcut Control + shift + enter. Most of the time this deletes my entry for either data or bins or gives me the number "1" for the first marked cell and leaves the other blank, which considering my data, doesn't make any sense.
As far as google told me, the problem is that the curly brackets { and } are not created and therefore excel doesn't create the matrix.
I'm working with Excel version 16.16.27 for Mac and have talked to some of my friends who are in the same class. It seems like this is a problem that only occurs for Mac users.
A fix for it, some of my friends found, is to buy the newest Excel version where you can simply click on "complete" to finish the formula. I'm not really willing to spend money to fix such a problem...
Does anyone know a different shortcut or solution to my problem?
I'm not a native speaker and am using a non English version of excel. If anything is unclear please let me know and I will try to specify.
2 Replies
As for excel for mac, my knowledge is, to put it mildly, very limited. But send you this information, it may help you.
Or a Mac specialist will see your post again and may have a solution that can help you:).
FREQUENCY function
Note: If you have a current version of Microsoft 365, then you can simply enter the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, entering the formula in the top-left-cell of the output range, and then pressing CTRL+SHIFT+ENTER to confirm it. Excel inserts curly brackets at the beginning and end of the formula for you. For more information on array formulas, see Guidelines and examples of array formulas.
How to Use Array Formula in Excel Mac
Hope I could help you at least a little.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Hi Nikolino,
Thank you for answering!
I've already seen the page you send me and unfortunately don't have the newest Microsoft 365 version.
I've also already talked to Microsoft support, who couldn't help me as well and refered me to this forum...
Still, thanks for looking that up for me! 🙂
