Custom Excel Settings

If you’re into tweaking Excel to your liking, here’s my personal setup:

Go to File > Options (Alt > F > T) :

  • General > Font size: 9
  • Advanced > After pressing Enter, move selection: Unchecked
  • Advanced > Decimal separator: Dot
  • Advanced > Thousands separator: Space
  • Formulas > Error checking rules: All unchecked
  • Don’t forget to add the Developer tab if you want to record macros: Customize Ribbons: Check “Developer”

It’s not a must-do, but whenever I fire up Excel, I quickly set it up this way.

Feel free to play around with colors too (General > Office Theme)