Style in Excel 2016
The drop-down list is a handy feature provided by Excel data validation tools. Drop-down menus limit the possible choices and help to avoid mistakes. However, not so many Excel users know the Source field of the Data Validation dialog is a formula field. Formulas in the Source field should return the list of the values, but they are not necessarily a range or a list of options.
Dynamic, dependable, conditional, or calculated drop-down list in Excel implies that the contents of the drop-down list for the current cell should depend on values in the other cell and change dynamically when the value of the controlling cell changes.
When you work with data in Excel, often you need to add more and more of new data. However, it takes some time to update formulas, charts, tables, when you add new data. Excel proposes functions that can help to customize your data and avoid routine updating. This tip is about creating an automatically extended (also known as dynamically updated or just dynamic) drop-down lists.
For some charts or diagrams, you need to create a regular polygon – equiangular (all angles are equal) or equilateral (all sides have the same length). E.g., equilateral triangle, regular square, etc.
When you create a shape in your spreadsheet, it is created with the default style and any text that you type has the default font.
When you create a text box in your document Excel, any text you type appears has the default font that can be different from version to version...
Simple line and bar charts often attract little or no interest of the audience, but Excel allows you to attract an attention to your data by emphasizing change direction, difference or period.
Using simple tricks, you can convert your Excel spreadsheet from a table with rows and columns to an interactive application that will help you to represent the date in a more appealing and convenient way.
For some workbooks with big number of sheets or to highlighting some important data, it is necessary to create hyperlinks to another cell in the same spreadsheet.
This tip describes how to add watermark text or picture to your workbook.