Skip to main content Skip to docs navigation

How Many Rows, Columns, and Cells in Excel?

On this page
On this Chapter
Number of rows column and cells in Excel

In the Excel version Excel 2003

  • Number of Rows in a worksheet: 65,000
  • Number of Columns in a worksheet: 255
  • So, the number of cells in a worksheet = 16,575,000.

In the Excel version 2007

  • Number of Rows in a worksheet: 65,536 (2^16)
  • Number of Columns in a worksheet: 256 (2^8)
  • So, the number of cells in a worksheet = 65,536 * 256 = 1,67,77,216 (2^24).

In the versions after Excel 2007

  • Number of Rows in a worksheet: 1,048,576 (2^20)
  • Number of Columns in a worksheet: 16,384 (2^14)
  • So, the number of cells in a worksheet = 1,048,576*16,384 = 17,179,869,184 (2^34) Cells.

Related FAQs:

No related posts found.

Related Articles:

No related articles found.

Leave a Reply

Registration isn't required.