How to use the function keys in Excel on a Mac?

I have just transferred from Microsoft to Mac.
On my MacBook Pro I cannot use the F# keys in Excel. I used to use F4 to repeat the last action and F9to recalculate.

I have found that CMD+Y does the repeat, e.g. replaces F4.

How can I replicate the F9 in Excel on a Mac?

What key combination do I need to press?

1 Answer

From this overview of 226 shortcuts for Excel 2016 on a Mac I find that to replicate F9you need to press CMD+= to calculate all open workbooks.

Alternatively if you have a keyboard with the Fn key, you can press Fn + the key that is associated with F9 (play or something).