ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Max # of Columns (https://www.excelbanter.com/excel-discussion-misc-queries/250748-max-columns.html)

Sancho

Max # of Columns
 
Hello

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

Thanks

Chip Pearson

Max # of Columns
 
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]



On Thu, 10 Dec 2009 14:50:01 -0800, Sancho
wrote:

Hello

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

Thanks


Tom Hutchins

Max # of Columns
 
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

"Sancho" wrote:

Hello

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

Thanks



All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com