A1 Range Cell Count Expander

Expand an ordered rectangular A1 range in row-major order into relative addresses, rejecting reversed corners and limiting materialization to 5,000 cells.

Description

A rectangular A1 range includes both corner cells.

A rectangular A1 range includes both corner cells. Enumerating its addresses is useful for a small export or mapping task, but large ranges require a materialization limit rather than an unbounded list.^[1]

Expand an ordered rectangular A1 range in row-major order into relative addresses, rejecting reversed corners and limiting materialization to 5,000 cells.

When to use A1 Range Cell Count Expander

Use this tool to expand an ordered rectangular A1 range in row-major order into relative addresses, rejecting reversed corners and limiting materialization to 5,000 cells.

Choose the original CSV text, decoded cell strings, byte values or counts requested by this tool. Use the stated delimiter, encoding, indexing and number/date convention.

How to use A1 Range Cell Count Expander and understand its results

Choose the original CSV text, decoded cell strings, byte values or counts requested by this tool. Use the stated delimiter, encoding, indexing and number/date convention.
Enter range using the field table and calculation rules, then run the tool.
Read cellCount, addresses. The explanation below defines the units, signs, ordering and any flags or placeholder values.
If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.

Input field	Meaning	Value type; see rules below	Requirement
range	Range	string; maximum length: 65	Required

Enter two A1 corners separated by one colon. The shared parser validates their positive safe row/column indices; the ending row and column must each be at least the start. The inclusive count is computed with exact integer arithmetic and must not exceed 5,000. Nested loops enumerate rows first and columns within each row, returning uppercase relative addresses even if the input corners used dollar signs.

cellCount = (endRow − startRow + 1)(endColumn − startColumn + 1)

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output field	Meaning	Value type
cellCount	Cell count	integer; minimum: 0; maximum: 9007199254740991
addresses	Addresses	list of string

json

{
  "input": {
    "range": "B2:C3"
  },
  "output": {
    "cellCount": 4,
    "addresses": [
      "B2",
      "C2",
      "B3",
      "C3"
    ]
  }
}

Limitations and assumptions

Reversed corners, sheet-qualified references and a lone cell without a colon are errors. The tool does not enforce Excel worksheet capacity or return cell values. Absolute-reference markers are discarded from the expanded addresses.

Numeric inputs must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Extremely large text inputs are rejected. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Cell Coordinate A1 Parser: Parse one A1 address with optional absolute row and column markers, returning one-based safe indices and a canonical uppercase address; sheet names and ranges are excluded. For a complementary task, use Column Index to Letter (A1 Style): Convert a one-based safe integer column index to ASCII A1 column letters without imposing Excel worksheet width limits.

References

A1 Range Cell Count Expander — tool.io

Similar or alternative tools

Cell Coordinate A1 Parser
Parse one A1 address with optional absolute row and column markers, returning one-based safe indices and a canonical uppercase address; sheet names and ranges are excluded.
Column Index to Letter (A1 Style)
Convert a one-based safe integer column index to ASCII A1 column letters without imposing Excel worksheet width limits.