Excel Tip: Noncontiguous selections

You can select any cells you want, regardless of whether they’re next to each other in a row or column. Hold down the Ctrl key while you click on a cell or click and drag through a range of cells. As long as you hold down the Ctrl key, you can click and select to your heart’s content.

You can also use this in conjunction with the AutoCalculate function on Excel’s status bar to analyze any combination of individual cells or blocks of cells. Just select the values you want to analyze, right-click on the status bar, and choose the desired function to see the results