Add-ins are used to provide additional functionality to Excel.Īdd-ins Panel in Excel Options is shown below. xla extension) which loads when Excel program starts up. An Excel Add-In is a file (usually with an.

Add-ins: Add-ins Panel contains a list of available and installed add-ins.

Quick Access Toolbar Panel in Excel Options is shown below.

Quick Access Toolbar: Quick Access Toolbar Panel in Excel Options Dialog Box Window contains options to customize Excel Quick Access Toolbar (QAT).

Customize Ribbon: Customize Ribbon Panel in Excel Options Dialog Box Window contains options to customize Excel Ribbon.Ĭustomize Ribbon Panel in Excel Options is shown below.

Advanced options are again divided into 14 headings.Īdvanced Panel in Excel Options is shown below. To configure these options, the user should have a higher level of knowledge in Excel. Advanced: Advanced Panel in Excel Options Dialog Box Window contains options which Microsoft considers as advanced.Ease of Access: Ease of Access Panel in Excel Options Dialog Box Window contains options to make Excel more accessible for differently abled persons.Įace of Access Panel in Excel Options is shown below.Language Panel in Excel Options is shown below. It has options like editing language, ToolTip language, Display language, Help language etc.

Language: Lanuage Panel in Excel Options Dialog Box Window contains options related with the language used.Save Panel in Excel Options is shown below. It has options like default workbook file format, auto recovery options etc. Save: Save Panel in Excel Options Dialog Box Window contains options related with how Excel workbook files are saved.Proofing Panel in Excel Options is shown below. Proofing: Proofing Panel in Excel Options Dialog Box Window contains options related with AutoCorrection, spell check etc.Data: Data Panel in Excel Options Dialog Box Window contains options related with data import and data analysis.ĭata Panel in Excel Options is shown below.Formulas: Formulas Panel in Excel Options Dialog Box Window contains options for formulas like calculation options error checking etc.įormulas Panel in Excel Options is shown below.General Panel in Excel Options is shown below. General : General Panel in Excel Options Dialog Box Window contains commonly used settings like user interface options, options for new workbooks (like font, font size, number of sheets) etc.Following are the 12 Panels in 'Excel Options' Dialog Box window and a short description about them. Each Panel contains global settings related to it. 'Excel Options' Dialog Box window is opened as shown in below image.Įxcel Options Dialog Box Window (in Excel 2019) has 12 Panels. Click the last menu item ('Options') from the left green menu in Excel Backstage View. To open Excel Options Dialog Box Window, go to Excel Backstage View by clicking the 'File' Tab in Excel Ribbon. Excel Options Dialog Box Window is used to configure global system settings of Excel program.

Go to dialog box in excel for mac