Here's a quick way to unmerge all merged cells in a worksheet:

In some situation you can't work with workbook that consists of merged cells. To use Filter, Sort or other functions, you need to unmerge cells and put to all of them the data from merged cells. This tip shows how to do it efficiently.

The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values. Usually the initial and the final values are represented by whole columns, while the intermediate values are denoted by floating columns.

The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values. As we have shown Creating a Waterfall chart it can be created using a combination of Excel Bar charts. This tip will show you how streamline this process using Error Bar chart. The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values.

When you first start most of the Office 2013 applications, you'll see a new feature called the Start screen.

This tip will show you how to display a drop-down list in a cell.

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.

When Excel is installed, the default chart is a 2-D Column chart but you can easily change the default chart type.

Sheets can be grouped (connected) to facilitate creating or formatting two or more identical sheets. For example, you can create one sheet and copy it to two other sheets, or you can group three blank sheets and enter and format the content once-no subsequent copying required.

This tip is about how to create a pie chart such as in popular glossy magazines.