Monday, February 26, 2018

Excel Anatomy- Part02 option and customize ribbon

Option and customize
Introduction
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.
General
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.
Formulas
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.
Proofing
Spell-check options and a link to the Auto Correct dialog.
Save
The default method for saving, Auto Recovery settings, legacy colors, and web server options.
Advanced
All options that Microsoft considers arcane, spread among 13 headings.
Quick access tool bar
Icons to customize the Quick Access Toolbar (QAT).
customize
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
language
Choose the editing language, Tool Tip language, and Help language.

No comments:

Post a Comment

Data base function

Database function Daverage function      Averages the values in a field (column) of records in a list or database that match conditio...