Excel 2016 2013 2007 2003

How to fix the chart data

You can unlink a chart from its data ranges and produce a static chart that remains unaffected by later changes in the data.

How to change columns to rows and vice versa

In some cases, you may want to change columns and rows in your data range for more convenient and impressive view. Excel proposes the fast and simple way to change columns and rows in the data range.

Adding Up/Down Bars to a line chart

If you have a line chart with two different data series, you might want to compare those series at each point along the horizontal axis. There are two different options for this, available in two locations along the Layout tab of the ribbon.

Using a custom sort order

In some cases you may want to sort your data in non-standard ways. For example, if your data consists of month names, you usually want it to appear in month order rather than alphabetically.

Paste results into cell without formulas

You may not always want to copy everything from the source cells to the destination cells. For example, you may want to copy only the current values of formulas rather than the formulas themselves.

Formatting comments

Like a common text, any comments can be formatted: Excel represents many allows you to customize most aspects of its appearance, including color, border, and margins.

Print comments

If your worksheet contains comments, you can print them as they appear on the sheet or at the end of the sheet.

Apply or remove cell borders

Exist several ways to apply or remove cell borders, you can choose anyone:

Custom cell format

Excel includes a variety of built-in formats that cover general, numeric, currency, percentage, exponential, date, time, and custom numeric formats. You can also design your own custom formats based on one of the built-in formats.

How to hide/display comment indicators

When a comment has been inserted in a cell, the little red triangle is being displayed to indicate a comment in a cell. This tip is how to hide/display this indicator.