How to configure Excel to exceed the limit 256 columns.

K

KIM W

Upgrade to Excel 2007. You will get thousands of columns and 1,000,000 rows
now. (I know that may not be an option, and of course once you create a
spreadsheet with >256 columns, thos columns wiull be truncated when saved as
old Excel version. Basically you will not be able to share.)
 
T

Tyro

Excel 2007 has 16,384 columns and 1,048,576 rows. Previous versions have
256 columns and 65,536 rows or less. You cannot configure Excel to change
that.

Tyro
 

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.

Ask a Question

Similar Threads

hash function for large strings 22
How do I add more columns above the 256 limit in excel? 3
why is there 256 columns and 65,536 rows in excel 5
SUMDIVISION formula function - does it exist? 6
Want more 256 column in 2007 3
Character limit 2
Test-To-Columns > 256 4
256 character limit in pivot tables 1

Top