Option and customizeIntroduction
Open the File menu and select Options from the left navigation pane to open the Excel Options dialog. The dialog has categories for General, Formulas, Proofing, Save, Language, Advanced, Customize Ribbon, Quick Access Toolbar, Add-Ins, and Trust Center. The Trust Center leads to another 12 categories.
The most commonly used settings, such as user interface settings, default font for new workbooks, number of sheets in a new workbook, customer name, and Start screen.
All options for controlling calculation, error-checking rules, and formula settings. Note that options for multi threaded calculations are currently considered obscure enough to be on the Advanced tab rather than on the Formulas tab.
Spell-check options and a link to the Auto Correct dialog.
The default method for saving, Auto Recovery settings, legacy colors, and web server options.
All options that Microsoft considers arcane, spread among 13 headings.
Quick access tool bar
Icons to customize the Quick Access Toolbar (QAT).
You can personalize your ribbon to arrange tabs and commands in the order you want them, hide or un hide your ribbon, and hide those commands you use less often. Also, you can export or import a customized ribbon.You can re arrange ribbon menus
Choose the editing language, Tool Tip language, and Help language.