Settings in Excel 2016
Change the decimal point to a comma or vice versa
When you import data into Excel spreadsheets from Internet pages or CSV files, Excel fails to
recognize some numbers and converts them to the default text type. Temporarily changing Excel
settings helps to reduce the amount of manual work and the number of errors on replacing comma
to point, dot to comma, semicolon to comma, etc. Also, you need to change decimal delimiter
settings for printing or exporting data for international users.
How to reduce ribbon size in Excel
After recent updates, the ribbon in Microsoft Excel can take up to 1/3 of the available screen
space. Microsoft Office help tells that you can
hide or unhide your ribbon,
but you cannot reduce the size of your ribbon, or size of the text or the icons. False! You can
change the mode and remove unnecessary white space around buttons, and, thus, reduce the
ribbon size.
Turn off the automatic creation of hyperlinks in Excel
Excel automatically creates hyperlinks if you type or insert some text that Excel sees like a hyperlink
such as URL or e-mail. You can quickly turn off and turn on the automatic creation of
hyperlinks for more comfortable work in Excel ☺.
How to remove green triangles from cells (hide auto-calculating checks)
When you work in Excel, by default, it automatically identifies all issues, such as incorrect data in the cell, problems with formulas, etc. So, you see green triangles (by default) shown in the top left corner of these cells.
Change color for gridlines in Excel
By default, gridlines are displayed in worksheets using a color that is assigned by Excel. But if you want,
you can change the color of the gridlines for a worksheet (see also How to turn on and turn off
gridlines in Excel and How
to change width of gridlines in Excel).
How to change width of gridlines in Excel
Gridlines help you align shapes and create consistent dimensions for each object. In Excel, gridlines are
simulated by column borders, and changing column widths and heights essentially controls your gridlines.
How to turn on and turn off gridlines in Excel
By default, gridlines are displayed in worksheets, but you can hide the gridlines.
How to customize your local Excel chart settings
The default installation of Excel has reasonable presets for chart types and colors, but you can change those
defaults according to your own preferences.
How to customize your local Excel
Excel is heavily used by all Microsoft Office users and automatically opened workbooks, customizations of the menu, recent documents, and start screen allow you to save a lot of time.
How to turn on/off the Quick Analysis feature
When you select a range of data, Excel displays a Quick Analysis button in the lower-right corner of
the range. But this option can be turned off.