Comparing multiple ranges in Excel worksheets

If you have several areas in your worksheets that you want to compare, but you don't want to compare the whole worksheet (maybe it is just large and you don't want to waste time on a full comparison). Pressing [...] lets you select multiple ranges using the range-pick dialog. To select multiple ranges keep the CTRL-key pressed down.

Tutorials on comparing spreadsheets