Excel makes several theories about how you want the spreadsheet and chart data you input to appear onscreen and in print each time you open a new workbook. These assumptions may or may not be appropriate for the way you operate and the spreadsheets and charts you need to produce.
The five following sections provide a fast overview of adjusting the essential standard or custom settings in the Excel Options dialogue box. With a billion tabs, this is Excel’s largest dialogue box (12 actually). You may control what appears onscreen and how it appears and when and how Excel 2021 creates spreadsheets using the Excel Options dialogue box.
Changing some of the General tab’s more general settings
The first item in the Excel Options dialogue box is the General tab (Figure below). When you initially access this dialogue box by selecting File Options or hitting Alt+FT, this tab is automatically selected.
User Interface Settings, When Developing New Workbooks, Customize Your Copy of Microsoft Office, and Start-Up Settings are the four groupings of options under the General tab.
The User Interface Options section is where you may customize your user interface.
The following checkboxes and buttons are found in the User Interface Options group:
ScreenTip Style: Modifies how ScreenTips (information about the command buttons you choose with the mouse) is presented onscreen. To show a limited amount of information in the ScreenTip and omit any links to online assistance, choose Don’t Display Feature Detail in the ScreenTips from the drop-down option, or select Don’t Show ScreenTips to eliminate the exhibit of ScreenTips from the screen (it can be confusing if you use macros in the toolbar as they use the same icon).
Activate Live Preview: Excel disables or re-enables the Live See function, which allows you to preview data in a current cell selecting using the font or style you chose from a drop-down list or gallery before applying the formatting.
On selection, show Quick Analysis Options: The display of the new QA (Quick Access) Toolbar in the bottom edge of a cell selection is disabled or enabled. The Quick Analysis toolbar has choices for styling the selection and producing new charts and pivot tables with its data.
When a selection is made, your Mini Toolbar is shown. When you right-click a cell selection or other item, it disables or re-enables the display of the mini-toolbar, which includes crucial formatting controls from the Home tab above the shortcut menu.
When using several displays, keep the following in mind: It allows you to choose to Optimize for Best Appearance rather than the default Optimize for Compatibility option so that the Excel program window, and any other windows, open on the linked display screens, appear their best.