ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   max number of columns allowed (https://www.excelbanter.com/excel-discussion-misc-queries/153115-max-number-columns-allowed.html)

chibimun2

max number of columns allowed
 
In excel 2007, what is the max number of columns allowed in one sheet?

Thanks!

Gordon

max number of columns allowed
 
chibimun2 wrote:
In excel 2007, what is the max number of columns allowed in one sheet?

Thanks!


16,384 and over 1 million rows.
If you are going to use that sort of data quantity you would be far
better off looking at a Database application....

Gizmo63

max number of columns allowed
 
Sheet size is 1 million rows by 16,000 columns.

That's 16 billion (American or New English) or 0.016 billion (Old English or
New European) cells.


"chibimun2" wrote:

In excel 2007, what is the max number of columns allowed in one sheet?

Thanks!


Gizmo63

max number of columns allowed
 
Give or take a bit of shrapnel!

"Gizmo63" wrote:

Sheet size is 1 million rows by 16,000 columns.

That's 16 billion (American or New English) or 0.016 billion (Old English or
New European) cells.


"chibimun2" wrote:

In excel 2007, what is the max number of columns allowed in one sheet?

Thanks!



All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com