over 65500 cells?

S

Sweden

Hallo everybody!

Any idea if it´s possible to get more then 65500 cells out of excel or
is it impossible?

Sweden
 
S

swatsp0p

Excel has 16,777,216 cells (65,536 rows by 256 columns) per sheet.

If you want more ROWS (on one sheet)... the simple answer is NO, not
possible.

Good Luck
 
B

Bill Sharpe

swatsp0p said:
Excel has 16,777,216 cells (65,536 rows by 256 columns) per sheet.

If you want more ROWS (on one sheet)... the simple answer is NO, not
possible.

Good Luck
Click to expand...
There are workarounds mentioned in previous threads here to put more
rows on additional sheets. If you absolutely need 65,537+ rows on one
worksheet you can switch to Quattro Pro, which supports up to 1,000,000
rows. However, when you get up to that amount of information you should
really consider a database instead.

Bill
 
Top