Sorry, that's the way it is, 256 columns and 65536 rows.
It's not just the default, it's the maximum ... and, I guess, the minimum.
Every worksheet always has those dimensions, you can't make it bigger, you
can't make it smaller, though you can hide rows and columns.
Have you thought about restructuring your data or using a database ?
Have you thought about using multiple sheets instead of a single sheet? Also,
you can link Excel workbooks; i.e. multiple files linked together.
Another thought is to orient your worksheet vertically - over 65,000 rows!
I understand that the new Excel (with Vista) will have a huge number of
columns and rows. But for now we have what we have.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.