How to configure Excel to exceed the limit 256 columns.

  • Thread starter Thread starter hp2411
  • Start date Start date
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.)
 
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
256 character limit in pivot tables 1
Want more 256 column in 2007 3
why is there 256 columns and 65,536 rows in excel 5
How do I add more columns above the 256 limit in excel? 3
Conditional formatting for values in a column that exceed a set limitwhen summed 4
66,000 excel record limit 4
Conditional IF formula using multi-dimensional arrays 2

Back
Top