Max # of Columns

  • Thread starter Thread starter Sancho
  • Start date Start date
S

Sancho

Hello

What is the max # of columns in excel by default?
Is there a way to increase the # of columns

Thanks
 
You cannot increase the number of columns. It is fixed at 256 (XL2003
and earlier) or about 18K (XL2007 and later).

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
In Excel 2003, the maximum is 256 columns. In Excel 2007, the maximum is
16,384 columns. AFAIK there is no way to go beyond these limits.

Hope this helps,

Hutch
 

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

Return MAX value from column B and Name from column A 2
Max Length in a row 1
Max only if the last month is hte highest 4
finding the cell adjacent to the max value in a row with formula 4
Find the Max & Min Delay time 2
Max; Min & Dates 2
Extracting Matrix Data 3
Can offset be used in this formula? 2

Back
Top