Options and Settings in Excel 2013 - part II
Continued from previous tutorials website
Advanced Options in Excel 2013
In the Advanced options, note that all subgroups and settings can be adjusted: for example, here we can determine in which direction will move the cell selection after pressing Enter key on your keyboard or automatic setting of decimal places for the numbers in the cells after entering the number. Also here we can set how much we want to show the last visited workbooks (Recent Workbooks) or hide/show gridlines, etc.
- Editing options
- Cut, copy and pase
- Image Size and Quality
- Display options for this workbook:
- When calculating this workbook:
- Lotus compability
- Lotus compability Settings for:
Customize Ribbon Options in Excel 2013
In the Customize Ribbon options you will see two columns that you can add or remove certain commands on the toolbar or ribbon tab. For details, see the tutorial Toolbar in Excel 2013.
Quick Access Toolbar Options in Excel 2013
The Quick Access Toolbar options also notice two columns that you can add or remove specific commands to the toolbar for quick launch. For details, see the tutorial toolbar for quick launch commands in Excel 2013.
Add-Ins Options in Excel 2013
In the Add-Ins options you see how you can integrate or remove certain compatible plug-ins in Excel 2013 Analysis ToolPak and such like.
Trust Center Options in Excel 2013
In the Trust Center options subgroups and note that all settings can be adjusted: in this dialog box options menu is interesting Trust Center Settings ... buton which displays additional configuration options.
- Protecting your privacy
- Security & more
- Microsoft Excel Trust Center
Trust Center Settings Options in Excel 2013
Adjustments that can be done in this dialog box are related to certain elements/apps/sites etc. in which we have confidence that it will not harm our work and computer. If you click on the Trust Center Settings buton then have the option of additional settings and adjustments for these tutorials that I write for absolute beginners to us will be interesting Macro Settings. In this part of the Excel option we can set the level of security before launching Excel Workbook from an unknown source which can possibly contain Vba macros with malicious code that could harm our MS Office or PC computer.
In the Trust Center Settings options notice subgroups and that all settings can be adjusted:
- Trusted Publishers
- Trusted Locations
- Trusted Documents
- Trusted App Catalogs
- Active Settings
- Macro Settings
- Protected View
- Message Bar
- External Content
- File Block Settings
- Privacy Options
VBA Macro settings in Excel 2013