Unfortunately, when you try to paste a series of cells with blank cells, Paste special with Skip blanks option doesn't seem to work.

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

This tip will help you to select all cells in the worksheet in one click.

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.

To emphasize differences between data in the chart it will be interesting to create a column chart in which the color of each column depends on the value displayed.

Sometimes you want to show a single chart that consists of series that use different chart types.

When you create a chart with a scroll bar, it will be useful to create a chart with all data to see which data fragment you see in the scrolling chart.

Sometimes you need to create a chart that shows a large data amount. Then it would be useful to insert a scroll bar in your chart:

In this tip, we will show how to different charts could be combined in the one chart. For example, we will combine a Bubble chart with an Area chart: