In excel 2007, what is the max number of columns allowed in one sheet? Thanks!
G Guest Aug 6, 2007 #1 In excel 2007, what is the max number of columns allowed in one sheet? Thanks!
G Gordon Aug 6, 2007 #2 chibimun2 said: In excel 2007, what is the max number of columns allowed in one sheet? Thanks! Click to expand... 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....
chibimun2 said: In excel 2007, what is the max number of columns allowed in one sheet? Thanks! Click to expand... 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....
G Guest Aug 6, 2007 #3 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.
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.
G Guest Aug 6, 2007 #4 Give or take a bit of shrapnel! Gizmo63 said: 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. Click to expand...
Give or take a bit of shrapnel! Gizmo63 said: 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. Click to expand...
