Optimal Excel Options / Settings?
What are the optimal excel settings / options when setting up a fresh computer?
Some standard ones:
- Ensure Iterative Calculations are set to "Automatic except for data tables" & Maximum Iterations set to 100 (Should be default) [<Formulas]
- Turn off "Allow editing directly in cells" [<Advanced]
- This will allow you to edit in the formula bar for more complex / long equations
- Set default font and size to Arial 10 (Optional) [<General]
- Quick Access Toolbar
- Font Size
- Font Color
- Fill Color
- Borders
- More Borders...
- Size and Properties
Let me know of any other goods ones I'm missing.
Illo molestiae quia autem sit cumque minus. Accusamus temporibus molestiae iusto enim odit. Vel magni repudiandae magnam consequatur perferendis.
Iusto sed officia nihil quaerat exercitationem sed unde. Voluptatem explicabo accusamus quis assumenda. Rerum voluptate quia vitae est et provident. Beatae facilis quia ab inventore provident.
Sapiente excepturi cumque occaecati non autem. Ad et voluptatem cupiditate. Quisquam accusamus aliquid ducimus neque nulla.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...