![]() The “Advanced” category provides various advanced settings related to editing, images, graphics, charts, display, calculation, web, data models, and Lotus compatibility: – Provide feedback with sound and/or animation. The “Ease of Access” or “Accessibility” category provides accessibility settings : – Proofing language for spelling and grammar check. ![]() – Display language for tabs, menus, buttons, and dialog boxes. The “Language” category provides settings for display and proofing languages: – Where to save the autorecover versions. The “Save” category provides settings for saving and recovering workbooks: – AutoCorrect and AutoFormat during typing. The “Proofing” category provides text formatting and correction settings: – Disable automatic grouping of date/time columns in pivot tables. – Enable data analysis add-ins: Power Pivot, Power View, and 3D maps. – Disable undo for large data model operations. – Disable undo for large pivot table refresh operations to reduce time. The “Data” category provides data import and data analysis settings: – Reference style: letters or numbers for columns. The “Formulas” category provides settings related to calculation mode, formulas and error handling: – Show the start screen at the launch of Excel. – User name included in the file properties. – Default font and size for new workbooks. – Collapse the ribbon automatically when window is small. – Show Quick Analysis options on selections. The “General” category provides general settings related to: ![]() In the following table, I listed for each category a little description of its purpose, as well as the different settings that you can set there. The categories of settings provided in the Excel Options dialog box are: It is organized by categories provided in the left pane, and each category contains a lot of settings grouped by sections. Excel Options dialog box B/ Setting up Excel optionsĮxcel Options dialog box contains all the settings to customize the look and behavior of Excel application and workbooks. ![]()
0 Comments
Leave a Reply. |