Almost all of Excel's behaviour is set in File → Options (quickly: Alt, F, T). Changes take effect after OK; Cancel undoes them.
Sections of the dialog
| General | font and number of sheets for new workbooks, user name (it goes into comments and file properties), Office Theme |
| Formulas | calculation mode (automatic / manual — then recalculate with F9), iterative calculation, R1C1 reference style, Formula AutoComplete, error checking rules |
| Data | date grouping in PivotTables, automatic data conversion (leading zeros, long numbers) |
| Proofing | AutoCorrect options (if Excel "fixes" what it shouldn't), dictionaries |
| Save | default format, AutoRecover every N minutes and the AutoRecover folder |
| Language | display language and authoring languages |
| Advanced | the biggest section: direction after Enter, fill handle, decimal and thousands separators, showing the formula bar, gridlines, zeros, sheet tabs, Set precision as displayed |
| Customize Ribbon | turn on hidden tabs (Developer), create your own tab and group |
| Quick Access Toolbar | add your own commands to the title bar; same as the ▾ menu on the toolbar itself |
| Add-ins | at the bottom Manage: Excel Add-ins → Go… — turns on the Analysis ToolPak and Solver |
| Trust Center | macro settings, Protected View, trusted locations |
Common problems and where to fix them
| Formulas do not recalculate | Formulas → Workbook Calculation → Automatic |
Columns are numbered, formulas look like =RC[-2]*RC[-1] | Formulas → clear R1C1 reference style |
| Enter moves the cursor the wrong way | Advanced → After pressing Enter, move selection → Direction |
| The formula bar or gridlines are gone | Advanced → Show formula bar, Show gridlines (or the View tab) |
| No Developer tab | Customize Ribbon → Developer check box |
| No Data Analysis on the Data tab | Add-ins → Excel Add-ins → Go → Analysis ToolPak |
Excel for Mac. Options are Excel → Settings (⌘+,), a window of section icons. R1C1 is under General, calculation mode under Calculation, the direction after Return under Edit, the Developer tab under Ribbon & Toolbar, AutoRecover under Save. Add-ins are turned on in Tools → Excel Add-ins…, and on a Mac the Analysis ToolPak shows up as the Analysis Tools button on the Data tab.