what are the total number of rows and columns on a worksheet

A standard Microsoft Excel worksheet has 1,048,576 rows and 16,384 columns (A to XFD).

Quick Scoop

Default Excel worksheet size

• Total rows: 1,048,576 per worksheet in modern Excel versions (Excel 2007 and later, including Microsoft 365).

• Total columns: 16,384 per worksheet, labeled from column A through column XFD.

• Total cells: Multiplying rows and columns gives 17,179,869,184 cells in a single worksheet.

How people quickly check it

• Pressing Ctrl + Down Arrow jumps to the last row (row 1,048,576) and Ctrl + Up Arrow goes back to the top.

• Pressing Ctrl + Right Arrow jumps to the last column (XFD), and Ctrl + Left Arrow returns to column A.

In forum discussions, users often share these shortcuts as the fastest way to see the total number of rows and columns without doing any calculations.

TL;DR: A worksheet in modern Excel has 1,048,576 rows and 16,384 columns (A–XFD), giving over 17 billion cells.

Information gathered from public forums or data available on the internet and portrayed here.