| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
max number of columns allowed
In excel 2007, what is the max number of columns allowed in one sheet?
Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| allowed/taken | Excel Worksheet Functions | |||
| allowed / taken | Excel Worksheet Functions | |||
| What is the Max number of records/row allowed in Excel 2007 | Excel Discussion (Misc queries) | |||
| parameters not allowed | Excel Discussion (Misc queries) | |||
| What is the maximum allowed number of data elements in a data array? | Excel Discussion (Misc queries) | |||
Linear Mode
