How many cells do the Microsoft Excel Spreadsheet have?

Excel 2003 and earlier has 16,777,216 cells per worksheet (65,536 rows * 256 columns). Each cell can hold 32,767 characters. Each workbook can contain unlimited worksheets (limited by system memory).

Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).

It is interesting to stop and think about the actual size of a worksheet. Do the arithmetic (256 * 65,536), and we will see that a worksheet has 16,777,216 cells. Remember, this is in just one worksheet. A single workbook can hold more than one worksheet.

If we are using the standard VGA video mode with the default row heights and column widths, we can see 9 columns and 18 rows (or 162 cells) at a time.

If we entered a single digit into each cell at a relatively rapid clip of one cell per second, it would take us about 194 days, non-stop, to fill up a worksheet (longer, if our break for coffee). To print the results of our efforts would require more than 36,000 sheets of paper - a stack about six feet tall

Oh... and if you are wondering: No, it is not possible to increase the size of a worksheet. The number of rows and columns is fixed. Despite what must amount to thousands of requests to Microsoft, we simply cannot coax Excel into displaying more rows or column.

Number Of Cells In Excel

256 Columns x 65536 Rows

Total of 16777216 cells.

Unlimited

From insert menu

I think it is 35,000 across by about the same going down.

unlimited. but i don't think you'd need unlimited cells.

Hope this helps!