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