Excel Range Size Calculator

Enter a range like C5:F10 and get columns, rows, and total cells instantly.

Columns
?
Rows
?
Total cells
?

Example: C5:F104 columns × 6 rows = 24 cells

Recent History

    How It Works

    Enter any Excel range in standard notation (e.g. C5:F10). The tool parses the column letters and row numbers to compute the dimensions:

    • Columns: number of columns in the range (F − C + 1 = 4)
    • Rows: number of rows in the range (10 − 5 + 1 = 6)
    • Total cells: columns × rows (4 × 6 = 24)

    You can also enter a full column range like C:F (without row numbers). In this case, rows will be 1,048,576 — the maximum number of rows in Excel.

    This is useful when using the OFFSET or COUNTA functions, or for auditing the size of data tables in spreadsheets.