Style in Excel 2013 2010 2007 2003

How to create an automatically extended or dynamic drop-down list

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.

How to create a computable drop-down list

When you fill data in some spreadsheet, it can be necessary to show different drop-down lists that depend on some filled or calculated values.

How to create a dependent drop-down list

When you fill data in some spreadsheet, it can be necessary to create dependent drop-down lists. The organization of these drop-down lists can be different – they can be filled step-by-step from left to right in the same row (like in the example below), cascading or even computed (see How to create a computable drop-down list).

How to create an equilateral triangle, a regular square, and other regular polygons in Excel

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.

Change the default font and style for shapes in Excel

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.

Change the default font for text boxes in Excel

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...

How to make your data changes in the chart more informative

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.

Four ways to improve your data presentation in Excel

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.

The best way to organize your workbook using hyperlinks

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.

Adding watermarks to workbook

This tip describes how to add watermark text or picture to your workbook.