D
Doctor Windows
How many total cells are there in an excel worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
Doctor Windows said: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
N
Nick Hodge
Or 17179721728
In XL2007
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
In XL2007
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
M
Max
Nick Hodge said: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>)
D
David Biddulph
.. 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)
M
Max
David Biddulph said:.. 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>
D
David Biddulph
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.