Want to become great at Excel?
Appearance of a Cell Range
A symmetrical cell range can appear as below. The notation for this range is (A1:C6); from upper left cell A1 to bottom right cell C6.
Irregular Cell Ranges
Irregular cell ranges, like in the image below, also occur. The notation for this range is (A1:C6;E2;E6;C7;C9).
A Cell Range Within a Formula
A cell range can be used inside a formula, for example to calculate the sum of the values within the selected cells. The notation for the sum of all values in cell range (A1:C6) is =SUM(A1:C6).
Larger spreadsheets are usually stuffed with formulas based on cell ranges. When spreadsheets are edited or expanded over time, different types of range issues may occur. These issues are usually hard to detect, but they can be very risky! We’ve seen big numbers and large sums of money ‘disappear’ because of range issues.
PerfectXL detects different types of range issues, like references to empty cells, interrupted formula ranges, merged cells, references to merged cells, unexpected ranges and ranges in which unexpected shifts occur.