With the next update to Excel for Mac (version 16.33 or higher), you will be able to assign a shortcut key and/or add the “paste formatting”, “paste formulas”, and “paste values” actions to your quick-access toolbar (QAT).

For the QAT (under Commands not in the ribbon), the commands are called:
Paste Formatting
Paste Formulas
Paste Values

Keyboard Customization (under Commands not in the ribbon), the commands are called:
Formatting
Formulas
Paste Values

For the keyboard shortcuts, you’ll need to assign a key combination that isn’t already being used to open the Paste Special dialog.

Great news. This feature is now available in Excel for Mac (O365 and Office 2019. Read more about it here -

https://techcommunity.microsoft.com/t5/Excel-Blog/Excel-for-Mac-customize-your-keyboard-shortcuts/ba-p/276459

Great news – as of Mac Excel 15.19.1 this should be fixed – the reference picker in Solver is back!

Thanks,
Dan [XL]

This is now available in the 16.24 update, which you can get if you opt into the Insiders Program, by going to Help > Check for Updates (not available if you installed from the Mac App Store). If you don’t want to opt into the Insiders program, this will be released in mid-April 2019.

The clipboard is now persistent in some cases where it would have been cleared in the past. For example, if you copy some cells, and then insert a new sheet, you can paste the copied cells. In the past, the clipboard would have been cleared when you inserted the new sheet.

This is now available in the 16.24 update, which you can get if you opt into the Insiders Program, by going to Help > Check for Updates (not available if you installed from the Mac App Store). If you don’t want to opt into the Insiders program, this will be released in mid-April 2019.

To select objects, you can click the Find & Select button on the Home tab of the ribbon, and choose the Selection Pane… or Select Objects.

The Excel team is happy to announce support for ink in Excel for Mac.

We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.

To use Find and Replace, you can press CTRL+F or CTRL+H. These shortcuts bring up the find and replace dialog.

Press CMD+F to go to the search field above the ribbon.

Good news! Flash Fill is now available in Excel for Mac if you upgrade to version 16.13 or greater. To use it, you need to click the Flash Fill button or press CTRL+E, since it won’t happen automatically as it does in Excel for Windows.

Thanks – Steve K [MS Excel]

If a function key doesn’t work as you expect it to, press the FN key in addition to the function key. If you don’t want to press the FN key each time, you can change your Apple system preferences:

Go to Apple > System Preferences > Keyboard.

On the Keyboard tab, select the check box for Use all F1, F2, etc. as standard function keys.

Cheers,
Dan [MS]