Microsoft Excel
 

How many total cells are there in an excel worksheet?
--
Doc. Williams

Microsoft Excel
 

"Doctor Windows" wrote:
How many total cells are there in an excel worksheet?

In any one sheet (in XL2003, my curr ver.),
there are 256 cols x 65,536 rows = 16,777,216 cells per sheet
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Microsoft Excel
 

Or 17179721728

In XL2007

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Max" wrote in message
...
"Doctor Windows" wrote:
How many total cells are there in an excel worksheet?

In any one sheet (in XL2003, my curr ver.),
there are 256 cols x 65,536 rows = 16,777,216 cells per sheet
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Microsoft Excel
 

"Nick Hodge" wrote:
Or 17179721728
In XL2007

... and that's xx cols by xx rows, Nick ?

I've just recently transitioned to xl2003 from xl97
(thought that was already a quantum leap over here <bg)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Microsoft Excel
 

"Max" wrote in message
...
"Nick Hodge" wrote:
Or 17179721728
In XL2007

.. and that's xx cols by xx rows, Nick ?

I've just recently transitioned to xl2003 from xl97
(thought that was already a quantum leap over here <bg)

No, its xx columns by yy rows.
(1048576 rows by 16384 columns, instead of 65536 by 256)
--
David Biddulph

Microsoft Excel
 

"David Biddulph" wrote:
.. No, its xx columns by yy rows.
(1048576 rows by 16384 columns, instead of 65536 by 256)

Thanks, David !

Sheesh, with that many cells on one sheet,
it's hard to suppress the multi-billionaire feeling ! <bg
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Microsoft Excel
 

"Max" wrote in message
...
"David Biddulph" wrote:
.. No, its xx columns by yy rows.
(1048576 rows by 16384 columns, instead of 65536 by 256)

Thanks, David !

Sheesh, with that many cells on one sheet,
it's hard to suppress the multi-billionaire feeling ! <bg

It is, however, likely to be limited in practice by the memory of your
machine.
I haven't tried it yet, as I'm waiting for a few more of the bugs to be
found by the brave beta users.
--
David Biddulph