Is there a max number of columns that can be inserted in a sheet

  • Thread starter Thread starter Guest
  • Start date Start date
In Excel 97 to 2003
Worksheet size 65,536 rows by 256 columns

Last column is IV

In Excel 2007
Worksheet size 1,048,576 rows by 16,384 columns

Last column is XFD

In Help use the search term "specifications"; oddly just "specs" works in
203 but not in 2007.


BTW: please type question in the white space not in subject alone.
best wishes
 
Is there any way to increase the number of columns beyond 256 in Excel 2003?
 
If there was a way to increase that value then that value, by definition,
would not be the maximum
Sorry it that sounds rude but it is just logic
best wishes
 
My 2007 spreadsheet columns only go to IV. At one point I saved it as a 2003
file but have since re saved as a 2007file. How do I get more columns?
 
After saving as an xl2007 file, EXIT the file

or exit Excel and come back.
 
You must log in or register to reply here.

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

max number of columns allowed 3
Max If 1
Max # of Columns 2
Max Length in a row 1
Variable VBA Max Formula 2
How do I reduce the amount of columns in a sheet? 11
Find the Max & Min Delay time 2
Max only if the last month is hte highest 4

Back
Top