MS-Excel / Getting Started

Excel Options Guide

This table shows every Excel feature that you can change in the Excel Options dialog. The table shows the feature, the category where it can be modified, the section within the category, and the text of the option.

FeatureCategorySectionText
Mini ToolbarPopularTop OptionsShow Mini Toolbar on selection
Live PreviewPopularTop OptionsEnable Live Preview
MacrosPopularTop OptionsShow Developer Tab in the Ribbon
SkinPopularTop OptionsColor Scheme
ScreentipsPopularTop OptionsScreentip Style
Custom ListsPopularTop OptionsCreate Lists For Use In Sorts And Fill Seqences
FontPopularNew WorkbooksUse This Font
Font SizePopularNew WorkbooksFont Size
ViewPopularNew WorkbooksDefault View For New Sheets
WorksheetsPopularNew WorkbooksInclude This Many Sheets
NamePopularPersonalizeUser Name
LanguagesPopularPersonalizeChoose The Languages You Want To Use With Office
CalculationFormulasCalculation OptionsWorkbook Calculation Automatic
CalculationFormulasCalculation OptionsWorkbook Calculation Automatic Except For Data Tables
CalculationFormulasCalculation OptionsCalculate Workbook Manual
Calculation SavingFormulasCalculation OptionsRecalculate Workbook Before
Circular Reference FormulasFormulasCalculation OptionsEnable Iterative Calculation
Circular Reference FormulasFormulasCalculation OptionsMaximum Iterations
Circular Reference FormulasFormulasCalculation OptionsMaximum Change
R1C1 StyleFormulasWorking With FormulasR1C1 Reference Style
AutoCompleteFormulasWorking With FormulasFormula AutoComplete
Formula StyleFormulasWorking With FormulasUse Table Names In Formulas
GetPivotDataFormulasWorking With FormulasUse GetPivotData Functions For PivotTable References
Error CheckingFormulasError CheckingEnable Background Error Checking
Error IndicatorsFormulasError CheckingIndicate Errors Using This Color
Errors IgnoredFormulasError CheckingReset Ignored Errors
Errors in FormulasFormulasError Checking RulesError Checking Rules-Cells Containing Formulas That Result In An Error
Formulas inconsistent in tableFormulasError Checking RulesError Checking Rules-Inconsistent Calculated Column Formulas In Tables
Dates as TextFormulasError Checking RulesError Checking Rules-Cells Containing Years Represented As 2 Digits
Numbers as TextFormulasError Checking RulesError Checking Rules-Numbers Formatted As Text Or Preceded By An Apostrophe
Formulas inconsistentFormulasError Checking RulesError Checking Rules-Formulas Inconsistent With Other Formulas In The Region
Formulas omitted cellsFormulasError Checking RulesError Checking Rules-Formulas Which Omit Cells In A Region
Protected sheet with Formulas unlocked formulasFormulasError Checking RulesError Checking Rules-Unlocked Cells Containing Formulas
Empty cells in formulaFormulasError Checking RulesError Checking Rules-Formulas Referring To Empty Cells
Table with invalid dataFormulasError Checking RulesError Checking Rules-Data Entered In A Table Is Invalid.
AutoCorrectProofingAutocorrect OptionsAutocorrect Options
SpellingProofingWhen Correcting SpellingSpelling-Ignore Words In Uppercase
SpellingProofingWhen Correcting SpellingSpelling-Ignore Words That Contain Numbers
SpellingProofingWhen Correcting SpellingSpelling-Ignore Internet And File Addresses
SpellingProofingWhen Correcting SpellingSpelling-Flag Repeated Words
SpellingProofingWhen Correcting SpellingSpelling-Enforce Accented Uppercase In French
SpellingProofingWhen Correcting SpellingSpelling-Suggest From Main Dictionary Only
SpellingProofingWhen Correcting SpellingSpelling-Custom Dictionaries
SpellingProofingWhen Correcting SpellingSpelling-French Modes
SpellingProofingWhen Correcting SpellingDictionary Language
File FormatSaveSave WorkbooksSave Files In This Format
AutoRecoverSaveSave WorkbooksSave AutoRecover Information Every n Minutes
AutoRecover LocationSaveSave WorkbooksAutoRecover File Location
Folder for FilesSaveSave WorkbooksDefault File Location
AutoRecover DisableSaveAutorecover Exceptions ForDisable AutoRecover For This Workbook Only
ServerSaveOffline Editing Options For Document Management Server FilesSave Checked-Out Files To The Server Drafts Location On This Computer
ServerSaveOffline Editing Options For Document Management Server FilesSave Checked-Out Files To The Web Server
ServerSaveOffline Editing Options For Document Management Server FilesServer Drafts Location
ColorSavePreserve Visual AppearanceChoose What Colors Will Be Seen In Previous Versions Of Excel
Direction after EnterAdvancedEditingAfter Pressing Enter, Move Selection Direction
Decimal placesAdvancedEditingAutomatically Insert A Decimal Point With N Places
Fill HandleAdvancedEditingEnable Fill Handle And Cell Drag And Drop
Override alertAdvancedEditingAlert Before Overwriting Cells With Drag And Drop
In-cell editingAdvancedEditingAllow Editing Directly In Cell
Extend rangesAdvancedEditingExtend Data Range Formats And Formulas
PercentagesAdvancedEditingEnable Automatic Percent Entry
AutoCompleteAdvancedEditingEnable Autocomplete For Cell Values
Mouse WheelAdvancedEditingZoom On Roll With Intellimouse
Time Consuming OperationAdvancedEditingAlert The User When A Potentially Time Consuming Operation Occurs
Time Consuming OperationAdvancedEditingTime Consuming Is When This Number of Cells (In Thousands) Is Affected
Numeric separatorsAdvancedEditingUse System Separators
Numeric separatorsAdvancedEditingDecimal Separator
Numeric separatorsAdvancedEditingThousands Separator
PasteAdvancedCut, Copy, And PasteShow Paste Options Buttons
InsertAdvancedCut, Copy, And PasteShow Insert Options Buttons
ImagesAdvancedCut, Copy, And PasteCut, Copy, And Sort Inserted Objects With Their Parent Cells
Recent File ListAdvancedDisplayShow This Number of Recent Documents
RulerAdvancedDisplayRuler Units
TaskbarAdvancedDisplayShow All Windows In The Taskbar
Formula BarAdvancedDisplayShow Formula Bar
ScreentipsAdvancedDisplayShow Function Screentips
Chart ElementsAdvancedDisplayShow Chart Element Names On Hover
Chart Data PointsAdvancedDisplayShow Data Point Values On Hover
Comment DisplayAdvancedDisplayFor Cells With Comments, Show No Comments Or Indicators
Comment DisplayAdvancedDisplayFor Cells With Comments, Show Indicators Only, And Comments On Hover
Comment DisplayAdvancedDisplayFor Cells With Comments, Show Comment And Indicators
ScrollbarssAdvancedDisplay-WorkbookShow Horizontal Scroll Bar (Affects one workbook only)
ScrollbarsAdvancedDisplay-WorkbookShow Vertical Scroll Bar (Workbook only)
TabsAdvancedDisplay-WorkbookShow Sheet Tabs (Workbook only)
Dates in AutoFilterAdvancedDisplay-WorkbookGroup Dates In The AutoFilter Menu (Workbook only)
Images, hideAdvancedDisplay-WorkbookFor Objects, Show Or Hide (Workbook only)
Column & row headersAdvancedDisplay-WorksheetsShow Row And Column Headers (Affects one worksheet only)
Formulas, ShowAdvancedDisplay-WorksheetsShow Formulas In Cells Instead Of Their Calculated Results (Worksheet)
Page BreaksAdvancedDisplay-WorksheetsShow Page Breaks (Worksheet)
Zero, DisplayAdvancedDisplay-WorksheetsShow A Zero In Cells That Have Zero Value (Worksheet)
Outline SymbolsAdvancedDisplay-WorksheetsShow Outline Symbols If An Outline Is Applied (Worksheet)
GridlinesAdvancedDisplay-WorksheetsGridline Color (Worksheet)
Gridline ColorAdvancedDisplay-WorksheetsGridline Color (Worksheet)
Multi-Threaded CalculationAdvancedFormulasEnable Multi-Threaded Calculation
Multi-Threaded CalculationAdvancedFormulasNumber of Calculation Threads
Links, updateAdvancedWhen Calculating WorkbookUpdate Links To Other Documents
Precision as DisplayedAdvancedWhen Calculating WorkbookSet Precision As Displayed
Dates, 1904 systemAdvancedWhen Calculating WorkbookUse 1904 Date System
External Link ValuesAdvancedWhen Calculating WorkbookSave External Link Values
Sound FeedbackAdvancedGeneralProvide Feedback With Sound
Animation FeedbackAdvancedGeneralProvide Feedback With Animation
DDEAdvancedGeneralIgnore Other Applications That Use DDE
Links, updateAdvancedGeneralAsk To Update Automatic Links
Add-in errorsAdvancedGeneralShow Add-In User Interface Errors
Paper SizeAdvancedGeneralScale Content for A4 or 8.5 x 11" Paper Sizes
Start-Up FolderAdvancedGeneralAt Start-Up, Open All Files
Web OptionsAdvancedGeneralWeb Options
Service OptionsAdvancedGeneralService Options
Menu Access KeyAdvancedLotus CompatibilityMicrosoft Office Excel Menu Key
Navigation KeysAdvancedLotus CompatibilityTransition Navigation Keys
Lotus Formula EvaluationAdvancedLotus For WorksheetLotus Transition Formula Evaluation
Lotus Formula EntryAdvancedLotus For WorksheetLotus Transition Formula Entry
QAT LocationCustomizationN/APlace Quick Access Toolbar Below The Ribbon
Add-InsAdd-InsN/AManage Excel Add-Ins
TrustTrust CenterN/ATrust Center Settings
UpdatesResourcesN/ACheck For Updates
DiagnoseResourcesN/ADiagnose
Contact MicrosoftAResourcesN/AContact Us
ActivationResourcesN/AActivate
RegistrationResourcesN/ARegister
AboutResourcesN/AAbout
[Previous] [Contents]