When I press CSE on my laptop excel, the brackets appear but I do not get any results.

Instead, it just shows the whole formula in the cell with the brackets.

The file is not in shared mode and I have the macro function turned on.

Im trying to count the number of times a certain word appears in a string text in A:A I know the formula works because it works on my desktop just fine but I cant seem to get it to work on my laptop.

Is there a setting to enabledisable functions, formulas other than the macro option.

I have spent 4 days outside of home, to use just windows PC where it is easy as a pie - F2, CTRL SHIFT ENTER.

After a bit of digging, it looks like the key combination for entering the array formula has changed from RETURN to CTRL SHIFT RETURN.

Switched to Excel 2016 quite some time ago and today I needed to do some array formulas.

Not that it really matters, but still, since the solution was published on Youtube in 2013.

The reason why, for me anyway, nothing worked, is in the Mac OS, the control key by default, for me anyway, is set to manage Mission control, which, at least for me, disabled the control button in Excel.

In order to enable the key to actually control functions in Excel, you need to go to System preferences Mission Control, and disable shortcuts for Mission control.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged excel macos array-formulas excel-2011 or ask your own question.

Enter Array Excel For Mac