Excel 2016 2013 2010 2003

How to count cells by criteria

Use COUNTIF if you need to sum values for a particular person or other criterion.

How to sum cells by criteria

Use SUMIF if you need to sum values for a particular person or other criterion.

Opening Workbooks Automatically

If you work with the same workbooks every day it will be helpful to open specific workbook files automatically whenever you start Excel. Any workbooks placed in the XLStart folder open automatically.

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-standart ways. For example, if your data consists of month names, you usually want it to appear in month order rather than alphabetically.

Adding a background image to the spreadsheet

You can make your Excel spreadsheets more appealing by choosing graphics file to serve as a background for a spreadsheet similar to the wallpaper that you may display on your Windows desktop.

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.

Changing a comment shape

Normally, cell comments are rectangular, but you can give a cell comment any shape you want:

Print comments

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