Settings in Excel 2016
When you create a data table with daily records, you can need to highlight weekends or other specific days. You don’t need to open a Calendar and do it manually, Excel proposes conditional formatting that can help you do it without any calculation.
When you work with some Excel elements such as tables, charts, you spend a lot of time on positioning them and formatting. Here will find the feature that Excel proposes to help you create a perfect presentation of your data.
By default, Excel automatically creates hyperlinks when you type or insert URLs or e-mails. You can Turn off the automatic creation of hyperlinks in Excel, or delete all hyperlinks later.
Microsoft Excel proposes a lot of different features for creating a perfect presentation of your data. One of these features is linked elements. This tip shows how to create a drop-down list and automatically show linked objects, such as image, text, hyperlink, etc. for the selected drop-down list item.
Excel automatically creates hyperlinks if you type or insert some text that Excel sees like a hyperlink such as URLs or e-mails. You can easily turn off and turn on the automatic creation of hyperlinks for more comfortable work in Excel ☺.
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.
Every time you add, move or resize shapes, by default, it isn’t easy to align them. Excel proposes features named Snap to Shape and Snap to Grid that can help to organize shape and any objects.
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.
By default, gridlines are displayed in worksheets, but you can hide the gridlines.