With every new version, Microsoft strives to add new frustrations for even the most experienced user. Like pretending to allow you to set (and more crucially, save) your preferences for all Excel workbooks, but not actually doing it.
Call me a weirdo, but I like R1C1 reference style. It makes sense. Why the hell does most of the world seem to want to label columns with letters? (Anyway, I don't have time to rant, so moving on...)
Here's how to do it:
Hah! Foiled you again, Microsoft! I will have my preferences the way I want them! At least until I install the next latest version...
Call me a weirdo, but I like R1C1 reference style. It makes sense. Why the hell does most of the world seem to want to label columns with letters? (Anyway, I don't have time to rant, so moving on...)
Here's how to do it:
- Have a workbook open.
- Record some macro and choose to put it in your personal macros workbook.
- Choose Window ... Unhide... to see your personal workbook.
- Just to be doubly doubly sure, I then close all workbooks except the personal one.
- Edit preferences, then save the personal workbook.
Hah! Foiled you again, Microsoft! I will have my preferences the way I want them! At least until I install the next latest version...