Please tell us where (and how, if necessary) we can change the default workbook.
If that is not currently accessible to users, please add it.
I have tried to create my own default workbook in the Templates and Startup folders, both with and without a file extension, but all to no avail.
Word allows us to create our own Normal.dotm in the Templates folder and that gets used for word defaults. Be nice if Excel did it in a similar way.1 vote
This page (hosted by Ron, and Excel MVP) shows how you can do this on Mac Excel.
Introduce a shortcut to make cell references absolute like F4 on PC version (F2 edit equivalent would be helpful too)1 vote
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.
Mac Excel 2016 has the ATP! Enable it under Tools > Add-ins > Analysis Toolpak
- Don't see your idea?