Max columns?

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

Guest

What is the maximum number of the columns?
Is the last column really named "IV"??
 
Hi

Yes, the last column is IV - until the next release of Excel, anyway.

Andy.
 
In Excel 2003 and earlier, the maximum number of columns is 256,
and yes the last column name is "IV". Excel 2007 has about 18,000
columns.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Yep, 256, at least until 2007.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
user_u said:
What is the maximum number of the columns?
Is the last column really named "IV"??
Excel 2007 allows 2 to the 12th (16384) columns, of which the last is headed
"XFD".
 
I am using Excel 2007 and got to column IV and can't insert more columns. I
am saving the document in a compatability mode (.xls), could this be the
problem?
 
I just saved it as .xlsx and I still can't insert. Last column remains being
IV. Any advice will be great!
Thanks for helping again today.

Carolina
 
Yes.

Save the file as a normal (xl2007) style workbook.
Then close it and reopen it.
 
It worked! Can I then save it in the compatibility mode for other people with
2003 version to see?
 
Sure. But remember that you'll lose those extra columns and extra rows and any
feature that's new in xl2007.

If I knew I had to share with people who use xl2003, I think I'd keep using .xls
in compatibility mode. I think it would make a bit simpler for me.
 

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

Back
Top