columns stop at IV

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any spreadsheet I open has a limited number of columns to the right and stops
at column IV. Is this a problem with Excel or just something I have done
with my software?
 
No, that's it. Column IV (or 256 columns), 65536 rows. Excel 2007 has more I
understand,
Regards,
Alan.
 
In Excel 2003 and earlier, you have only 256 columns, which is column IV.
This is are hard limit in Excel and cannot be increased. In Excel 2007, you
have 16384 columns, which takes you out to column XFD.

Because the file format is Excel 2007 is different than that of earlier
versions, if you open up an existing 2003 workbook in 2007, you are running
in "Compatibility Mode" and are limited to the restrictions of 2003 and
earlier.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 

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

Additional Columns past IV? 3
Excel limit that stops pivot table processing at column IV?? 2
Excel --->db IV 1
Excel columns do they exceed IV? 6
this is killing me. INDEX/MATCH "closest to X" in a smart way? 5
Need to expand Excel 2007 spreadsheet beyond column IV 2
Restarting a macro 19
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top