Forum Discussion
I am about to be mad about Excel 2021 on Mac
Hi guys. If you use excel as almost an expert. I think there are many jokes you will meet when you start to use Excel on Mac after you used it on Windows. In last days i've tried to import qu...
Sekoleyte I have been publishing a series of articles covering the differences between Excel for Mac and Excel for Windows.
List of articles about "Excel for Mac" at SumProduct.com
The following articles may be of specific interest:
Excel for Mac: Value Preview (sumproduct.com)
Excel for Mac: Power Query features and limitations (sumproduct.com)
Excel for Mac: Power Query – From Table/Range (sumproduct.com)
With regard to pressing F2 to switch between point and edit mode in Conditional Formatting and Data Validation rules, this should work okay. See the animation below that shows "Edit" and "Point" swap on the status bar when I press F2.