A non-contiguous range consists of two or more separate blocks of cells.
Both contiguous and non-contiguous ranges can include hundreds or even thousands of cells and span worksheets and workbooks.
Changes to a worksheet, such as data editing or formatting, affect the active cell.
Jurmin Tang / EyeEm / Getty Images
There a number of ways to select a range in a worksheet.
These include using the mouse, the keyboard, the name box, or a combination of the three.
To create ranges consisting of non-adjacent cells,use the mouse and keyboard or just the keyboard.
Jurmin Tang / EyeEm / Getty Images
These two references are separated by a colon.
The colon tells Excel to include all the cells between these start and endpoints.
Range vs.
Some functions, such asSUMPRODUCTandINDEX, take arrays as arguments.
Other functions, such asSUMIFandCOUNTIF, accept only ranges for arguments.
These functions extract the values from the range and translate them into an array.
On the other hand, SUMIF and COUNTIF do not accept arrays as arguments.
As a result, the program displays a message box listing possible problems and corrections.
